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...
