mattm:It's always interesting to read MySQL haters. I think they don't really get what Real People use it for. There are tons of applications that just want to store structured data and retrieve it quickly and these people miss that. At least for LJ, the serious (as in not scalably fixable by throwing more hardware it at) bottlenecks were the databases, so having them as stupid and fast as possible was crucial; if anything, we migrated the SQL to less fancy queries over time -- removing e.g. SORT BYs from slow queries -- and so having the database support subselects, transactions, etc. was ultimately uninteresting.
