MySQL Error: /includes/class_core.php on line 311

[SyRiAn BoY]

I'm running 3.8.4 and am getting the following error some time to my email
vBulletin Database Error!


I get this one 200 Massages/per day to my email.


Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User sql_admin already has more than 'max_user_connections' active connections
/xxx/xxx/xxx/xxx/xxx/public_html/club/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Tuesday, September 21st 2010 @ 04:00:50 AM
Error Date : Tuesday, September 21st 2010 @ 04:00:50 AM
Script : http://www.syrianboy.net/club/index.php
Referrer :
IP Address : 65.55.3.143
Username :
Classname : vb_database
MySQL Version :


Please advice

[Eric]

That's something you'll need to contact your host about. Your reaching your limit of sql connections that the host has in place.

[SyRiAn BoY]

I contacted the host provider they said the following:



The Reason you are receiving this error is due to the maximum connections of the database per hour setting
which is set to 75,000 per user per hour. This setting is there to ensure that
the MySQL database cannot be overloaded with too many query requests.

The queries will reset every hour and is kept by user however every time the
pages on your site are accessed you are still attempting to make queries to the
database server. Because of this even though you are getting errors your script
are still accumulating the queries. As a temporary fix for this issue you can
delete and recreate your database user however this error will still come back if you do
not condense the amount of queries your script uses by optimizing your SQL
usage.
Below is a link that should help, show you how to optimize your MySQL usage:
http://www.sitepoint.com/article/optimizing-mysql-application


Actually i didn't have many users .. please advice

[Paul M]

75,000 an hour ? - thats about 21 a second, every second - thats a lot - is your site really busy, what else are you running ?

Useless reply from your host btw, and a link to a 2001 article by Mike Sullivan on indexes, which is of zero use to you. Maybe you need to look at other hosts.

[SyRiAn BoY]

No not possible 75000 , I have around 1500 visit per 1 day

I get this result from Google Analytics.

Are vBSEO hack effect our over load on the database ?
And what the best hosting for VB ?