Bug #113844 The execution time of queries and written statements took a long time
Submitted: 1 Feb 3:30 Modified: 2 Feb 1:54
Reporter: aa bb Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S5 (Performance)
Version:8.0.16 OS:Ubuntu
Assigned to: CPU Architecture:Any

[1 Feb 3:30] aa bb
In the binlog see exec_time time has exceeded 100 seconds or even some reached more than 800 seconds. Indicates that the execution of the transaction has hung. Check the CPU 、 memory and IO seem to be normal, maintaining a low value

How to repeat:
Can’t repeat
[1 Feb 3:32] aa bb
node status

Attachment: screenshot-20240201-113138.png (image/png, text), 111.62 KiB.

[1 Feb 3:33] aa bb
This abnormal behavior lasted for 16 minutes
[1 Feb 11:44] MySQL Verification Team
Hi Mr. bb,

Thank you for your bug report.

However, let us inform you that this is a forum for reports with fully repeatable test cases. Those test cases should consist of the set of SQL statements and (if necessary) used settings.

Then and only then can we process the bug report. 

You have not provided us with anything similar to the test case.

Also, let us inform you that the release you are using is ancient. Hence, try to send us a repeatable test case that shows a bug in 8.0.36.

Can't repeat.
[2 Feb 1:54] aa bb
Thank you for your reply. Due to this bug, it suddenly appeared and lasted for 16 minutes. I cannot repeat it. Currently, I am trying to upgrade the version to solve it
[2 Feb 11:15] MySQL Verification Team

Please, let us know if you the problem appears on 8.0.36.

If it does, please send us a fully repeatable test case.

Thanks in advance .......