From: Ben Clewett
Date: May 30 2008 10:33am
Subject: SHOW GLOBAL STATUS
List-Archive: http://lists.mysql.com/mysql/213118
Message-Id: <483FD7F2.2030002@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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