I hate tuning MySQL….
MySQL Tuning Advice. I spent an hour or so helping a co-worker with a MySQL server that just didn’t seem to be running as fast as it ought to be. Here’s what we observed and the simple change that made the problem vanish. [Jeremy Zawodny’s blog]