SHOW GLOBAL STATUS

[Ben Clewett <ben@xxxxxxxxxxxxxx>]

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx