PDA

View Full Version : (Too many connections) Disturbed me


saadessa
11-04-2009, 08:22 AM
From time to time increase the load on server at the forum, which causes me inconvenience
And more than once by the host to stop My Account
And I get e-mails with that:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too
many connections
/home/saad6/public_html/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Wednesday, November 4th 2009 @ 11:55:18 AM
Error Date : Wednesday, November 4th 2009 @ 11:55:18 AM
Script : http://www.saad6.com/showthread.php?t=9451
Referrer :
IP Address : 115.49.90.253
Username :
Classname : vB_Database
MySQL Version :

i get many of this massege

example : The rates

30.24 22.78 36.97

How to solve this problem and how will I know which products caused the high load on the server
Is there a way to find out the reasons for this problem

JamesC70
11-04-2009, 11:46 AM
I had the same problem two or three times a day after I turned on Fulltext Search.

Reverting to vBulletin Internal Search stopped the errors for me.
Admin CP -> vBulletin Options -> Search Type

snakes1100
11-06-2009, 01:41 AM
edit my.cnf / my.ini typically located in /etc/my.cnf and change the below:
max_connections = 300
to
max_connections = 400 (Raise this value by 100 until it goes away)
save
restart mysql