Re: PHP and MySQL

Options: Increase the settings in MySQL that limit how many databases can be open at once. Decrease the number of Apache children running. Basically, as long as you have more Apache children than MySQL connections available, you can get this message. Actually, have a few spare MySQL connections, so you can telnet/SSH in and use the monitor as well, and cron jobs using MySQL can run. -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm ----- Original Message ----- From: Pieter Philippaerts <Pieter@allapi.net> Newsgroups: php.general To: <php-general@lists.php.net> Sent: Friday, September 07, 2001 11:30 PM Subject: PHP and MySQL > Hello, > we're using our MySQL database quite extensively from our PHP scripts, > but sometimes everything stops working and it says "Too many connections". > Is there a problem with MySQL support from within PHP? Doesn't it close > its connections with the database when the script stops executing? > Is there anything I can do to resolve this problem? > > Regards, > Pieter Philippaerts > >