Mysql Configuration Slow query log (slowquerylog) and use log analysis tool

[View system settings for slow queries]

Mysql>Show variables like '%slow%';+---------------------------+--------------------------------+|Variable_name|Value|+---------------------------+--------------------------------+|Log_slow_admin_statements| OFF                            ||Log_slow_slave_statements| OFF                            ||Slow_launch_time| 2                              ||Slow_query_log| OFF                            ||Slow_query_log_file| /Data/Mysql/localhost-Slow.Log |+---------------------------+--------------------------------+

[Turn on slow query log]

//turn on slow query log MySQL> SetGlobal Slow_query_log= on;//set time threshold for slow query MySQL> SetGlobal Slow_launch_time=1;//is the path to the slow query log MySQL> SetGlobal Slow_query_log_file="/Tmp/Slow.Log";

[Configuration file]

[mysqld] Slow_launch_time = 1 Slow_query_log = 1 Slow_query_log_file =/tmp/slow. Log log_throttle_queries_not_using_indexes = 1

Mysql comes with log analysis tool Mysqldumpslow

Mysql Configuration Slow query log (slowquerylog) and using the Log analysis tool