Re: [PHP-DB] To many connections problem with LAMP
On Thu, 4 Sep 2003, Balaji H. Kasal wrote: > > > > It is usually better not to use persistenc connections. > > So drop the pmysql_connect or if you really need to use > > them set set max connections higher for mysql. > >Which problem it has? On a really busy site persistent connections will just pile up and in the end the sql server will reach its max connections limit. Unless you will do many connects per page you will virtually gain almost nothing by using persistent connections. If you absolutely need to use persistent connections you can stop max connections filling up by dropping MaxRequestsPerChild from httpd.conf to something like 150 or lower. This way unnesseccary connections get killed when the Apache child dies. -- Mika Tuupola http://www.appelsiini.net/~tuupola/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] To many connections problem with LAMP
> > > After doing some research it looks like this is a problem because I am > > using pmysql_connect instead of mysql_connect. > > It is usually better not to use persistenc connections. > So drop the pmysql_connect or if you really need to use > them set set max connections higher for mysql. Which problem it has? Bec' I am using it without any problem. Regards, --Balaji -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] To many connections problem with LAMP
On Wed, 3 Sep 2003, Merlin wrote: > After doing some research it looks like this is a problem because I am > using pmysql_connect instead of mysql_connect. It is usually better not to use persistenc connections. So drop the pmysql_connect or if you really need to use them set set max connections higher for mysql. -- Mika Tuupola http://www.appelsiini.net/~tuupola/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] To many connections problem with LAMP
From: "Merlin" <[EMAIL PROTECTED]> > I am getting more and more "to many connections" errors on my web > application buid with LAMP. > > After doing some research it looks like this is a problem because I am > using pmysql_connect instead of mysql_connect. > > Istn't it better to use persistant connections? There are about 14000 PI > the system has to serve each day. It looks like this is close to the > limit? The server itself is running on about 10%cpu. Is there a way to > increase the amount of connections possible? > > Can anybody give me a suggestion on how to solve this problem and where > to go from here? You can set a higher max connection level with a my.cnf file. It's all explained on the MySQL site. Also, make sure you read the ENTIRE PAGE (with all notes) on the mysql_connect() and mysql_pconnect() manual pages. There are really specific configurations where using pconnect() is useful, otherwise it doesn't help at all(and may hinder). ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php