Are there problems optimizing the consistency / loss of data / queries that I read about "what's bad"?

Question

As I studied the differences between Postgres and MySQL, it seemed to me that if something that I read should be assumed MySQL should be (disclaimer: after reading the rest of this sentence, you agree to read the next paragraph as well) laughter in the world RMDB: it does not use ACID by default, the network is full of tales of data loss related to MySQL and all accounts, and the query optimizer is a joke.

But none of this matters. It's easy to say that MySQL has about a million times * as much hype as Postgres (it's LA M P, not LAPP), large MySQL installations are not unheard of (LJ? Digg?) And I have not noticed a decrease in the popularity of MySQL.

This makes me wonder: are these "problems" with MySQL really bad?

So, if you used MySQL for a big enough project **, what was your experience? Have you used Postgres too? How was that worse? How was that better?

*: [edit]
**: I am well aware that for the “little things” (blogs that you have), MySQL (along with almost any other RDB) is just fine.

Answer 1

[], . . PostgreSQL .

• MySQL , , . PostgreSQL .
• EXPLAIN PostgeSQL , MySQL. . , .. , MySQL , , , , .
• - - MySQL, , . PL/pgSQL + .
• MySQL , , , . .
• PostgreSQL . , .
• PostgreSQL. , , . . , , , .
• PostgreSQL , DDL , MySQL. script, / , BEGIN/END MySQL .

, MySQL, .

Answer 2

MySQL , , , .

MySQL (). , ACID (.. , / )

, MySQL " " , ACID .

MySQL ACID . , . , , , (, , ).

, : MySQL , . , , , .

Answer 3

, , .

, ACID. , . , , , , ACID-.

ACID ( D ). .

, MyISAM ( , ) .

Answer 4

MySQL - . InnoDB - , , , .
ORM mapper - ORM ( ).

, ( ) MySQL: : Toad for MySQL MySQL.

, , SQL, MySQL, - .
, , , ( - DB2) - - . ( , , ).

Answer 5

, , , , .

MySQL . , . PostgreSQL Oracle papercuts. , .

, . . , , . - . , , , QA. MySQL , , - , . , , , - , MySQL, , .

PostgreSQL , . , MySQL . , . , - , , , , - , , /-, .

, MySQL , , . , MySQL PostgreSQL . , .

Answer 6

"" MySQL ?

, MySQL, , MyISAM.

:

MyISAM?

MyISAM , , .., , , , , 10GB . MyISAM (, , - ).

, MyISAM, , , , - FK , , , .

MyISAM, : , . , , , .., , avg 200, , MyISAM , 2 . , mysql .

, MyISAM, , MySQL . InnoDB . , , , Postgres, , .

Answer 7

, , , . . Google Facebook , MySQL Herculean, .

MySQL, :

• Take daily, weekly, monthly database snapshots. Most often, the problems you encounter should not have anything to do with MySQL; instead, it launches a farewell developer:

  REMOVE FROM mytable; # Where is WHERE?

• Use InnoDB by default, the only reason to use MyISAM is for full-text search.

• Get the database schema under source control.