Re: MySQL 5.5 hangs frequently in production environment
Set max_connections 200 and see what happens.
What is your application like? It seems that it is asking for too many simultaneous connections. Can it be throttled.
The problem is that lots of things are started, but they are not finishing fast enough. If fewer were started, the contention would be less.
Provide these for further analysis:
SHOW GLOBAL STATUS;
SHOW VARIABLES;
Subject
Views
Written By
Posted
2433
June 21, 2014 04:10AM
1454
June 26, 2014 08:12PM
1224
June 30, 2014 05:22AM
Re: MySQL 5.5 hangs frequently in production environment
1056
July 02, 2014 07:38PM
1351
July 03, 2014 06:03AM
1361
July 05, 2014 12:00PM
1124
July 14, 2014 11:00PM
1231
August 25, 2014 04:17AM
1015
August 26, 2014 06:16PM
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.