Oracle Enterprise Manager for MySQL Database User Guide

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/ or https://docs.oracle.com/cd/E17952_01/mysql-em-plugin-en/index.html.

Oracle Enterprise Manager for MySQL Database is included with both the MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition. For information on MySQL licensing, see the MySQL Global Price List.

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.

Document generated on: 2024-01-26 (revision: 8581)


Table of Contents

Preface and Legal Notices
1 Installing Oracle Enterprise Manager for MySQL Database
1.1 Prerequisites
1.2 Obtaining and Installing the Plugin
1.3 Adding MySQL Targets
1.3.1 Adding Targets Manually
1.3.2 Adding Targets Using Autodiscovery
1.4 Modifying Target Credentials and Properties
1.5 Deleting a Target
1.6 Logging
2 Working with the MySQL Database Target Homepage
2.1 Viewing the MySQL Database Target Homepage
2.2 MySQL Database Homepage Menu
2.3 MySQL Database Homepage Regions
3 Connections Pages
3.1 Database Processes
3.2 Locking
4 Query Analyzer and Memory Usage
4.1 Query Analyzer
4.2 Memory Usage
5 Performance Pages
5.1 Connection Statistics
5.2 Database File I/O pages
5.3 Statements
5.4 InnoDB Buffer Pool
5.5 Global Table/Row Statistics
5.6 Per Table Statistics
5.7 Per User Statistics
6 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 Replication Master Activity Metrics
6.24 Replication Slave Activity Metrics
6.25 Secure Connections Activity Metrics
6.26 Show Statement Activity Metrics
6.27 Slow Query Logging Activity Metrics
6.28 Sys Schema Global Memory Usage Metrics
6.29 Sys Schema InnoDB Row Lock Waits Metrics
6.30 Sys Schema IO By Host Metrics
6.31 Sys Schema IO By Thread By Latency Metrics
6.32 Sys Schema IO Global By File By Latency Metrics
6.33 Sys Schema IO Global By Wait By Latency Metrics
6.34 Sys Schema Processes Metrics
6.35 Sys Schema Statement Analysis Metrics
6.36 Sys Schema Table Metadata Lock Waits Metrics
6.37 Sys Schema Table Statistics Metrics
6.38 Sys Schema User Statistics Metrics
6.39 Table Activity Metrics
6.40 Threads Activity Metrics
6.41 Trx Statement Activity Metrics
6.42 XA Activity Metrics
7 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 Collation Configuration Metrics
7.6 Connection Configuration Metrics
7.7 Connection Buffers Configuration Metrics
7.8 Data Dictionary Configuration Metrics
7.9 Environment Configuration Metrics
7.10 Firewall Configuration Metrics
7.11 Host Cache Configuration Metrics
7.12 Information Schema Configuration Metrics
7.13 InnoDB Configuration Configuration Metrics
7.14 InnoDB Fulltext Configuration Metrics
7.15 InnoDB Memcached Configuration Configuration Metrics
7.16 Insert Delayed Configuration Metrics
7.17 Localization Configuration Metrics
7.18 Logging Configuration Metrics
7.19 Metadata Configuration Metrics
7.20 Myisam Configuration Metrics
7.21 Myisam Full Text Configuration Metrics
7.22 NDB Configuration Metrics
7.23 Networking Configuration Metrics
7.24 Optimizer Configuration Metrics
7.25 Password Validation Configuration Metrics
7.26 Performance Schema Configuration Metrics
7.27 Replication Master Configuration Metrics
7.28 Replication Slave Configuration Metrics
7.29 Secure Connections Configuration Metrics
7.30 Security Configuration Metrics
7.31 Slow Query Logging Configuration Metrics
7.32 Statement Processing Configuration Metrics
7.33 Sys Schema Configuration Metrics
7.34 Table Configuration Configuration Metrics
7.35 Thread Pool Configuration Metrics
7.36 Threads Configuration Metrics
7.37 Transactions Configuration Metrics
8 MySQL Compliance Framework
8.1 MySQL Administration Standard Rules
8.2 MySQL Performance Standard Rules
8.3 MySQL Replication Standard Rules
8.4 MySQL Schema Standard Rules
8.5 MySQL Security Standard Rules
A Oracle Enterprise Manager for MySQL Database Release Notes
A.1 Abstract
A.2 Changes in Oracle Enterprise Manager for MySQL Database 13.5.2.0.0 (2023-06-08)
A.3 Changes in Oracle Enterprise Manager for MySQL Database 13.5.1.0.0 (2022-07-21)
A.4 Changes in Oracle Enterprise Manager for MySQL Database 13.3 to 13.4 (Skipped version numbers)
A.5 Changes in Oracle Enterprise Manager for MySQL Database 13.2.4.0.0 (2018-10-12)
A.6 Changes in Oracle Enterprise Manager for MySQL Database 13.2.3.0.0 (2018-07-23)
A.7 Changes in Oracle Enterprise Manager for MySQL Database 13.2.2.0.0 (2018-02-13)
A.8 Changes in Oracle Enterprise Manager for MySQL Database 13.2.1.0.0 (2018-02-02)
A.9 Changes in Oracle Enterprise Manager for MySQL Database 12.1.0.4.0 (2016-09-12)
A.10 Changes in Oracle Enterprise Manager for MySQL Database 12.1.0.3.0 (2015-10-22)
A.11 Changes in Oracle Enterprise Manager for MySQL Database 12.1.0.2.0 (2015-05-01)

