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.


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


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


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
 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

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