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
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:


The slave server has 192G RAM, 24vCPUs.

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

Options: ReplyQuote

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

Sorry, you can't reply to this topic. It has been closed.

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.