My Oracle Support Banner

What is the Slow Query Log and How to Control Where the Log is Stored and What is Logged? (Doc ID 1448144.1)

Last updated on APRIL 27, 2023

Applies to:

MySQL Cluster - Version 7.2 and later
MySQL Server - Version 4.0 and later
Information in this document applies to any platform.

Purpose

Understand what the slow query log is and how to configure it.

Scope

Detailed general guidance for DBAs seeking guidance on how to configure and use it.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Enabling & Disabling
 5.1 and Later
 5.0 and Earlier
 Controlling the Destination
 5.1 and Later
 5.0 and Earlier
 Controlling the Timestamp Time Zone
 Controlling What is Logged
 long_query_time
 log_queries_not_using_indexes
 log_throttle_queries_not_using_indexes
 min_examined_row_limit
 log_slow_admin_statements
 log_slow_replica_statements
 log_slow_extra
 Monitoring
 mysqldumpslow
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.