James Leon Posted February 15, 2013 Share Posted February 15, 2013 a. c0rs0b. steviec. netxure.com I appreciate a lot your support. Best Regards, Link to comment Share on other sites More sharing options...
Ice IT Support Posted February 15, 2013 Share Posted February 15, 2013 Your account was suspended for causing high MySQL load. I have unsuspended your account, but please try to limit the MySQL load you put on our servers as it slows down MySQL for not only your site, but MySQL for all of the other HelioHost users sharing your server. If you still see the suspended page, please clear your cache. Link to comment Share on other sites More sharing options...
James Leon Posted February 16, 2013 Author Share Posted February 16, 2013 I disabled all my mysql users and will try to find out why there is so big load on my schemas. I will enable it few by few while I try to find out what is going on with my DB.I only have one concern: What is the max db load allowed? Link to comment Share on other sites More sharing options...
Krydos Posted February 16, 2013 Share Posted February 16, 2013 There is no numerical value for what is too much load unfortunately (and fortunately in some ways.) Basically, if MySQL is no longer performing up to a certain standard the cause is determined. If the cause is abuse by users the highest MySQL load user is suspended first, and then the second and so on down the line until MySQL is once again performing within the parameters. Since this is a shared host we have our settings tuned to favour many small fast queries. If your queries are huge and complex and take a long time to execute you have a higher chance of being suspended for them. Also if you forget to close your MySQL connections or use persistent connections you have a much higher chance of being suspended. Furthermore, if your account is located on Stevie you have a much higher chance of being suspended as the normal operating parameters on Stevie are tighter, and we let Johnny users go a lot crazier before they earn themselves a suspension. This can sometimes lead to load spikes and downtime on Johnny, but we figure it's best to offer one fast, stable server (Stevie) and one server with a lot more freedom to experiment and a lot more freedom from suspensions (Johnny). That way users can choose which they would rather have. Some other hosts have a set limit of how much load each account can cause before they are suspended. This policy can sometimes lead to unnecessary suspensions in my opinion though, because as long as it doesn't negatively affect the performance of the server as a whole who cares if some number is higher than another number? We allow our users to do whatever until it starts to affect the other users on the server. Link to comment Share on other sites More sharing options...
Recommended Posts