Oracle Enterprise Manager for MySQL Database

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

NameDescription
Log Queries Not Using Indexes EnabledIf 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 EnabledLog slow administrative statements such as OPTIMIZE TABLE, ANALYZE TABLE, and ALTER TABLE to the slow query log.
Log Slow Queries EnabledThis 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 EnabledWhen 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 EnabledIf 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 TimeIf a query takes longer than this many seconds, the server increments the Slow_queries status variable.
Min Examined Row LimitQueries that examine fewer than this number of rows are not logged to the slow query log.
Slow Query Log FileThe name of the slow query log file


MySQL Documentation Library