I’ve recently been doing a lot of work with performance tuning in MySQL. Here are a few blogs that I have found highly useful by people who are involved in some of the most serious MySQL based projects on the internet.
Zaitsev used to work as manager of High Performance Group at MySQL. Now he and Tkachenko run a consultant business specializing in high performance MySQL. He is common on the presentation circuit and has made his presentations all available. Tkachenko worked as a performance and scalability engineer under Zaitsev at MySQL. This blog contains great benchmarking and deep understanding of the MySQL infrastructure.
Mituzas currently works for MySQL and is responsible for much of the scaling and performance tuning for Wikipedia. He also worked to make WordPress much more efficient in the latest versions. His blog has some examples and tips for scaling and performance tuning. Since he has such solid real world experience with Wikipedia, these examples and explanations are truly invaluable to understanding how to work with MySQL in amazingly efficient ways.
Zawodny works at Yahoo and is responsible for the amazing MySQL administration tool mytop. When it comes to MySQL, Zawodny is likely the best recognized name. He also wrote the O’Reilly book, High Performance MySQL. He also has some informative presentations available, but they are definitely starting to become dated.
If anyone else knows of great MySQL blogs, specifically that apply to performance tuning, scaling, and optimization, please let me know.