MySQL Forums
Forum List  »  InnoDB

Mysql 5.7 fails to create more than 50 threads
Posted by: Murillo Mach
Date: May 22, 2023 08:13AM

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql 5.7 fails to create more than 50 threads
191
May 22, 2023 08:13AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.