DOh! i mean script_append part ;) .. basically it's a garbage collector..
On Thu, 17 Jul 2003 [EMAIL PROTECTED] wrote: > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
