Oracle Enterprise Manager for MySQL 数据库用户指南 / 第 6 章指标 /
6.26 显示语句活动指标
列出 Show Statement Activity 指标并提供每个指标的简要说明。
表 6.26 显示语句活动指标
| 姓名 | 描述 |
|---|---|
| 显示作者（增量） | 执行的 SHOW AUTHORS 语句的总数。 |
| 显示 Binlog 事件（Delta） | 执行的 SHOW BINLOG EVENTS 语句总数。 |
| 显示二进制日志（增量） | 执行的 SHOW BINARY LOGS 语句的总数。 |
| 显示字符集（增量） | 执行的 SHOW CHARACTER SET 语句的总数。 |
| 显示排序规则（增量） | 执行的 SHOW COLLATION 语句总数。 |
| 显示列类型（增量） | 执行的 SHOW COLUMNS 语句总数。 |
| 显示贡献者（Delta） | 执行的 SHOW CONTRIBUTORS 语句总数。 |
| 显示创建数据库（增量） | 执行的 SHOW CREATE DATABASE 语句总数。 |
| 显示创建事件（增量） | 执行的 SHOW CREATE EVENT 语句总数。 |
| 显示创建函数（Delta） | 执行的 SHOW CREATE FUNCTION 语句的总数。 |
| 显示创建过程（增量） | 执行的 SHOW CREATE PROCEDURE 语句总数。 |
| 显示创建表（增量） | 执行的 SHOW CREATE TABLE 语句的总数。 |
| 显示创建触发器（增量） | 执行的 SHOW CREATE TRIGGER 语句总数。 |
| 显示数据库（增量） | 执行的 SHOW DATABASES 语句总数。 |
| 显示引擎日志（增量） | 执行的 SHOW ENGINE ... LOGS 语句的总数。 |
| 显示引擎互斥体（Delta） | 执行的 SHOW ENGINE ... MUTEX 语句的总数。 |
| 显示引擎状态（增量） | 执行的 SHOW ENGINE ... STATUS 语句的总数。 |
| 显示错误（增量） | 执行的 SHOW ERRORS 语句总数。 |
| 显示事件（增量） | 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. |