MySQL Server Status Variables provide indicators and statistical information on the running server, but does not actually affect the server. If more comprehensive information is needed on status variables, look to 5.1.6 Server Status Variable Reference. Includes very useful Innodb data and buffer information.
Frequently Asked Questions?
Can I change the Server Status Variables?
Server Status Variables are not actually SET variables. Instead, the server is collecting statistical information on itself while running.
You can FLUSH STATUS to reset the majority of status variables to 0, after making changes, to monitor improvements. This will reset all status indicators.
How to get Server Status Variables?
SHOW GLOBAL STATUS provides current status values (session or global)
Server Status Variables are not actually SET variables. Instead, the server is collecting statistical information on itself while running.
You can FLUSH STATUS to reset the majority of status variables to 0, after making changes, to monitor improvements. This will reset all status indicators.
How to get Server Status Variables?
SHOW GLOBAL STATUS provides current status values (session or global)