> Hi, > > My website database allows 300 connections, but every once and a while the > database stops accepting new connections saying that there is too many. > PHP *should* automatically close connections when my scripts end, but > perhaps its not doing that. > > Anyhow, is there a way to have my connections timeout faster, when they're > inactive for a short period of time, say 10 seconds or so? > Show processlist doesn't show any activity so all 300 of the connections are > doing nothing. >
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... --------------------------------------------------------------------- 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