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
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[21 Jul 2022 1:44] Fengchun Hua

Description:
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:
None.

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