Database error: too many connections includes/class_core.php

[temsamane]

every day i got a lot of these database errors in my mail inbox.

the message is the same, but ip adresses are different.



Database error in vBulletin :

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

MySQL Error :
Error Number :
Request Date : Sunday, February 26th 2012 @ 09:45:33 AM
Error Date : Sunday, February 26th 2012 @ 09:45:33 AM
Script : http://www.WEBSITE.nl/forums/showthread.php?t=2314
Referrer :
IP Address : 76.72.167."""
Username :
Classname : vB_Database
MySQL Version :

[Lynne]

The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off by adding this to your config.php:
$config['MasterServer']['usepconnect'] = 0; But, if you still have the problem you will have to talk to your host about raising that limit. Also, see this Common MySQL Error Messages (https://www.vbulletin.com/docs/html/troubleshoot_mysql_errors)

[BigAl205]

Are you using Hostgator as your host? I used to get it all the time, but since I switched to Gigapros, I haven't had any more problems.

[temsamane]

i am using arvixe

--------------- Added 1330303775 at 1330303775 ---------------

The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off by adding this to your config.php:
$config['MasterServer']['usepconnect'] = 0; But, if you still have the problem you will have to talk to your host about raising that limit. Also, see this Common MySQL Error Messages (https://www.vbulletin.com/docs/html/troubleshoot_mysql_errors)



thank you for this respons

i tried this, but its not working lynne

[Lynne]

If that's not working, then you need to contact your host about the error.

[temsamane]

the host is telling me this:

this error indicates that your account has too many active connections to the database server at any one time. This is usually due to the site being too busy, or having some error that is not closing database connections after they are being made.
Are your database connections all coming from the same user, or do you have a unique user for each script/database that is configured?


but i don't have a lot of page views, just 1000 a day. ( i have only only database user).

The hosting cant solve this problem.

what do they mean about: 'some error that is not closing database connections after they are being made'?

can i solve this?

[Lynne]

You solve it by getting a host that allows more connections.

[Sarteck]

What Lynne said is true, but several years ago I was running into the same problem, and it was some stuff that I wrote as well as some third-party modifications that were causing the problem, clogging stuff up. So, if switching hosts is not a feasible solution for you and you do have some addons, try disabling them. If that "solves" your problem, you know the issue is with one of them--if not, then you're pretty much SoL, and just have to get a better host. XD

[temsamane]

You solve it by getting a host that allows more connections.

i think that's the best solution

--------------- Added 1330685400 at 1330685400 ---------------

What Lynne said is true, but several years ago I was running into the same problem, and it was some stuff that I wrote as well as some third-party modifications that were causing the problem, clogging stuff up. So, if switching hosts is not a feasible solution for you and you do have some addons, try disabling them. If that "solves" your problem, you know the issue is with one of them--if not, then you're pretty much SoL, and just have to get a better host. XD

i will disable all the mods for some days. We have to try everything before we leave to another host. Thanks Sarteck

[Sarteck]

Hey temsamane, just checking back to see if you got this somewhat resolved. Do you need a new host, or was it a plugin causing the problem?

[toutatis]

hey i need an answer too. please tell us truth about it.