Abstract
This manual documents the MySQL Enterprise Monitor version 3.4.6.
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.
Licensing information—MySQL Enterprise Monitor. This product may include third-party software, used under license. See MySQL Enterprise Monitor 3.4 License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this release of MySQL Enterprise Monitor. See MySQL Enterprise Monitor Proxy and Aggregator 3.4 License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this release of Proxy and Aggregator.
Document generated on: 2018-04-21 (revision: 7336)
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 [+/-]
- MySQL Enterprise Monitor Glossary
- 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 Welcome to MySQL Enterprise Monitor page
- 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 Group Replication Multiple Group Topology
- 19.5 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 - Treemap 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 Strict 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 Required Disk Space
- 4.1 Installation Parameters
- 7.1 Agent SSL Configuration Options
- 8.1 MySQL Enterprise Service Manager Installer Options
- 8.2 MySQL Enterprise Monitor Agent Installer Options
- 9.1 Apache Tomcat Environment File Location (default)
- 9.2 Installation Parameters
- 9.3 MySQL Enterprise Service Manager repository configuration file location (default)
- 9.4 Configuration utility location (default)
- 9.5 Apache Tomcat configuration file location (default)
- 10.1 Default Location of Agent Configuration Utility
- 10.2 Service Manager Configuration Utilities
- 10.3 Service Manager Certificate Utilities
- 10.4 Default Location of Agent Configuration Utility
- 10.5 Agent Connection Utility
- 10.6 MySQL Enterprise Monitor Agent Configuration Utility
- 11.1 MySQL Enterprise Monitor Proxy and Aggregator Installer Options
- 11.2 Proxy and Aggregator Help Options
- 11.3 Proxy and Aggregator Command Line 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
- 16.3 Unmonitored MySQL Instances
- 16.4 MySQL Instance Details
- 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 State Icons
- 22.4 Event Handlers Controls
- 22.5 Email Notification Groups List Controls
- 22.6 Create Group Controls
- 22.7 Email Settings Controls
- 22.8 SNMP Settings Controls
- 22.9 Create Event Handler Controls
- 24.1 MySQL Process Discovery Advisor 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 Server Hostname Controls
- 27.2 Customize
- 27.3 External Authentication
- 27.4 LDAP Authentication
- 27.5 Active Directory Authentication
- 28.1 Formatting with Wiki Markup
- 28.2 Custom Data Collection Class Elements
- 28.3 Attribute Elements
- 29.1 QRTi Value Definitions
- A.1 MySQL Enterprise Service Manager Log File Locations
- A.2 Default Location of MIB Files
- A.3 Default Location of config.properties File
- A.4 Optional config.properties Values