MySQL Enterprise Monitor 3.4 Release Notes
Abstract
This manual documents the MySQL Enterprise Monitor version 3.4.0.
For notes detailing the changes in each release, see the MySQL Enterprise Monitor 3.4 Release Notes.
For legal information, see the Legal Notice.
For help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists, where you can discuss your issues with other MySQL users.
For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML and PDF formats, see the MySQL Documentation Library.
Licensing information. This product may include third-party software, used under license. See this document for licensing information, including licensing information relating to third-party software that may be included in this release of MySQL Enterprise Monitor.
Document generated on: 2017-05-18 (revision: 6910)
Table of Contents [+/-]
- Preface and Legal Notices
- I Getting Started with MySQL Enterprise Monitor [+/-]
- II Installing MySQL Enterprise Monitor [+/-]
- 3 Installation Prerequisites [+/-]
- 4 Service Manager Installation [+/-]
- 5 Monitor Agent Installation [+/-]
- 5.1 General Agent Related Notes
- 5.2 Creating MySQL User Accounts for the Monitor Agent
- 5.3 Java Considerations on Linux
- 5.4 Monitoring Agent Graphical Installation Wizard
- 5.5 Starting/Stopping the MySQL Enterprise Monitor Agent [+/-]
- 5.6 Monitoring Multiple MySQL Servers
- 5.7 Configuring an Agent to Monitor a Remote MySQL Server
- 5.8 Monitoring Outside the Firewall with an SSH Tunnel
- 5.9 HTTP Connection Timeout
- 5.10 Troubleshooting the Agent
- 5.11 Agent Backlog
- 6 Upgrading MySQL Enterprise Monitor Installations [+/-]
- 7 Post-installation Considerations [+/-]
- 8 Unattended Installation Reference [+/-]
- 9 Performance Tuning MySQL Enterprise Monitor [+/-]
- 10 Configuration Utilities [+/-]
- 11 Proxy and Aggregator Installation [+/-]
- 12 Configuring Connectors [+/-]
- 13 Uninstalling MySQL Enterprise Monitor [+/-]
- III Using MySQL Enterprise Monitor [+/-]
- 14 User Interface [+/-]
- 15 Overview [+/-]
- 16 MySQL Instances Dashboard [+/-]
- 17 Managing Groups of Instances
- 18 Enterprise Backup Dashboard [+/-]
- 19 Replication Dashboard [+/-]
- 20 Reports and Graphs [+/-]
- 21 Advisors [+/-]
- 22 Events and Event Handlers [+/-]
- 23 Expression-Based Advisor Reference [+/-]
- 24 GUI-Based Advisor Reference [+/-]
- 24.1 Agent Health Advisor
- 24.2 MySQL Enterprise Backup Health Advisor
- 24.3 MySQL Process Discovery Advisor
- 24.4 Duplicate Host Identity
- 24.5 Duplicate MySQL Server UUID
- 24.6 sys Schema Install Advisor
- 24.7 CPU Utilization Advisor
- 24.8 Filesystem Free Space Advisor
- 24.9 MySQL Process
- 24.10 Query Analysis Advisors
- 24.11 Group Replication Advisors
- 24.12 Security Advisors
- 25 Access Control [+/-]
- 26 Access Control - Best Practices [+/-]
- 27 Global Settings [+/-]
- 28 Customizing MySQL Enterprise Monitor [+/-]
- IV Using the Query Analyzer [+/-]
- V Appendices [+/-]
- Index
List of Figures [+/-]
- 1.1 MySQL Enterprise Monitor Architecture
- 1.2 MySQL Enterprise Monitor Agentless Architecture
- 11.1 MySQL Enterprise Monitor Proxy and Aggregator Architecture
- 12.1 Plug-in for PHP and Aggregator Architecture
- 12.2 Connector Plug-in Architecture
- 12.3 Connector Plug-in Architecture
- 14.1 Initial setup for the MySQL Enterprise Monitor User Interface
- 14.2 Status Summary
- 15.1 Overview Dashboard
- 15.2 Group Overview Filter Configuration
- 16.1 Add Instance Connection Settings
- 16.2 Add Instance Encryption Settings
- 16.3 Add Instance Advanced Settings
- 16.4 MySQL Instance Filter
- 17.1 Group Management Page
- 18.1 Backup Details
- 19.1 Replication Overview
- 19.2 Replication Topology Graph
- 19.3 Group Replication Single Group Topology
- 19.4 Replication Topology Statistics
- 20.1 Optimizing Graph Data Status
- 20.2 Database File I/O By File
- 20.3 Database File I/O By Wait Type Report
- 20.4 Database File I/O By Wait Type Graphs
- 20.5 Database File I/O By Thread
- 20.6 Processes Report
- 20.7 Table Statistics Report - Table View
- 20.8 Table Statistics Report - Tree View
- 21.1 Advisors Page
- 21.2 Advisor Menu Control
- 21.3 Advisor Pop-up Menu
- 21.4 Advisor Pop-up Menu
- 21.5 Agent Health - General
- 21.6 Threshold Definitions Example
- 22.1 Events Page with Filter
- 22.2 Event Handlers section
- 22.3 Email Notification Groups section
- 22.4 Create Group Dialog
- 22.5 Email Settings section
- 22.6 SNMP Settings section
- 24.1 Agent Health - General
- 24.2 Agent Health - General
- 24.3 Agent Health - Backlog
- 24.4 CPU Usage
- 24.5 CPU Outliers
- 24.6 Filesystem - General
- 24.7 Filesystem - Estimated Full Capacity
- 24.8 Filesystem - Percentage of Space
- 24.9 Filesystem - Percentage Used in Time Range
- 24.10 Group Replication Configuration Advisor
- 24.11 Group Replication Status Advisor
- 25.1 Core Monitored Assets
- 25.2 Monitoring Services Permissions
- 26.1 Hybrid Permission Set Overview
- 26.2 Strict Permission Set Grouped
- 27.1 Server Hostname
- 27.2 Customize MySQL Server Name
- 27.3 Data Purge Behavior
- 27.4 My Oracle Support Credentials
- 27.5 HTTP Proxy Settings
- 27.6 External Authentication Settings: LDAP
- 29.1 MySQL Enterprise Monitor User Interface: Query Analyzer
List of Tables [+/-]
- 3.1 Disk space Required
- 4.1 Installation Parameters
- 7.1 SSL Configuration Options For The Agent's
bootstrap.properties - 8.1 MySQL Enterprise Service Manager Installer Options
- 8.2 MySQL Enterprise Monitor Agent Installer Options
- 9.1 Apache Tomcat configuration file location (default)
- 9.2 Installation Parameters
- 9.3 MEM repository configuration file location (default)
- 9.4 MEM repository configuration tool location (default)
- 9.5 MEM repository configuration tool location (default)
- 10.1 MEM Repository Configuration Tool Location (default)
- 10.2 Service Manager Config Utilities
- 10.3 Service Manager Certificate Utilities
- 10.4 MEM Agent Configuration Tool Location (default)
- 10.5 Agent Connection Utility
- 10.6 Agent Configuration Utility
- 11.1 MySQL Enterprise Monitor Proxy and Aggregator Installer Options
- 11.2 Proxy and Aggregator Help Options
- 11.3 Application Options
- 11.4 aggr-module Options
- 11.5 proxy-module Options
- 12.1 Connector/PHP Properties
- 12.2 MySQL Plug-in for Connector/J Properties
- 12.3 MySQL Plug-in for Connector/J SSL Properties
- 13.1 MySQL Enterprise Monitor Uninstaller Options
- 15.1 Group Overview Filter Configuration
- 16.1 Bad Connection List
- 16.2 Unreachable Agents List
- 16.3 Unmonitored MySQL Instances List
- 16.4 MySQL Instance Details Columns
- 16.5 Connection Settings Tab
- 16.6 Encryption Settings Tab
- 16.7 Advanced Settings
- 16.8 MySQL Instance Filter
- 19.1 Group Status Columns
- 20.1 Timeseries Graph Filter
- 21.1 Advisor Page Controls
- 21.2 Advisor Information Listing
- 21.3 Advisor Edit Menu Controls
- 21.4 Advisor Filter Controls
- 22.1 Events Filter Controls
- 22.2 Events List Columns
- 22.3 Event Handler List Controls
- 22.4 Email Notification Groups Controls
- 22.5 Email Settings Controls
- 22.6 SNMP Settings Controls
- 22.7 Create Event Handler Controls
- 24.1 MySQL Process Discovery Controls
- 26.1 Manager Role Definition
- 26.2 DBA Role Definition
- 26.3 System-Wide Role Definition
- 26.4 Development Group Role Definition
- 26.5 Production Group Role Definition
- 27.1 Customize
- 27.2 Customize
- 27.3 External Authentication
- 27.4 LDAP Authentication
- 27.5 Active Directory Authentication
- 28.1 MySQL Enterprise Monitor: Wiki Formatting
- 28.2 Custom Data Collection Class Elements
- 28.3 Attribute Elements
- 29.1 QRTi value definitions
- A.1 MySQL Enterprise Monitor: Log File Locations
- A.2 MySQL Enterprise Monitor: MIB File Locations
- A.3 MySQL Enterprise Monitor: Default path of the
config.propertiesFile - A.4 Optional config.properties values