Christopher Book wrote:
> 
> No, I'm not using mysql_pconnect, and my apache configuration seems fine.  I
> don't have very many users at the moment so there is no reason for the
> connections filling up.
> 
> >>This can be due to your apache configuration. do you use mysql_pconnect
> function in php. Check you apache setting agains MaxClients StartServers and
> etc...
> 

Try adding something like set-variable=wait_timeout=1800 to your my.cnf.
We found that when using mysql_pconnect the connections stuck around for
far to long. MySQL's default is pretty high for a webserver that gets a
few hits.

After adding wait_timeout=1800 we have never seen 'too many connections'
again. We still use mysql_pconnect.

Regards,

Arne

-- 
--------------------------------
Arne K. Haaje   | T: 69 92 04 90
Enebakkveien 2  | F: 69 92 04 91
1625 Tomter     | M: 92 88 44 66
--------------------------------

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to