10x Performance Improvements in MySQL – A Case Study

The slides for my presentation at FOSDEM 2010 are now available online at slideshare . In this presentation I describe a successful client implementation with the result of 10x performance improvements. My presentation covers monitoring, reviewing and analyzing SQL, the art of indexes, improving SQL, storage engines and caching.

The end result was a page load improvement from 700+ms load time to a a consistent 60ms.

10x Performance Improvements – A Case Study
View more presentations from Ronald Bradford.
Tagged with: Databases FOSDEM 2010 InnoDB MySQL Uncategorized

Related Posts

Databases General Linux MySQL Open Source

Understanding Different MySQL Index Implementations

It is important to know and understand that while indexing columns in MySQL will generally improve performance, using the appropriate type of index can make a greater impact on performance.

Read more
Databases Drizzle General MySQL MySQL Proxy Open Source

SQL Analysis with MySQL Proxy – Part 2

As I outlined in Part 1 MySQL Proxy can be one tool for performing SQL analysis. The impact with any monitoring is the art of monitoring will affect the results, in this case the performance.

Read more
Databases MySQL MySQL Users Conference 2010 Open Source

Speaking at MySQL UC 2010

My talk on 10x performance improvements – A case study has just been approved for the <a href="2010 MySQL Conference . This will be my 5th straight year speaking at the MySQL conferences.

Read more