Want to make your MySQL applications fly? This tutorial teaches you how to optimize the speed and resource consumption of applications using MySQL. A basic understanding of SQL is necessary; the techniques are not tied to particular client languages. In this tutorial, you'll learn how to optimize Select statements, use indexes properly, and use MySQL extensions. Choose the proper MySQL table handler, and optimize MySQL database structure and the mysqld server parameters.