(mysql.info.gz) MySQL Optimization
Info Catalog
(mysql.info.gz) Replication
(mysql.info.gz) Top
(mysql.info.gz) Client-Side Scripts
7 MySQL Optimization
********************
Menu
* Optimize Overview Optimization Overview
* Query Speed Optimizing `SELECT' Statements and Other Queries
* Locking Issues Locking Issues
* Optimizing Database Structure Optimizing Database Structure
* Optimizing the Server Optimizing the MySQL Server
* Disk issues Disk Issues
Optimization is a complex task because ultimately it requires
understanding of the entire system to be optimized. Although it may be
possible to perform some local optimizations with little knowledge of
your system or application, the more optimal you want your system to
become, the more you will have to know about it.
This chapter tries to explain and give some examples of different ways
to optimize MySQL. Remember, however, that there are always additional
ways to make the system even faster, although they may require
increasing effort to achieve.
Info Catalog
(mysql.info.gz) Replication
(mysql.info.gz) Top
(mysql.info.gz) Client-Side Scripts
automatically generated byinfo2html