Advanced MySQL Query and Schema Tuning

Database Administration
24 April 1:00pm - 1:50pm @ Ballroom B

Tuning Queries and Schema/Indexes can significantly increase performance of your application and decrease response times.
For example (assuming appropriate hardware and MySQL configuration):
1. Additional my.cnf tuning (after the initial tuning): 10% performance increase
2. Schema, indexes and query tuning: up to 1000% (or even more) response time increase

In this presentation we will focus on the following advanced topics:
1. Group by and order by optimizations
2. MySQL temporary tables and filesort
3. Using covered indexes to optimize your queries
4. Loose and tight index scan in MySQL
5. Using summary tables to optimize your reporting queries
6. New MySQL 5.6 Optimizer features and improvents
7. Benchmark results
and much more

Speakers

Alexander Rubin
Principal Consultant, Percona
Biography: 
Alexander has over 10 years industry experience with the MySQL database and related technologies. His specialties are performance tuning, full text search, high availability, reporting, database infrastructure scale-outs and datawarehouses. He has helped many MySQL customers design extremely high performance databases with optimized schema and queries.

Slides