Oracle Enterprise Manager for MySQL Database 12.1.0.2.0
   Next

Oracle Enterprise Manager for MySQL Database User's Guide

Abstract

This manual documents Oracle Enterprise Manager for MySQL Database 12.1.0.2.0.

For legal information, see the Legal Notice.

Document generated on: 2015-05-04 (revision: 5675)

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 Configuring a MySQL Target
1.4 Modifying Target Credentials and Properties
1.5 Oracle MySQL Discovery
1.6 Deleting a Target
1.7 Logging
2 Working with the MySQL Database Target Page
2.1 Viewing the MySQL Database Target Homepage
2.2 MySQL Database Homepage Menu
2.3 MySQL Database Homepage Regions
2.3.1 Availability History
2.3.2 Configuration Summary
2.3.3 Connections
2.3.4 Transaction Activity
2.3.5 Row Activity
2.3.6 InnoDB Buffer Pool Usage (pages)
2.3.7 Response Time (ms)
2.3.8 Statement Activity
2.3.9 Incidents and Problems
3 Performance Pages
3.1 Connections
3.2 Statements
3.3 InnoDB Buffer Pool
3.4 InnoDB File I/O
3.5 Tables / Rows
3.6 Query Cache
4 Metrics
4.1 Metrics Page
4.2 Admin Statement Activity Metrics
4.3 Binary Logs Summary Metrics
4.4 Connection Activity Metrics
4.5 DDL Statement Activity Metrics
4.6 DML Statement Activity Metrics
4.7 Handler Activity Metrics
4.8 InnoDB Activity Metrics
4.9 InnoDB Adaptive Hash Activity Metrics
4.10 InnoDB Bufferpool Activity Metrics
4.11 InnoDB Insert Buffer Activity Metrics
4.12 InnoDB Io Activity Metrics
4.13 InnoDB Log Activity Metrics
4.14 InnoDB Row Activity Metrics
4.15 InnoDB Semaphore Activity Metrics
4.16 InnoDB Thread Activity Metrics
4.17 InnoDB Transaction Activity Metrics
4.18 Insert Delayed Activity Metrics
4.19 Instance Activity Metrics
4.20 NDB Activity Metrics
4.21 Performance Schema Activity Metrics
4.22 Query Cache Activity Metrics
4.23 Replication Master Activity Metrics
4.24 Replication Slave Activity Metrics
4.25 Secure Connections Activity Metrics
4.26 Show Statement Activity Metrics
4.27 Slow Query Logging Activity Metrics
4.28 Table Activity Metrics
4.29 Threads Activity Metrics
4.30 Trx Statement Activity Metrics
4.31 XA Activity Metrics
5 Configuration Metrics
5.1 Configuration Metrics Page
5.2 Binary Logs Configuration Metrics
5.3 Capabilities Configuration Metrics
5.4 Character Set Configuration Metrics
5.5 Collation Configuration Metrics
5.6 Connection Configuration Metrics
5.7 Connection Buffers Configuration Metrics
5.8 Environment Configuration Metrics
5.9 Host Cache Configuration Metrics
5.10 InnoDB Configuration Configuration Metrics
5.11 InnoDB Fulltext Configuration Metrics
5.12 InnoDB Memcached Configuration Configuration Metrics
5.13 Insert Delayed Configuration Metrics
5.14 Localization Configuration Metrics
5.15 Logging Configuration Metrics
5.16 Metadata Configuration Metrics
5.17 Myisam Configuration Metrics
5.18 Myisam Full Text Configuration Metrics
5.19 NDB Configuration Metrics
5.20 Networking Configuration Metrics
5.21 Optimizer Configuration Metrics
5.22 Password Validation Configuration Metrics
5.23 Performance Schema Configuration Metrics
5.24 Query Cache Configuration Metrics
5.25 Replication Master Configuration Metrics
5.26 Replication Slave Configuration Metrics
5.27 Secure Connections Configuration Metrics
5.28 Security Configuration Metrics
5.29 Slow Query Logging Configuration Metrics
5.30 Statement Processing Configuration Metrics
5.31 Table Configuration Configuration Metrics
5.32 Thread Pool Configuration Metrics
5.33 Threads Configuration Metrics
5.34 Transactions Configuration Metrics
6 MySQL Compliance Framework
6.1 MySQL Administration Standard Rules
6.2 MySQL Performance Standard Rules
6.3 MySQL Replication Standard Rules
6.4 MySQL Schema Standard Rules
6.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 12.1.0.2.0 (2015-05-01)
B Licenses for Third-Party Components
B.1 Apache Commons BeanUtils v1.6 License
B.2 Apache Commons Codec
B.3 Apache Commons Collections License
B.4 Apache Commons Daemon
B.5 Apache Commons Exec
B.6 Apache Commons IO License
B.7 Apache Commons Lang License
B.8 Apache Commons Logging License
B.9 Apache Commons Math License
B.10 Apache HttpComponents HttpClient License
B.11 Apache HttpComponents HttpCore License
B.12 Apache License Version 2.0, January 2004
B.13 Apache log4j License
B.14 Apache MINA SSHD License
B.15 Apache Tomcat License
B.16 Code Generation Library License
B.17 Ehcache License
B.18 EZMorph License
B.19 GNU Lesser General Public License Version 2.1, February 1999
B.20 Guava (Google Core Libraries for Java) License
B.21 Jackson License
B.22 Javassist License
B.23 Javolution License
B.24 JLine
B.25 JOpt Simple License
B.26 JSON-lib License
B.27 JUNG License
B.28 junixsocket License
B.29 MarkdownPapers License
B.30 Mustache.java License
B.31 Simple Logging Facade for Java (SLF4J) License
B.32 Spring Framework License

