Mike Yuen writes:
> Is there anyway to tell how many connections are currently being served by
> MySQL. I'm using this in combination with PHP. Also, does MySQL
> automatically shut down when you leave the page? I'm not using
> mysql_pconnect - just the regular mysql_connect.
Hi!
You are probably looking for 'SHOW STATUS':
http://www.mysql.com/doc/S/H/SHOW_STATUS.html
And yes, if you are NOT using mysql_pconnect, the connection to your
mysqld is closed each time. The 'p' in 'mysql_pconnect' is for
"persistant" which avoids this problem. :)
Regards,
Matt
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA
<___/ Developer
---------------------------------------------------------------------
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
