Bug #111058 MYSQL can't open new threads
Submitted: 17 May 2023 13:09 Modified: 17 May 2023 13:38
Reporter: Murillo Mach Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S5 (Performance)
Version:5.7 OS:Linux
Assigned to: CPU Architecture:Any

[17 May 2023 13:09] Murillo Mach 
Description:
Hi guys,
I'm facing a serious problem with opening new threads.

Currently the structure is active with a master-slave database serving 6,000 simultaneous users.
The demand is high and the flow has been working using cache and opening few threads.

The query returns are extremely fast.

However, at times it is necessary to open new threads and I am experiencing a limitation where I cannot create more than 50 connections.
Starts returning "Abort Connection" and crashes the system until thread flow is free (<50).
We've already checked all the settings for opening new threads and they seem to be OK, but there's something blocking it that we can't find. Here are some indices:

max_connections=151
innodb_buffer_pool_size=120G
innodb_log_file_size=36G
innodb_buffer_pool_chunk_size=16G

The slave server has 192G RAM, 24vCPUs.

If you need more details, please ask.
Thank you for your attention!

How to repeat:
Hi guys,
I'm facing a serious problem with opening new threads.

Currently the structure is active with a master-slave database serving 6,000 simultaneous users.
The demand is high and the flow has been working using cache and opening few threads.

The query returns are extremely fast.

However, at times it is necessary to open new threads and I am experiencing a limitation where I cannot create more than 50 connections.
Starts returning "Abort Connection" and crashes the system until thread flow is free (<50).
We've already checked all the settings for opening new threads and they seem to be OK, but there's something blocking it that we can't find. Here are some indices:

max_connections=151
innodb_buffer_pool_size=120G
innodb_log_file_size=36G
innodb_buffer_pool_chunk_size=16G

The slave server has 192G RAM, 24vCPUs.

If you need more details, please ask.
Thank you for your attention!
[17 May 2023 13:38] MySQL Verification Team 
Hi Mr. Mach,

Thank you for your bug report.

However, we can not process your bug report.

First of all, version 5.7 is no longer supported.

Second, and much more important, this is a forum for bug reports with fully repeated test cases. We do not see any test case that we might try to repeat with 8.0.

You are probably running out of file descriptors or some other OS resource.

Please, read the instructions that follow.

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.