We will discuss the main performance optimization possibilities, including:

* Schema Optimization
* Server Options Tuning
* Operation Server Tuning
* Hardware Selection and Tuning
* Storage Engine Selection

* Schema Optimization
* Index Selection and Tuning
* SQL Coding Techniques
* Server Parameter Tuning Guidelines

引用
http://www.mysql.com/news-and-events/on-demand-webinars/mysql-performance-tuning.php