Support Forum

New Sub Forums Causing Site To Crash?

PS Paul Smith
Paul Smith
Member
Member since Jun 2012
96 posts
Jun 28, 2013 · 2:32 pm · Edited

I have recently added about ten sub forums to my site as a result of a query I had on here about sorting forum posts. Since I have added them, the site has been crashing very regularly throughout the day. The site is currently down again. I’ve just had an email from technical support with the following comment..

“It looks like this might be an issue with mysql running out of connections. The Max Connetions are set to 50. Would you like me to raise this for you?”

Could the addition of the new sub forums be causing the problem?

3 Answers

New Answer
YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Jun 28, 2013 · 2:39 pm

50 sounds quite low to me. Yes – the more you throw at it the more queries it will make but adding subforums should not really add that much. Plus WordPress will mostly connect to the database in a linear fashion so not that many connections should be needed (even if 50 does sound low as a default setting).

What are the actual errors that have been occurring?

PS Paul Smith
Paul Smith
Member
Member since Jun 2012
96 posts
Jun 28, 2013 · 2:58 pm

I’m not sure how to find out what the errors are/were. I’ve just received some additional information from technical support…

“When I ran a top on the server there were several php scripts for

/problem-with-post-edit-buttonome/livingon/ running. These could have caused mysql to run out of

connections. As for why all the php scripts were spawned, they could have been

legitimate traffic or an issue an is with a plugin or something that is

causing php scripts to spawn when they should not.”

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Jun 28, 2013 · 3:09 pm

Could you ask them what these php scripts were? It might prove useful to know.