Traffic Drive Help

[KDizzla]

I run Traffic Drive on one of my sites and it is saying all this garbage.

Warning: Too many connections in /home/virtual/site21/fst/var/www/html/td/index.php on line 3
Warning: MySQL Connection Failed: Too many connections in /home/virtual/site21/fst/var/www/html/td/index.php on line 3
Warning: Too many connections in /home/virtual/site21/fst/var/www/html/td/index.php on line 3
Warning: MySQL Connection Failed: Too many connections in /home/virtual/site21/fst/var/www/html/td/index.php on line 3
Warning: MySQL: A link to the server could not be established in /home/virtual/site21/fst/var/www/html/td/index.php on line 3

What should I do to fix it? Thank you

KD

[Freestyleman]

this is not a problem of trafficdrive actually... u have to many connections to your mysql server, so thats the reason what trafficdrive doesnt work!

regards
FSM

[Da Freak]

I've got the exact same problem, but with cjultra and comusTGP.

I thought it was my host's fault because whenever I have all those error messages (10+ times a day) my host has the same error messages on their forum, as do every other site hosted by them.

I have both my scripts using the same database because my host gave me the run around about creating a new db for the second script. So now I've just given up on them fixing it and just got on a dedicated server at rackshack, havent moved in yet though. I hope that solves my problem with those errors. Maybe yours too.

[Mr.Fiction]

http://www.mysql.com/doc/en/Too_many_connections.html

You probably either need to increase the number of MySQL connections allowed, or you might try turning off persistant connections in your PHP config. The problem with turning off persistant connections is that it seems to use quite a bit more CPU, I guess because it's constantly opening and closing connections.

Check out the MySQL docs.

[Da Freak]

Can I increase the number myself or does the host have to do that.

I can't even get into my MySQL server admin to check because it only says "too many connections"

[Mr.Fiction]

You can do it yourself if you have access to your my.cnf file. I don't know if you do or do not have that access.

If you can't get in to mysqladmin, you just need to cut off access to the site for a few seconds (maybe minutes) so that you can get a free connection. You could also restart MySQL, but then you wouldn't have access to all the mysql status info that's been building up while it's been running (which can be helpful when doing config stuff.)

If you are using SecureCRT or some other program to access your server, just do a search for my.cnf and see if it's somewhere you can get to it.

I think you can just do:

find / -name my.cnf

Once you find it, make a backup before making any changes. :-)

[untitled]

you can edit your php scripts, just search for mysql_pconnect and replace it with mysql_connect

mysql_pconnect shouldn't have been used in the first place, if it has been...