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
2445
June 21, 2014 04:10AM
1458
June 26, 2014 08:12PM
1228
June 30, 2014 05:22AM
Re: MySQL 5.5 hangs frequently in production environment
1063
July 02, 2014 07:38PM
1355
July 03, 2014 06:03AM
1372
July 05, 2014 12:00PM
1131
July 14, 2014 11:00PM
1233
August 25, 2014 04:17AM
1021
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.