[MySQL] ["Optimized collection" MySQL Database optimization collection

Three levels:

1. System level

2.mysql Configuration Parameters

3.sql Statement Optimization

===========================================================

One. System level

===========================================================

Two. MySQL parameter plane

http://www.oicto.com/mysql-explain-show/

2.1slowlog

Configure Slowlog configuration file: Log-slow-queries=/path/to/save/Slowloglong_time_query=2variable settings: Show variables like'%slow%'Set GlobalLog_slow_queries = onSet GlobalSlow_launch_time =5analysis Slowlog using the Mysqldumpslow tool Mysqldumpslow/path/to/Slowfilemysqldumpslow-S T/C/L/R-R-T N file-S Sort by C (count), T (query time), L (LockTime ), R (rows sent, the result)-R Reverse-T Top N queries