Lists the Slow Query Logging configuration metrics and provides a brief description of each.
Table 5.28 Slow Query Logging Configuration Metrics
Name | Description |
---|---|
Log Queries Not Using Indexes Enabled (Total) | 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 (Total) | Log slow administrative statements such as OPTIMIZE TABLE, ANALYZE TABLE, and ALTER TABLE to the slow query log. |
Log Slow Queries Enabled (Total) | 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 (Total) | 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 (Total) | 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 (Total) | If a query takes longer than this many seconds, the server increments the Slow_queries status variable. |
Min Examined Row Limit (Total) | Queries that examine fewer than this number of rows are not logged to the slow query log. |
Slow Query Log File (Total) | The name of the slow query log file |