Slow Query Logging Configuration Metrics

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

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