Bug #107929 Threshold for slow log are different between 5.* and 8.0
Submitted: 21 Jul 2022 1:44 Modified: 21 Jul 2022 12:43
Reporter: Fengchun Hua Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[21 Jul 2022 1:44] Fengchun Hua
The threshold of slow log in 8.0 is locktime + querytime, but for 5.*, it only contains query time.

How to repeat:
set global slow_query_log=1
set global long_query_time=1

session 1:
lock table t1 write;

session 2:
select * from t1; (query time of this select statement is very short).

session 1:
unlock tables;

8.0 will record this select statement,
5.* will not record this statement.

Suggested fix:
[21 Jul 2022 12:43] MySQL Verification Team
Hi Mr. Hua,

Thank you for your bug report.

However, this change is documented in 8.0 Reference Manual and in the Release Notes.

Not a bug.