List of Figures

2.1 MySQL Database Target Homepage
2.2 Availability History
2.3 Connections
2.4 Transaction Activity
2.5 Row Activity
2.6 InnoDB Buffer Pool Usage (pages)
2.7 Response Time (ms)
2.8 Statement Activity

List of Tables

3.1 Connections Performance Page Regions
3.2 Statements Performance Page Regions
3.3 InnoDB Buffer Pool Performance Page Regions
3.4 InnoDB File I/O Performance Page Regions
3.5 Tables / Rows Performance Page Regions
3.6 Query Cache Performance Page Regions
4.1 Admin Statement Activity Metrics
4.2 Binary Logs Summary Metrics
4.3 Connection Activity Metrics
4.4 DDL Statement Activity Metrics
4.5 DML Statement Activity Metrics
4.6 Handler Activity Metrics
4.7 InnoDB Activity Metrics
4.8 InnoDB Adaptive Hash Activity Metrics
4.9 InnoDB Bufferpool Activity Metrics
4.10 InnoDB Insert Buffer Activity Metrics
4.11 InnoDB Io Activity Metrics
4.12 InnoDB Log Activity Metrics
4.13 InnoDB Row Activity Metrics
4.14 InnoDB Semaphore Activity Metrics
4.15 InnoDB Thread Activity Metrics
4.16 InnoDB Transaction Activity Metrics
4.17 Insert Delayed Activity Metrics
4.18 Instance Activity Metrics
4.19 NDB Activity Metrics
4.20 Performance Schema Activity Metrics
4.21 Query Cache Activity Metrics
4.22 Replication Master Activity Metrics
4.23 Replication Slave Activity Metrics
4.24 Secure Connections Activity Metrics
4.25 Show Statement Activity Metrics
4.26 Slow Query Logging Activity Metrics
4.27 Table Activity Metrics
4.28 Threads Activity Metrics
4.29 Trx Statement Activity Metrics
4.30 XA Activity Metrics
5.1 Binary Logs Configuration Metrics
5.2 Capabilities Configuration Metrics
5.3 Character Set Configuration Metrics
5.4 Collation Configuration Metrics
5.5 Connection Configuration Metrics
5.6 Connection Buffers Configuration Metrics
5.7 Environment Configuration Metrics
5.8 Host Cache Configuration Metrics
5.9 InnoDB Configuration Configuration Metrics
5.10 InnoDB Fulltext Configuration Metrics
5.11 InnoDB Memcached Configuration Configuration Metrics
5.12 Insert Delayed Configuration Metrics
5.13 Localization Configuration Metrics
5.14 Logging Configuration Metrics
5.15 Metadata Configuration Metrics
5.16 Myisam Configuration Metrics
5.17 Myisam Full Text Configuration Metrics
5.18 NDB Configuration Metrics
5.19 Networking Configuration Metrics
5.20 Optimizer Configuration Metrics
5.21 Password Validation Configuration Metrics
5.22 Performance Schema Configuration Metrics
5.23 Query Cache Configuration Metrics
5.24 Replication Master Configuration Metrics
5.25 Replication Slave Configuration Metrics
5.26 Secure Connections Configuration Metrics
5.27 Security Configuration Metrics
5.28 Slow Query Logging Configuration Metrics
5.29 Statement Processing Configuration Metrics
5.30 Table Configuration Configuration Metrics
5.31 Thread Pool Configuration Metrics
5.32 Threads Configuration Metrics
5.33 Transactions Configuration Metrics
   Next
   Preface and Legal Notices