WARNING: This is an Archive - Try the New TestMy.net
Home
 
Welcome, Guest. Please login or register.
 
  spcr
» Home » Database connect errors can't stop them
    
  Home    Help    Search    Login    Register  
 
News : angel Do you think your good enough to write news for testmy.net?  Shoot me a PM and you may be accepted to write for us, a title of nobility angry May 23, 2012, 09:21:43 AM
old.testmy.net forums  |  Main Forum  |  HELP!  |  Topic: Database connect errors can't stop them Advanced search
  0 Members and 1 Guest are viewing this topic. « previous next »
Topic Tools Search this topic
 Pages 1 Go Down
Author
Topic: Database connect errors can't stop them  (Read 1620 times)
dlewis23
Global Moderator
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 8165

HEY! ill put it down when im good and ready.


View Profile WWW
« on: December 10, 2006, 02:48:15 PM »
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.
Logged
 
Swimmer
Vice Admin
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 6373



View Profile
« Reply #1 on: December 10, 2006, 03:41:28 PM »
try editing my.cnf and allowing more connections to the database..

http://www-css.fnal.gov/dsg/external/freeware/mysqlTuning.html

read #3
Logged
 
dlewis23
Global Moderator
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 8165

HEY! ill put it down when im good and ready.


View Profile WWW
« Reply #2 on: December 13, 2006, 07:49:26 AM »
Quote from: Swimmer on December 10, 2006, 03:41:28 PM
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.
Logged
 
Swimmer
Vice Admin
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 6373



View Profile
« Reply #3 on: December 13, 2006, 08:41:41 AM »
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.
Logged
 
dlewis23
Global Moderator
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 8165

HEY! ill put it down when im good and ready.


View Profile WWW
« Reply #4 on: December 13, 2006, 09:00:08 AM »
Quote from: Swimmer on December 13, 2006, 08:41:41 AM
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.
Logged
 
disturbed
News Anchor
TMN Veteran
*
Offline Offline

Posts: 2067


I am and always will be disturbed.


View Profile
« Reply #5 on: December 13, 2006, 09:27:15 AM »
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
Logged
Are you down with the sickness !?

[ http://hackaday.com ]
 
dlewis23
Global Moderator
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 8165

HEY! ill put it down when im good and ready.


View Profile WWW
« Reply #6 on: December 15, 2006, 06:13:23 AM »
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.
Logged
 
Swimmer
Vice Admin
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 6373



View Profile
« Reply #7 on: December 15, 2006, 09:37:36 AM »
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.
Logged
 
dlewis23
Global Moderator
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 8165

HEY! ill put it down when im good and ready.


View Profile WWW
« Reply #8 on: December 18, 2006, 11:18:06 AM »
Quote from: Swimmer on December 15, 2006, 09:37:36 AM
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.
Logged
 
Ryan314
Sophist Member
Expert
*
Offline Offline

Gender: Male
Posts: 1667

Im Ryan..I use Comcast..and its NOT Comcastic >_<


View Profile
« Reply #9 on: December 18, 2006, 12:31:13 PM »
Quote from: dlewis23 on December 18, 2006, 11:18:06 AM
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.
Logged
Tainted-Ones.com/b/

LMFAO
 
Sparticus
News Anchor
Expert
*
Offline Offline

Gender: Male
Posts: 1551


Cox 12mb/1mb


View Profile
« Reply #10 on: December 18, 2006, 01:54:18 PM »
Quote from: Ryan314 on December 18, 2006, 12:31:13 PM

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
Logged
 
FiberOptic
TMN Friend
*
Offline Offline

Gender: Male
Posts: 473



View Profile WWW
« Reply #11 on: December 18, 2006, 01:57:56 PM »
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
Logged
Sky Broadband - 16Mb Down, 1.4Mb Up

For all Your TV and Movie Needs - http://www.telly-talk.co.uk
 
FiberOptic
TMN Friend
*
Offline Offline

Gender: Male
Posts: 473



View Profile WWW
« Reply #12 on: December 18, 2006, 01:58:27 PM »
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.
Logged
Sky Broadband - 16Mb Down, 1.4Mb Up

For all Your TV and Movie Needs - http://www.telly-talk.co.uk
 
Sparticus
News Anchor
Expert
*
Offline Offline

Gender: Male
Posts: 1551


Cox 12mb/1mb


View Profile
« Reply #13 on: December 18, 2006, 02:00:20 PM »
I just got through.
Logged
 
Print  Pages 1 Go Up
old.testmy.net forums  |  Main Forum  |  HELP!  |  Topic: Database connect errors can't stop them « previous next »
Jump to:  

  Page created in 0.218 seconds with 19 queries.
Powered by MySQL Powered by PHP Valid XHTML 1.0! Valid CSS!
 Powered by SMF 1.1.13 | SMF © 2006-2011, Simple Machines LLC
    


 

  

 

 © 2007 testmy.net - Contact - Legal - This is an older version: Try Bandwidth Speed Test v12