Slow query log in MySQL

The slow query log records that all execution times exceed the parameters long_query_time Set the value and the number of scan records is not less than min_examined_row_limit All of SQL Statement log , Default not on .long_query_time The default is 10 second , The minimum is 0, The precision can reach microseconds .

# Slow query log 
slow_query_log=1
# Execution time parameter 
long_query_time=2

By default , Management statements will not be recorded , Queries that do not use indexes for lookup are also not recorded . have access to log_slow_admin_statements And change this behavior log_queries_not_using_indexes, As follows .

# Record management statements that execute slowly 
log_slow_admin_statements
# Record statements that execute slowly and do not use indexes 
log_queries_not_using_indexes