Slow Query Log not recording queries that executed faster than .001 second on Windows
(Doc ID 2376173.1)
Last updated on FEBRUARY 21, 2019
Applies to:
MySQL Server - Version 5.6 to 8.0 [Release 5.6 to 8.0]Information in this document applies to any platform.
Symptoms
The Slow Query Log is enabled
The value of --long-query-time can be expressed as a positive multiple of microseconds or zero. The value chosen is .000999 seconds or smaller.
Queries that execute faster than 1000 microseconds (.001 seconds) are not appearing in the Slow Query Log
You are using a Windows build of MySQL lower (older) than 5.6.39, 5.7.21, or 8.0.4
Cause
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
Symptoms |
Cause |
Solution |
References |