List of Figures

2.1 MySQL Database Target Homepage

List of Tables

3.1 Database Processes Dashboard
3.2 InnoDB Row Lock Waits Dashboard
3.3 Table Metadata Lock Waits Dashboard
4.1 Query Analyzer Columns
4.2 Memory Usage Columns
5.1 Connections Performance Page Regions
5.2 Database File I/O By Host
5.3 Database File I/O By Thread
5.4 Database File I/O By File
5.5 Database File I/O By Type
5.6 InnoDB File I/O Performance Page Regions
5.7 Statements Performance Page Regions
5.8 InnoDB Buffer Pool Performance Page Regions
5.9 Tables / Rows Performance Page Regions
5.10 Per Table Statistics Dashboard
5.11 Per User Statistics Dashboard
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 Replication Master Activity Metrics
6.24 Replication Slave Activity Metrics
6.25 Secure Connections Activity Metrics
6.26 Show Statement Activity Metrics
6.27 Slow Query Logging Activity Metrics
6.28 Sys Schema Global Memory Usage Metrics
6.29 Sys Schema InnoDB Row Lock Wait Metrics
6.30 Sys Schema IO By Host Metrics
6.31 Sys Schema IO By Thread By Latency Metrics
6.32 Sys Schema IO Global By File By Latency Metrics
6.33 Sys Schema IO Global By Wait By Latency Metrics
6.34 Sys Schema Processes Metrics
6.35 Sys Schema Statement Analysis Metrics
6.36 Sys Schema Table Metadata Lock Waits Metrics
6.37 Sys Schema Table Statistics Metrics
6.38 Sys Schema User Statistics Metrics
6.39 Table Activity Metrics
6.40 Threads Activity Metrics
6.41 Trx Statement Activity Metrics
6.42 XA Activity 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 Collation Configuration Metrics
7.6 Connection Configuration Metrics
7.7 Connection Buffers Configuration Metrics
7.8 Data Dictionary Configuration Metrics
7.9 Environment Configuration Metrics
7.10 Firewall Configuration Metrics
7.11 Host Cache Configuration Metrics
7.12 Information Schema Configuration Metrics
7.13 InnoDB Configuration Configuration Metrics
7.14 InnoDB Fulltext Configuration Metrics
7.15 InnoDB Memcached Configuration Configuration Metrics
7.16 Insert Delayed Configuration Metrics
7.17 Localization Configuration Metrics
7.18 Logging Configuration Metrics
7.19 Metadata Configuration Metrics
7.20 Myisam Configuration Metrics
7.21 Myisam Full Text Configuration Metrics
7.22 NDB Configuration Metrics
7.23 Networking Configuration Metrics
7.24 Optimizer Configuration Metrics
7.25 Password Validation Configuration Metrics
7.26 Performance Schema Configuration Metrics
7.27 Replication Master Configuration Metrics
7.28 Replication Slave Configuration Metrics
7.29 Secure Connections Configuration Metrics
7.30 Security Configuration Metrics
7.31 Slow Query Logging Configuration Metrics
7.32 Statement Processing Configuration Metrics
7.33 Sys Schema Configuration Metrics
7.34 Table Configuration Configuration Metrics
7.35 Thread Pool Configuration Metrics
7.36 Threads Configuration Metrics
7.37 Transactions Configuration Metrics