Jump to content

MySQL Too many connections


ablaty2

Recommended Posts

You posted this only 15 mins ago and as of when I'm typing this message you site seems to be loading fine. MySQL suffers from high server load more than some other services. Looking at the server load http://heliohost.grd.net.pl/monitor/ it looks like the load was ~40 when you posted this message.

 

We have been working on making our automated server load detector better over the last few weeks, and what it will do eventually is users who create too much load will automatically be suspended. It takes some fine tuning though because a few weeks ago it suspended ~90 accounts during 12 hours, and now it doesn't seem to be suspending enough.

 

Keep in mind there are currently 7500+ accounts on stevie and if by some strange fluke each website gets a hit at the exact same time it can cause some slowdown. Not really a lot that can be done about that, but we will try to keep an eye out for abuse. That at least we can prevent.

Link to comment
Share on other sites

Ya, it has been working this evening. I was having the problem during the afternoon, but I couldn't access Helionet to post then.

 

So if it is working now (off-peak I assume) but not always during the day (peak server load I assume), then that is probably a good indicator that the problem is with the server, not my site, right?

 

Also, is the status tab in MyPHPadmin the status for all the accounts, not just mine? IE where it says 64 tables open, that means there are 64 tables open on the whole server, not just on my account, right?

 

Thanks,

Alex

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...