Suggestion.. make a small script called closeall.php .. basically it has some code to force closed the mysql connection opened (be sure to run a close for all openened handles)
I have seem some sites code that actually open multiple connections to the same database.. Add this file into php.ini under the script_prepend part (gets run after all other scripts are done) .. Perhaps something is getting left open/not closing properly? On Thu, 17 Jul 2003, Eben Goodman wrote: > I run a site that gets a fair amount of traffic throughout the day. For > days at a time the site runs smoothly, and then, at seemingly random > intervals I get the mysql error "Too many connections". The only > solution for this is to stop the mysql service and restart it. I > changed the max_connections variable to allow for 300 connections > instead of the default 100. When I view processes when the error occurs > the process list is totally flooded with mysql processes. > > I am using php to establish connections and using the mysql_connect() > function, not mysql_pconnect. I used to use the pconnect function and > it seemed to produce the Too many connections error more frequently. > I'm at a bit of a loss with this, any tips on how to address this are > greatly appreciated. > > thanks, > > Eben > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
