MySQL and high loads?

Question

MySQL

As far as I know, MySQL does not perform well under heavy loads. If so, I would like to know the reason and compare this DBMS with another one (PostgreSQL, MS SQL, Oracle) in highly loaded projects.

Answer 1

even google uses mysql, though apparently modified (fix fixes are available. )
even facebook uses mysql,
I’m silent about VK .. (although everyone cackles there that they have their own DBMS)
The company has a project of 8M requests per day, regular mysql
Rested when there were brakes in PHP, too ate a lot.
They sawed out (partially) PHP was replaced with bare ngnix + mysql = profit.
What is it for?
Problems need to be addressed as they come up. Here the project will shoot further, you will already think.

Answer 2

Tell someone at badoo that mysql is not suitable for "heavy" workloads.
And in general, what is a "high" load? How much, how, where?
The "muscle" is fine with maintaining "loads", if properly configured, use denormalized tables, arrange indexes, profile queries, and so on. The same applies to any other DBMS. Otherwise, nothing will save you from the brakes.
Do not engage in premature optimization and read less Soviet newspapers.

Answer 3

google: mysql vs postgres