MySQL Enterprise Monitor 8.0 Release Notes
Abstract
This manual documents MySQL Enterprise Monitor version 8.0.36.
For notes detailing the changes in each release, see the MySQL Enterprise Monitor 8.0 Release Notes.
For legal information, including licensing information, see the Preface and Legal Notices.
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.
Document generated on: 2023-10-31 (revision: 8567)
Table of Contents
- Preface and Legal Notices
- I Getting Started with MySQL Enterprise Monitor
- II Installing MySQL Enterprise Monitor
- 3 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 UNIX-like Platforms
- 5.4 Monitoring Agent Graphical Installation Wizard
- 5.5 Starting/Stopping 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 Uninstalling MySQL Enterprise Monitor
- III Configuring MySQL Enterprise Service Manager
- 12 Configuring MySQL Enterprise Service Manager
- 13 User Interface
- 14 Global Settings
- 15 Manage Instances
- 16 Asset Management
- 17 Managing Groups of Instances
- 18 Advisors
- 19 Expression-Based Advisor Reference
- 20 GUI-Based Advisor Reference
- 20.1 Agent Health Advisor
- 20.2 MySQL Enterprise Backup Health Advisor
- 20.3 MySQL Process Discovery Advisor
- 20.4 Duplicate Host Identity
- 20.5 Duplicate MySQL Server UUID
- 20.6 sys Schema Install Advisor
- 20.7 CPU Utilization Advisor
- 20.8 Filesystem Free Space Advisor
- 20.9 MySQL Process
- 20.10 Query Analysis Advisors
- 20.11 Group Replication Advisors
- 20.12 Security Advisors
- 20.13 NDB Cluster GUI Advisors
- 21 Event Handlers
- 22 Access Control
- 23 Access Control - Best Practices
- IV Using MySQL Enterprise Monitor
- 24 Overview
- 25 Events
- 26 Enterprise Backup Dashboard
- 27 Replication Dashboard
- 28 Topology
- 29 Reports and Graphs
- 30 Customizing MySQL Enterprise Monitor
- V Using the Query Analyzer
- VI Appendices
- MySQL Enterprise Monitor Glossary
- Index
List of Figures
- 1.1 MySQL Enterprise Monitor Architecture
- 1.2 MySQL Enterprise Monitor Agentless Architecture
- 2.1 Default Query Analyzer View
- 2.2 Agents View
- 2.3 Agent Details View
- 2.4 Hosts View
- 2.5 Host Details View
- 2.6 NDB Clusters View
- 2.7 NDB Clusters Detail View
- 2.8 Delete Confirmation for MySQL Instance
- 13.1 Welcome to MySQL Enterprise Monitor page
- 13.2 Target Selectors
- 13.3 Status Summary
- 14.1 Server Hostname
- 14.2 Customize MySQL Server Name
- 14.3 Data Purge Behavior
- 14.4 HTTP Proxy Settings
- 14.5 External Authentication Settings: LDAP
- 15.1 Add Instance Connection Settings
- 15.2 Add Instance Encryption Settings
- 15.3 Add Instance Advanced Settings
- 15.4 MySQL Instance Filter
- 16.1 Agents View
- 16.2 Agent Details View
- 16.3 Hosts View
- 16.4 Host Details View
- 16.5 NDB Clusters View
- 16.6 NDB Clusters View
- 16.7 Delete Confirmation for MySQL Instance
- 16.8 Delete Confirmation for MySQL Instance and related Host
- 17.1 Group Management Page
- 17.2 Group Assets Tab
- 18.1 Manage Advisors Page
- 18.2 Advisor Menu Control
- 18.3 Advisor Pop-up Menu
- 18.4 Advisor Filter Controls
- 18.5 Agent Health - General
- 18.6 Threshold Definitions Example
- 20.1 Agent Health - General
- 20.2 Agent Health - General
- 20.3 Agent Health - Backlog
- 20.4 CPU Usage
- 20.5 CPU Outliers
- 20.6 Filesystem - General
- 20.7 Filesystem - Estimated Full Capacity
- 20.8 Filesystem - Percentage of Space
- 20.9 Filesystem - Percentage Used in Time Range
- 20.10 Group Replication Configuration Advisor
- 20.11 Group Replication Status Advisor
- 20.12 NDB Cluster Memory Usage Advisor
- 20.13 NDB Cluster Status Advisor
- 21.1 Event Handlers section
- 21.2 Email Notification Groups section
- 21.3 Create Group Dialog
- 21.4 Email Settings section
- 21.5 SNMP Settings section
- 21.6 Create Event Handler Dialog
- 21.7 Event Action Log
- 21.8 Event Action Log Expanded
- 22.1 Core Monitored Assets
- 22.2 Monitoring Services Permissions
- 23.1 Strict Permission Set Overview
- 23.2 Strict Permission Set Grouped
- 24.1 Global Overview
- 24.2 Global Overview Default Sparklines
- 24.3 MySQL InnoDB Cluster Default Sparklines
- 24.4 MySQL Instance Overview Default Sparklines
- 24.5 Customize Overview Sparkline Graphs
- 25.1 Events Page with Filter
- 26.1 Backup Details
- 27.1 Replication Overview
- 27.2 Replication Statistics tab
- 28.1 Replication Topology Graph
- 28.2 Group Replication Single Group Topology
- 28.3 Group Replication Multiple Group Topology
- 28.4 NDB Cluster Topology
- 28.5 NDB Cluster Topology - Management Node
- 28.6 NDB Cluster Topology - API Node
- 28.7 NDB Cluster Topology - Data Node
- 29.1 Optimizing Graph Data Status
- 29.2 Database File I/O By File
- 29.3 Database File I/O By Wait Type Report
- 29.4 Database File I/O By Wait Type Graphs
- 29.5 Database File I/O By Thread
- 29.6 Processes Report
- 29.7 Table Statistics Report - Table View
- 29.8 Table Statistics Report - Treemap View
- 29.9 User Statistics Report - Table View
- 29.10 User Statistics Report - Tree View
- 29.11 Memory Usage Report - Table View
- 29.12 Memory Usage Report - Tree View
- 29.13 NDB Cluster Memory Usage Report - Table View
- 29.14 NDB Cluster Memory Usage Report - Tree View
- 31.1 Default Query Analyzer View
- 31.2 Normalized Queries and Statistics
- 31.3 Statement Detail Graphs
- 31.4 Example Statements Distribution Chart
- 31.5 Example Statement and Details
- 31.6 Example EXPLAIN
- 31.7 Configuration View
- 31.8 Graph View
- 31.9 Filter View
- 31.10 Sort View
- 31.11 Data View
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 Uninstaller Options
- 14.1 Server Hostname Controls
- 14.2 Customize
- 14.3 External Authentication
- 14.4 LDAP Authentication
- 14.5 Active Directory Authentication
- 15.1 Bad Connection List
- 15.2 Unreachable Agents
- 15.3 Unmonitored MySQL Instances
- 15.4 MySQL Instance Details
- 15.5 Connection Settings Tab
- 15.6 Encryption Settings Tab
- 15.7 Advanced Settings
- 15.8 MySQL Instance Filter
- 18.1 Manage Advisors Page Controls
- 18.2 Advisor Information Listing
- 18.3 Advisor Edit Menu Controls
- 18.4 Advisor Filter Controls
- 20.1 MySQL Process Discovery Advisor Controls
- 20.2 NDB Cluster Memory Usage Advisor Controls
- 20.3 NDB Cluster Status Advisor Controls
- 21.1 Event Handlers Controls
- 21.2 Email Notification Groups List Controls
- 21.3 Create Group Controls
- 21.4 Email Settings Controls
- 21.5 SNMP Settings Controls
- 21.6 Create Event Handler Controls
- 23.1 Manager Role Definition
- 23.2 DBA Role Definition
- 23.3 System-Wide Role Definition
- 23.4 Development Group Role Definition
- 23.5 Production Group Role Definition
- 25.1 Events Filter Controls
- 25.2 Events List Columns
- 25.3 Event State Icons
- 27.1 Group Status Columns
- 29.1 Timeseries Graph Filter
- 30.1 Formatting with Wiki Markup
- 30.2 Custom Data Collection Class Elements
- 30.3 Attribute Elements
- 31.1 QRTi Value Definitions
- 31.2 Controls of the default Query Analyzer view
- 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