The slow query log
The slow query log (or simply slow log) stores SQL statements that take too long to execute. To enable it, the slow_query_log
variable or the --slow-query-log
startup option can be set to 1
. To explicitly disable the log, the --slow-query-log
startup option must be set to 0
. Without passing any arguments, the --slow-query-log
startup option enables this log. As the slow_query_log
variable is dynamic, the slow query log can be enabled or disabled at runtime.
The default filename of the slow query log is the server's hostname followed by the -slow.log
suffix.
Just like the general query log, the slow query log can be a file, table, or both. The log output server variable can be used to specify if the log is a table or file. The allowed values to be set are FILE
, TABLE
, and NONE
(which disables both the slow query log and the general query log). A combination of these values (separated by a comma) is allowed. The NONE
value overrides other values.
For example, if the hostname...