Bug #111052 Mysql connections will hang for several minutes
Submitted: 17 May 2023 0:49 Modified: 17 May 2023 12:24
Reporter: Gregory Fishbein Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.7.40-enterprise-commercial-advanced-lo OS:Windows
Assigned to: CPU Architecture:Any

[17 May 2023 0:49] Gregory Fishbein
Description:
Occasionally the MySql server will stop responding, no new connections will be successful and existing connections will hang. This will last for several minutes, with the server using no CPU and no active queries, then it will start working again.

How to repeat:
This occurs randomly around one every couple of days.  We don't know the cause, the server is not under a lot of load and there are not an abnormal number of connections.
[17 May 2023 12:24] MySQL Verification Team
Hi Mr. Fishbein,

Thank you for your bug report.

Do note that this is a forum for the bug reports with repeatable test cases. We do not see any test case in your report. Also, be noted that, soon, 5.7 will not be maintained any more.

There are many possible cases for the behaviour. You ran out of file descriptors, CPU overload, high swapping and similar. 

Can't repeat.
[20 Sep 2023 1:39] Jervin Real
See https://bugs.mysql.com/bug.php?id=112302 possibly related