The Slow Query Log

The Slow Query Log. To learn more about the MySQL slow query log visit MySQL. The MySQL slow query log is where the MySQL database server registers all queries that exceed a given threshold of execution time.

The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. We have a MySQL 5152 Percona Server 116 instance that suddenly started logging every single query to the slow query log. Mysqldumpslow -a varlogmysql-slowlog.

Slow_query_log1 long_query_time1 log_outputFILE slow_query_log_filevarlibmysqlslowlog.

The slow query log records all of the queries that are fulfills the criteria specified by the slow query log settings. Locate the configuration section mysqld. To see if slow query logging is enabled enter the following SQL statement. To learn more about the MySQL slow query log visit MySQL.