6.26 Show Statement Activity Metrics

Lists the Show Statement Activity metrics and provides a brief description of each.

Table 6.26 Show Statement Activity Metrics

Name	Description
Show Authors (Delta)	The total number of SHOW AUTHORS statements executed.
Show Binlog Events (Delta)	The total number of SHOW BINLOG EVENTS statements executed.
Show Binlogs (Delta)	The total number of SHOW BINARY LOGS statements executed.
Show Charsets (Delta)	The total number of SHOW CHARACTER SET statements executed.
Show Collations (Delta)	The total number of SHOW COLLATION statements executed.
Show Column Types (Delta)	The total number of SHOW COLUMNS statements executed.
Show Contributors (Delta)	The total number of SHOW CONTRIBUTORS statements executed.
Show Create DB (Delta)	The total number of SHOW CREATE DATABASE statements executed.
Show Create Event (Delta)	The total number of SHOW CREATE EVENT statements executed.
Show Create Func (Delta)	The total number of SHOW CREATE FUNCTION statements executed.
Show Create Proc (Delta)	The total number of SHOW CREATE PROCEDURE statements executed.
Show Create Table (Delta)	The total number of SHOW CREATE TABLE statements executed.
Show Create Trigger (Delta)	The total number of SHOW CREATE TRIGGER statements executed.
Show Databases (Delta)	The total number of SHOW DATABASES statements executed.
Show Engine Logs (Delta)	The total number of SHOW ENGINE ... LOGS statements executed.
Show Engine Mutex (Delta)	The total number of SHOW ENGINE ... MUTEX statements executed.
Show Engine Status (Delta)	The total number of SHOW ENGINE ... STATUS statements executed.
Show Errors (Delta)	The total number of SHOW ERRORS statements executed.
Show Events (Delta)	The total number of SHOW EVENTS statements executed.
Show Fields (Delta)	The total number of SHOW FIELDS statements executed.
Show Function Code (Delta)	The total number of SHOW FUNCTION CODE statements executed.
Show Function Status (Delta)	The total number of SHOW FUNCTION STATUS statements executed.
Show Grants (Delta)	The total number of SHOW GRANTS statements executed.
Show InnoDB Status (Delta)	The total number of SHOW INNODB STATUS statements executed.
Show Keys (Delta)	The total number of SHOW KEYS | INDEX | INDEXES statements executed.
Show Logs (Delta)	The total number of SHOW LOGS statements executed.
Show Master Status (Delta)	The total number of SHOW MASTER STATUS statements executed.
Show New Master (Delta)	The total number of SHOW NEW MASTER statements executed.
Show Open Tables (Delta)	The total number of SHOW OPEN TABLES statements executed.
Show Plugins (Delta)	The total number of SHOW PLUGINS statements executed.
Show Privileges (Delta)	The total number of SHOW PRIVILEGES statements executed.
Show Procedure Code (Delta)	The total number of SHOW PROCEDURE CODE statements executed.
Show Procedure Status (Delta)	The total number of SHOW PROCEDURE STATUS statements executed.
Show Processlist (Delta)	The total number of SHOW PROCESSLIST statements executed.
Show Profile (Delta)	The total number of SHOW PROFILE statements executed.
Show Profiles (Delta)	The total number of SHOW PROFILES statements executed.
Show Relaylog Events (Delta)	The total number of SHOW RELAYLOG EVENTS statements executed.
Show Slave Hosts (Delta)	The total number of SHOW SLAVE HOSTS statements executed.
Show Slave Status (Delta)	The total number of SHOW SLAVE STATUS statements executed.
Show Status (Delta)	The total number of SHOW STATUS statements executed.
Show Storage Engines (Delta)	The total number of SHOW STORAGE ENGINES statements executed.
Show Tables (Delta)	The total number of SHOW TABLES statements executed.
Show Table Status (Delta)	The total number of SHOW TABLE STATUS statements executed.
Show Triggers (Delta)	The total number of SHOW TRIGGERS statements executed.
Show Variables (Delta)	The total number of SHOW VARIABLES statements executed.
Show Warnings (Delta)	The total number of SHOW WARNINGS statements executed.