Re: Heeeeeelp!!!!!! My database is down!

Tell your ISP to decrease the idle persistent connection lifetime and/or increase the number of allowed connections in their MySQL setup... I can't remember exactly which configuration options handle it but it's described in the MySQL manual. The short time solution is to simly restart the mysql daemon which closes all the open connections and makes the server operational until the connection pool is filled up with idle connections again. This error appears usualy when there are a lot of different database users leaving the connections open, which is the exact case with webhosting servers using PHP. Cheers Pavel ----- Original Message ----- From: "Fredrik Larsson" <fredrik.larsson@larsson.tc> To: "Trond Erling Hundal" <webmaster@port-industry.com>; "PHP-DB-LIST" <php-db@lists.php.net> Sent: Friday, December 08, 2000 3:24 PM Subject: SV: [PHP-DB] Heeeeeelp!!!!!! My database is down! > How about a shitty ISP? MySQL-Connections in PHP is closed automatically on > script-termination. I can imagine that they have poorly configured system. I > had that problem with one of my ISPs. They denied to see any problem and > behaved very poorly. I have now switched to a new one with great config and > where everything rocks. > > I can imagine that some ISP imagine that a database is just to install and > then forget about.. ehmm.. > > > -----Ursprungligt meddelande----- > > Från: Trond Erling Hundal [mailto:webmaster@port-industry.com] > > Skickat: den 8 december 2000 12:54 > > Till: PHP-DB-LIST > > Ämne: [PHP-DB] Heeeeeelp!!!!!! My database is down! > > > > > > Oh my God!!!! > > I can`t run any queries to my database!!! The ISP that hosts my web site > > can`t find the error!!! > > I get the error: Too many connections... > > I suppose thats because Ive been writing some shitty > > code... well well > > What can I say... I`m a newbie! > > Any ideas of what I can do?? > > I updated all my scripts so that they`ll close ALL the mysql > > connections in > > the future, but right now that doesn`t help me alot.. > > > > What should I do??? Just sit around and wait for my ISP? > > Is there any way i can "flush" all the connections????? > > > > -Trond- > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >