dlewis23 Posted December 10, 2006 CID Share Posted December 10, 2006 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. Link to comment Share on other sites More sharing options...
Swimmer Posted December 10, 2006 CID Share Posted December 10, 2006 try editing my.cnf and allowing more connections to the database.. http://www-css.fnal.gov/dsg/external/freeware/mysqlTuning.html read #3 Link to comment Share on other sites More sharing options...
dlewis23 Posted December 13, 2006 Author CID Share Posted December 13, 2006 try editing my.cnf and allowing more connections to the database.. http://www-css.fnal.gov/dsg/external/freeware/mysqlTuning.html read #3 I tried that, increased it to 500 and still got the problem. I don't see how im getting 500 connections open at one time. Link to comment Share on other sites More sharing options...
Swimmer Posted December 13, 2006 CID Share Posted December 13, 2006 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. Link to comment Share on other sites More sharing options...
dlewis23 Posted December 13, 2006 Author CID Share Posted December 13, 2006 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. Link to comment Share on other sites More sharing options...
disturbed Posted December 13, 2006 CID Share Posted December 13, 2006 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 Link to comment Share on other sites More sharing options...
dlewis23 Posted December 15, 2006 Author CID Share Posted December 15, 2006 ok im still having the problem. I contacted support for my host and they have no idea why it does it because it only does it in the morning for a few hrs and not during the high traffic time of the site. Link to comment Share on other sites More sharing options...
Swimmer Posted December 15, 2006 CID Share Posted December 15, 2006 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. Link to comment Share on other sites More sharing options...
dlewis23 Posted December 18, 2006 Author CID Share Posted December 18, 2006 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. Link to comment Share on other sites More sharing options...
Ryan314 Posted December 18, 2006 CID Share Posted December 18, 2006 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. Link to comment Share on other sites More sharing options...
Sparticus Posted December 18, 2006 CID Share Posted December 18, 2006 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 Link to comment Share on other sites More sharing options...
FiberOptic Posted December 18, 2006 CID Share Posted December 18, 2006 Same here! Took a couple of refreshes and im on; mySQL: Too many connections on line 5 in /var/www/vhosts/uploadingit.com/httpdocs/includes/mysql.class.php Link to comment Share on other sites More sharing options...
FiberOptic Posted December 18, 2006 CID Share Posted December 18, 2006 Get this message when I try and get on the forum; Connection Problems Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later. Link to comment Share on other sites More sharing options...
Sparticus Posted December 18, 2006 CID Share Posted December 18, 2006 I just got through. Link to comment Share on other sites More sharing options...
Recommended Posts