MySQL Slow query

Some settings for MySQL slow query

1) Check to see if MySQL turns on slow query log
Show variables like ' Slow_query_log ';
2) Set non-indexed records to slow query log
set global log_queries_not_using_indexes=on;
3) See how long SQL is logged to the slow query log
Show variables like ' Long_query_time '
4) Turn on slow query log
Set global Slow_query_log=on

5) View the log record location
Show variables like ' Slow_query_log_file '

6) Set the path of the slow query

Set global slow_query_log_file= '/home/mysql/mysql_slow.log '

Slow-scan analysis tools

Mysqldumpslow

Pt-query-digest

MySQL Slow query