The Slow Query Log Mysql. When you have chosen to log to a table the slow query log can be found in the table mysqlslow_log. You can change the value dynamically and you can specify either a single value or a comma separated list of values for example.
Pinpoint Problems To Find The Root Cause Of Performance Issues. The mysqlslow_log table stores the contents of the Slow Query Log if slow logging is active and the output is being written to table see Writing logs into tables. Pinpoint Problems To Find The Root Cause Of Performance Issues.
The easiest way to do this is to use the slow query log.
Slow_query_log_file slow-querylog long_query_time 2. Flushing logs takes time. Time the query began. You can change the value dynamically and you can specify either a single value or a comma separated list of values for example.