7.31 Slow Query Logging Configuration Metrics

Lists the Slow Query Logging configuration metrics and provides a brief description of each.

Table 7.31 Slow Query Logging Configuration Metrics

Name	Description
Log Queries Not Using Indexes Enabled	If you are using this option with the slow query log enabled, queries that are expected to retrieve all rows are logged.
Log Slow Admin Statements Enabled	Log slow administrative statements such as OPTIMIZE TABLE, ANALYZE TABLE, and ALTER TABLE to the slow query log.
Log Slow Queries Enabled	This option enables logging to the slow query log, which contains entries for all queries that have taken more than long_query_time seconds to execute.
Log Slow Slave Statements Enabled	When the slow query log is enabled, this option enables logging for queries that have taken more than long_query_time seconds to execute on the slave.
Log Throttle Queries Not Using Indexes Enabled	If log_queries_not_using_indexes is enabled, the log_throttle_queries_not_using_indexes variable limits the number of such queries per minute that can be written to the slow query log.
Long Query Time	If a query takes longer than this many seconds, the server increments the Slow_queries status variable.
Min Examined Row Limit	Queries that examine fewer than this number of rows are not logged to the slow query log.
Slow Query Log File	The name of the slow query log file