SV: [PHP-DB] Heeeeeelp!!!!!! My database is down!
| From: | Fredrik Larsson | Date: | Fri, 08 Dec 2000 17:22:12 +0000 |
| Subject: | SV: [PHP-DB] Heeeeeelp!!!!!! My database is down! | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5108@lists.php.net to get a copy of this message | ||
So in general one should use mysql_connect instead of mysql_pconnect so that
the connections are automatically closed. Why would one use mysql_pconnect
and open a persistant connection? Loading a HTML-page is very slow anyway
and the benefit of having an persistant connection would be none or very
little?
> -----Ursprungligt meddelande-----
> Från: Pavel Kalian [mailto:pkalian@ssw.cz]
> Skickat: den 8 december 2000 15:38
> Till: fredrik.larsson@larsson.tc; webmaster@port-industry.com
> Kopia: php-db@lists.php.net
> Ämne: Re: [PHP-DB] 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 that
s 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
> >
>