mysql--Slow log usage

Modifying a configuration file

Show_query_log = OFF whether to turn on slow log query long_query_time = 2 time limit, over time, record slow_query_log_file =/usr/slow.log log file _queries_not_using_indexs = OFF to open the log for searches that do not use an index  

Can be modified in the configuration file, or can be modified in the client

' %query% ' ; Set global Slow_query_log = on ; Set Global 2 ; Set  log_queries_not_using_indexs = on;

More can be seen here

mysql--Slow log usage