Table of Contents [+/-]
SELECT and Other Statements [+/-]EXPLAINSELECT QueriesWHERE Clause OptimizationIS NULL OptimizationLEFT JOIN and RIGHT JOIN OptimizationORDER BY OptimizationGROUP BY OptimizationDISTINCT OptimizationIN/=ANY SubqueriesLIMIT Optimizationoptimizer_switch to Control the OptimizerINFORMATION_SCHEMA OptimizationINSERT StatementsUPDATE StatementsDELETE StatementsMyISAM Key CacheInnoDB Buffer PoolMyISAM Index Statistics CollectionOptimization 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 must know about it.
This chapter explains different ways to optimize MySQL and provides examples. Remember, however, that there are always additional ways to make the system even faster, although they may require increasing effort to achieve.
User Comments