vb.org Archive - MySQL Error: /includes/class

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - MySQL Error: /includes/class_core.php on line 311 (https://vborg.vbsupport.ru/showthread.php?t=250904)

SyRiAn BoY

09-21-2010 07:49 AM

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

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.

Quote:

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	09-21-2010 10:38 AM

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

09-21-2010 12:18 PM

I contacted the host provider they said the following:

Quote:

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/opt...ql-application

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

Paul M

09-21-2010 12:42 PM

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

09-21-2010 01:57 PM

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 ?

All times are GMT. The time now is 10:48 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01081 seconds Memory Usage 1,721KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: