Chapter 6 MySQL Instance Metrics

Table of Contents

6.1 Admin Statement Activity Metrics

6.2 Audit Log Activity Metrics

6.3 Binary Logs Summary Metrics

6.4 Connection Activity Metrics

6.5 DDL Statement Activity Metrics

6.6 DML Statement Activity Metrics

6.7 Firewall Activity Metrics

6.8 Handler Activity Metrics

6.9 InnoDB Activity Metrics

6.10 InnoDB Adaptive Hash Activity Metrics

6.11 InnoDB Bufferpool Activity Metrics

6.12 InnoDB Insert Buffer Activity Metrics

6.13 InnoDB IO Activity Metrics

6.14 InnoDB Log Activity Metrics

6.15 InnoDB Row Activity Metrics

6.16 InnoDB Semaphore Activity Metrics

6.17 InnoDB Thread Activity Metrics

6.18 InnoDB Transaction Activity Metrics

6.19 Insert Delayed Activity Metrics

6.20 Instance Activity Metrics

6.21 NDB Activity Metrics

6.22 Performance Schema Activity Metrics

6.23 Relay Metrics

6.24 Replication By Worker Metrics

6.25 Replication Connection Status Metrics

6.26 Replication Source Activity Metrics

6.27 Replication Replica Activity Metrics

6.28 Secure Connections Activity Metrics

6.29 Show Statement Activity Metrics

6.30 Slow Query Logging Activity Metrics

6.31 Sys Schema Global Memory Usage Metrics

6.32 Sys Schema InnoDB Row Lock Waits Metrics

6.33 Sys Schema IO By Host Metrics

6.34 Sys Schema IO By Thread By Latency Metrics

6.35 Sys Schema IO Global By File By Latency Metrics

6.36 Sys Schema IO Global By Wait By Latency Metrics

6.37 Sys Schema Processes Metrics

6.38 Sys Schema Statement Analysis by First Time Seen Metrics

6.39 Sys Schema Statement Analysis by Total Executions Metrics

6.40 Sys Schema Statement Analysis by Total Latency Metrics

6.41 Sys Schema Table Metadata Lock Waits Metrics

6.42 Sys Schema Table Statistics Metrics

6.43 Sys Schema User Statistics Metrics

6.44 Table Activity Metrics

6.45 Threads Activity Metrics

6.46 Trx Statement Activity Metrics

6.47 XA Activity Metrics

This chapter describes the Oracle Enterprise Manager for MySQL Database metrics.