often, mysql in web services, there're many situation make a mysql connection idle
for example: after php open mysql_pconnect(), finished a request, http start keep-alive
or service other pages/images which do not require mysql connection
however, the connection is still there, counted as "connection count", which is limited under "max_connection"
imagine that so many connection idling, and no more connection can be taken
so, my idea is to add setting like this:
max_connection(idle+running): 400
max_connection_running(not idle): 50
i wonder if possible to make mysqld hold a connection without start a child process
_________________________________________________________________
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
--------------------------------------------------------------------- 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
