Jump to content
Sign in to follow this  
dlewis23

Database connect errors can't stop them

Recommended Posts

over the last few days ive gotten quite a few emails from people saying that they are getting the MYSQL error for too many connections on the database, and ive been working for the last few hours but haven't been able to figure it out. i only have 400,000 records in my database. Does anyone here know of anything that i should try so that i don't have these errors anymore.

Share this post


Link to post
Share on other sites

are you sending the kill statement at the end of your php files?  I am wondering if the connections are taking to long to time out.

yes i am sending the kill statement. I increased the max connections to 1000 and it seems to be working ok for now but not that many people are on my site right now so time will tell.

Share this post


Link to post
Share on other sites

I dont know if this relates to your problem but I know that some FTP clients when I use them, go wild, openning 10+ connections even though it is not needed - so while you might not be getting 500 actual unique connections, you might be getting a smaller number of people connecting at same time using multiple threads.....

hope this helps ;)

good site however ;) i signed up ! - i find it very useful

Share this post


Link to post
Share on other sites

when are you running your backups?  i am wondering if during the backup the tables are being locked causing the db connect not to work.

im not running any backups. im doing them all by hand for now.

ive done a little more research and it seems to start happening at about 5am est till 11am est hen i have the least amount of traffic then for the rest of the day it is fine.

Share this post


Link to post
Share on other sites

im not running any backups. im doing them all by hand for now.

ive done a little more research and it seems to start happening at about 5am est till 11am est hen i have the least amount of traffic then for the rest of the day it is fine.

This is the exact error i just got one minute ago.

mySQL: Too many connections on line 5 in /var/www/vhosts/uploadingit.com/httpdocs/includes/mysql.class.php

dont know if it will help or not.

Share this post


Link to post
Share on other sites

This is the exact error i just got one minute ago.

mySQL: Too many connections on line 5 in /var/www/vhosts/uploadingit.com/httpdocs/includes/mysql.class.php

dont know if it will help or not.

Hmmm, same for me to and it's in the afternoon.

mySQL: Too many connections on line 5 in /var/www/vhosts/uploadingit.com/httpdocs/includes/mysql.class.php

EDIT: I have no idea if this can help but here it is

http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html

Share this post


Link to post
Share on other sites
Sign in to follow this  

×
×
  • Create New...