Lesser-Known MySQL Performance Tips

dolphins by talkrhubarb
"dolphins" by talkrhubarb
I thought I knew a fair bit about MySQL before I started working on Wesabe, but I was wrong. Once your tables start to get really massive, all sorts of fun issues come out of the woodwork. There are a thousand articles out there on the basics of database optimization (use indices, denormalize when necessary, etc.), so I'm not going to cover those again. Here are some tips--most specific to MySQL--that I've learned on the job:

Update:

I’ll add more as we come across them. If you have any other non-obvious tips, leave them in the comments or email me ([email protected] this domain) and I’ll add them too.

By the way, an invaluable book for learning how to squeeze the most out of MySQL is High Performance MySQL, by Jeremy Zawodny and Derek Balling.

Tweet