In the last episode (May 02), Mailing List Receiver said: > We weekly rotate the mysqld log. I need to find a way to query the > server to see how many current connections with clients there are, > so I can wait to restart the server when the number of connections > is zero. mysqladmin doesn't seem to have this capability. > Is there any other way?
"SHOW STATUS LIKE 'threads_connected'" will tell you how many clients are currently connected, but you should't need to bounce mysqld at all. "FLUSH LOGS" will tell mysql to reopen its logfiles without restarting. See http://dev.mysql.com/doc/mysql/en/Log_file_maintenance.html -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
