Oracle Enterprise Manager for MySQL Database
Lists the Show Statement Activity metrics and provides a brief description of each.
Table 6.29 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 Source Status (Delta) | The total number of SHOW SOURCE STATUS statements executed. |
| Show New Source (Delta) | The total number of SHOW NEW SOURCE 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 Replica Hosts (Delta) | The total number of SHOW REPLICA HOSTS statements executed. |
| Show Replica Status (Delta) | The total number of SHOW REPLICA 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. |