List:General Discussion« Previous MessageNext Message »
From:Ben Clewett Date:May 30 2008 10:33am
Subject:SHOW GLOBAL STATUS
View as plain text  
I am trying to optimise MySql making extensive use of the variables in 
"SHOW GLOBAL STATUS."

I want to reset these to zero on a nightly basis.

The manual states:

"Many status variables are reset to 0 by the FLUSH STATUS statement"

http://dev.mysql.com/doc/refman/5.1/en/server-status-variables.html

In fact this only effects a very few variables.

Does any member know a more complete method of resetting these, other 
than restarting MySql?

Regards,

Ben Clewett
Thread
SHOW GLOBAL STATUSBen Clewett30 May