MySQL performance tuning


Jay Pipes, MySQL employee and co-author Pro MySQL, gave a great presentation to Google employees which covers a number of techniques for tuning performance on MySQL. His examples include debugging and analyzing problems as well as best practices for table and index design, query and join operations, and server variable adjustments.

It’s a little over 40 minutes long, but incredibly informative, whether you’re a casual querier or a power MySQL user. Though some of this stuff is MySQL (or MyISAM or InnoDB) specific, the majority of the content is essential material for the average database application developer.

If you don’t have time to sit through it (shame on you) or you’re looking to jump right to a specific topic, there’s a nice time-coded dissection of the talk over at Peteris Krumins’ blog. There’s something so appropriate about adding a search index to a video about MySQL optimization.

Performance Tuning Best Practices for MySQL
Video Index

0 thoughts on “MySQL performance tuning

  1. Anonymous says:

    > If after sixty seconds you find you are still alive,
    > then the many-worlds interpretation is true, because
    > there is only about a one in (…) chance of surviving
    > in front of the Quantum Suicide machine for a full
    > minute

    I disagree. I think the chance of the machine malfunctioning is WAY bigger than the chance that the many-worlds interpretation is true. If I had a nickle for every machine that malfunctioned…

  2. samurai1200 says:

    is it just me, or did this article just make a donnie darko reference? or was that his head…

Discuss this article with the rest of the community on our Discord server!


Maker Faire Bay Area 2023 - Mare Island, CA

Escape to an island of imagination + innovation as Maker Faire Bay Area returns for its 15th iteration!

Buy Tickets today! SAVE 15% and lock-in your preferred date(s).