This tutorial is for all those database developer gun-slingers who want to rid their applications of poorly performing queries and their outlaw cousin, the inefficient schema.

Take aim at poor application performance by learning how to read and understand MySQL query execution plans and tailor your SQL code and schema for optimal performance and scalability. The tutorial is designed as a hands-on workshop that demonstrates how query and index tuning can dramatically decrease application response time and make your all-important customer happy.

All of the following core concepts will be covered in detail:

• The ins and outs of the MySQL query optimization process
• The EXPLAIN command, in-depth
• Profiling queries using the SHOW PROFILE command new in MySQL 5.0.35 Community Server

Hands-on demonstrations of:

• How simple changes to indexing or schema design have dramatic effects on performance
• How to set up a simple, but effective, benchmarking framework on your local development machine to harness techniques you learn during the tutorial

While there are some rather advanced topics covered in the tutorial, audience members with light to intermediate experience using MySQL should be able to follow along with the material. Laptops aren't required, but for those who do have one, the tutorial is designed so attendees can follow along with the demonstrations on their laptops using a local instance of MySQL.