Re: too many connection error driving me nutz, need advice

2003-07-17 Thread colbey
On Thu, 17 Jul 2003, Eben Goodman wrote: > This comment confuses me: > I have seem some sites code that actually open multiple connections to the > same database.. I have worked on some larger sites that 30+ past and current developers worked on.. Some good, some terrible.. The code typically

Re: too many connection error driving me nutz, need advice

2003-07-17 Thread Eben Goodman
This comment confuses me: I have seem some sites code that actually open multiple connections to the same database.. If I am using php's mysql_connect() function, then every time a query is run this function gets run. Wouldn't this mean that for every query a new "connection" is opened to the s

Re: too many connection error driving me nutz, need advice

2003-07-17 Thread colbey
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 opene

Re: too many connection error driving me nutz, need advice

2003-07-17 Thread colbey
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 u

too many connection error driving me nutz, need advice

2003-07-17 Thread Eben Goodman
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_conne