Enterprise Manager
Abstract
This manual documents Oracle Enterprise Manager for MySQL Database.
For legal information, see the Legal Notice.
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.
For documentation, visit https://dev.mysql.com/doc/mysql-em-plugin/en/.
Oracle Enterprise Manager for MySQL Database is included with both the MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition at no additional cost. To use Oracle Enterprise Manager for MySQL Database with the MySQL Community Edition, you must purchase licensing for either the MySQL Enterprise Edition or MySQL Cluster Carrier Grade Edition. For related licensing information, see the Oracle Enterprise Manager's Oracle Enterprise Manager for MySQL licensing section.
Document generated on: 2024-12-20 (revision: 8682)
Table of Contents
- Preface and Legal Notices
- 1 Installing Oracle Enterprise Manager for MySQL Database
- 2 Working with the MySQL Database Target Homepage
- 3 Connections Pages
- 4 Query Analyzer and Memory Usage
- 5 Performance Pages
- 6 MySQL Instance Metrics
- 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
- 7 MySQL Instance Configuration Metrics
- 7.1 Audit Log Configuration Metrics
- 7.2 Binary Logs Configuration Metrics
- 7.3 Capabilities Configuration Metrics
- 7.4 Character Set Configuration Metrics
- 7.5 Cluster Status Configuration Metrics
- 7.6 Collation Configuration Metrics
- 7.7 Connection Configuration Metrics
- 7.8 Connection Buffers Configuration Metrics
- 7.9 Data Dictionary Configuration Metrics
- 7.10 Environment Configuration Metrics
- 7.11 Firewall Configuration Metrics
- 7.12 Host Cache Configuration Metrics
- 7.13 Information Schema Configuration Metrics
- 7.14 InnoDB Configuration Configuration Metrics
- 7.15 InnoDB Fulltext Configuration Metrics
- 7.16 InnoDB Memcached Configuration Configuration Metrics
- 7.17 Insert Delayed Configuration Metrics
- 7.18 Localization Configuration Metrics
- 7.19 Logging Configuration Metrics
- 7.20 Metadata Configuration Metrics
- 7.21 Myisam Configuration Metrics
- 7.22 Myisam Full Text Configuration Metrics
- 7.23 NDB Configuration Metrics
- 7.24 Networking Configuration Metrics
- 7.25 Optimizer Configuration Metrics
- 7.26 Password Validation Configuration Metrics
- 7.27 Performance Schema Configuration Metrics
- 7.28 Replication Source Configuration Metrics
- 7.29 Replication Replica Configuration Metrics
- 7.30 Secure Connections Configuration Metrics
- 7.31 Security Configuration Metrics
- 7.32 Slow Query Logging Configuration Metrics
- 7.33 Statement Processing Configuration Metrics
- 7.34 Sys Schema Configuration Metrics
- 7.35 Table Configuration Configuration Metrics
- 7.36 Thread Pool Configuration Metrics
- 7.37 Threads Configuration Metrics
- 7.38 Transactions Configuration Metrics
- 8 InnoDB Cluster Metrics
- 9 InnoDB Cluster Configuration Metrics
- 10 InnoDB ClusterSet Metrics
- 11 InnoDB ClusterSet Configuration Metrics
- 12 MySQL Compliance Framework
- A Oracle Enterprise Manager for MySQL Database Release Notes
- A.1 Abstract
- A.2 Changes in Oracle Enterprise Manager for MySQL Database 13.5.3.0.0 (2024-12-18)
- A.3 Changes in Oracle Enterprise Manager for MySQL Database 13.5.2.0.0 (2023-06-08)
- A.4 Changes in Oracle Enterprise Manager for MySQL Database 13.5.1.0.0 (2022-07-21)
- A.5 Changes in Oracle Enterprise Manager for MySQL Database 13.3 to 13.4 (Skipped version numbers)
- A.6 Changes in Oracle Enterprise Manager for MySQL Database 13.2.4.0.0 (2018-10-12)
- A.7 Changes in Oracle Enterprise Manager for MySQL Database 13.2.3.0.0 (2018-07-23)
- A.8 Changes in Oracle Enterprise Manager for MySQL Database 13.2.2.0.0 (2018-02-13)
- A.9 Changes in Oracle Enterprise Manager for MySQL Database 13.2.1.0.0 (2018-02-02)
- A.10 Changes in Oracle Enterprise Manager for MySQL Database 12.1.0.4.0 (2016-09-12)
- A.11 Changes in Oracle Enterprise Manager for MySQL Database 12.1.0.3.0 (2015-10-22)
- A.12 Changes in Oracle Enterprise Manager for MySQL Database 12.1.0.2.0 (2015-05-01)