>> MySQL is optimized for one thing: applications that don't give a damn
>> about data integrity. Like most PHP applications.
>> 
>> If you want something that actually protects your data, use something
>> else. Hell, SQLite is better than MySQL for that.
> <...>
>
> Ok, it is obvious that you don't like MySQL that much, but I am really
> interested
> in technical details why do you make such claims.
> Can you provide some?

http://sql-info.de/mysql/gotchas.html

And to be fair...

http://sql-info.de/postgresql/postgres-gotchas.html

Don't know how up todate it still is, but you can read them to find out :)