Skip to Main Content

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

MySQL Enterprise Monitor 8.0.40 Manual

Abstract

This manual documents MySQL Enterprise Monitor version 8.0.40.

End of Life Announcement. MySQL Enterprise Monitor will be end of life and deprecated with obsolescence as of January 1, 2025. For additional information, see Chapter 1, MySQL Enterprise Monitor: End of Life Notice

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: 2024-10-29 (revision: 8658)

Table of Contents

Preface and Legal Notices

I Getting Started with MySQL Enterprise Monitor

1 MySQL Enterprise Monitor: End of Life Notice

2 MySQL Enterprise Monitor Introduction and Architecture

2.1 MySQL Enterprise Monitor Component Overview
2.2 MySQL Enterprise Monitor Agent
2.3 MySQL Enterprise Service Manager

3 What's New

II Installing MySQL Enterprise Monitor

4 Prerequisites

4.1 Installer Files

4.2 Prerequisites

4.2.1 System Requirements
4.2.2 Supported Platforms
4.2.3 Requirements for Monitoring
4.2.4 MySQL Enterprise Monitor Repository

4.3 Credentials Required for Installation

4.3.1 Existing Users
4.3.2 Users Created During Installation
4.3.3 Users Created on First Log-in

4.4 Supported Browsers

5 Service Manager Installation

5.1 MySQL Enterprise Monitor Installation Types
5.2 MySQL Enterprise Service Manager Graphical Installation Wizard
5.3 Text-Based Installation
5.4 Starting/Stopping MySQL Enterprise Monitor Services
5.5 MySQL Enterprise Service Manager Configuration Settings

6 Monitor Agent Installation

6.1 General Agent Related Notes

6.2 Creating MySQL User Accounts for the Monitor Agent

6.3 Java Considerations on UNIX-like Platforms

6.4 Monitoring Agent Graphical Installation Wizard

6.5 Starting/Stopping MySQL Enterprise Monitor Agent

6.5.1 Starting/Stopping the Agent on Windows
6.5.2 Starting/Stopping the Agent on macOS
6.5.3 Starting/Stopping the Agent on Unix
6.5.4 sql_mode

6.6 Monitoring Multiple MySQL Servers

6.7 Configuring an Agent to Monitor a Remote MySQL Server

6.8 Monitoring Outside the Firewall with an SSH Tunnel

6.9 HTTP Connection Timeout

6.10 Troubleshooting the Agent

6.11 Agent Backlog

7 Upgrading MySQL Enterprise Monitor Installations

7.1 General considerations when upgrading MySQL Enterprise Monitor
7.2 Upgrading MySQL Enterprise Monitor
7.3 Restoring from Backup

8 Post-installation Considerations

8.1 General Considerations
8.2 Installing SSL Certificates
8.3 Backup the Repository
8.4 Changing an SSH Host Key

9 Unattended Installation Reference

9.1 Unattended Installation

9.1.1 Performing an Unattended Installation
9.1.2 MySQL Enterprise Service Manager Options
9.1.3 MySQL Enterprise Monitor Agent Options

10 Performance Tuning MySQL Enterprise Monitor

10.1 Tuning Memory
10.2 Tuning CPU
10.3 Tuning Apache Tomcat Threads
10.4 Tuning Agent Memory Requirements

11 Configuration Utilities

11.1 Service Manager Configuration Utilities
11.2 Agent Configuration Utility

12 Uninstalling MySQL Enterprise Monitor

12.1 Windows Platforms
12.2 macOS Platforms
12.3 Unattended Uninstallations

III Configuring MySQL Enterprise Service Manager

13 Configuring MySQL Enterprise Service Manager

14 User Interface

14.1 Initial Log-In

14.2 Setting the Timezone and Locale

14.3 Menus and Toolbars

14.3.1 Target Selection
14.3.2 Navigation Menus
14.3.3 User Menu
14.3.4 Status Summary
14.3.5 System and User-defined Filters
14.3.6 Configuration Views

15 Global Settings

15.1 Server Locale
15.2 Server Hostname
15.3 Customize MySQL Server Name
15.4 Data Purge Behavior
15.5 HTTP Proxy Settings
15.6 External Authentication

16 Manage Instances

16.1 Manage Instances Controls

16.2 Monitored Instance Details

16.3 Adding Instances

16.3.1 Adding a MySQL Instance
16.3.2 Adding Multiple MySQL Instances

16.4 Monitoring Amazon RDS

16.5 Filtering MySQL Instances

17 Asset Management

17.1 Agents View
17.2 Hosts View
17.3 NDB Clusters View
17.4 Deleting Assets
17.5 Deleting Assets from the Command Line

18 Managing Groups of Instances

19 Advisors

19.1 Manage Advisors Page
19.2 Advisor Types
19.3 Advisor Thresholds
19.4 Advisor Schedules

20 Expression-Based Advisor Reference

20.1 Administration Advisors
20.2 Agent Advisors
20.3 Availability Advisors
20.4 NDB Cluster Advisors
20.5 Memory Usage Advisors
20.6 Monitoring and Support Services Advisors
20.7 Operating System Advisors
20.8 Performance Advisors
20.9 Replication Advisors
20.10 Schema Advisors
20.11 Security Advisors

21 GUI-Based Advisor Reference

21.1 Agent Health Advisor
21.2 MySQL Enterprise Backup Health Advisor
21.3 MySQL Process Discovery Advisor
21.4 Duplicate Host Identity
21.5 Duplicate MySQL Server UUID
21.6 sys Schema Install Advisor
21.7 CPU Utilization Advisor
21.8 Filesystem Free Space Advisor
21.9 MySQL Process
21.10 Query Analysis Advisors
21.11 Group Replication Advisors
21.12 Security Advisors
21.13 NDB Cluster GUI Advisors

22 Event Handlers

22.1 Event Handlers

22.1.1 Event Handlers
22.1.2 Event Handlers Page

22.2 Creating Event Handlers

22.2.1 Event Action Log
22.2.2 Suspending an Event Handler

23 Access Control

23.1 Users and Roles

23.2 Permissions

23.3 Monitored Assets Permissions

23.3.1 Server Group & MySQL NDB Cluster
23.3.2 MySQL Instances
23.3.3 MySQL NDB Cluster Permissions

23.4 Monitoring Services

23.5 MySQL Enterprise Monitor

23.6 Default Users and Roles

23.7 Creating Users and Roles

24 Access Control - Best Practices

24.1 Open Permission Sets
24.2 Strict Permission Set

IV Using MySQL Enterprise Monitor

25 Overview

25.1 Overview Sparkline Graphs
25.2 Database Availability
25.3 General Database Statistics

26.1 Events

27 Enterprise Backup Dashboard

27.1 Backup Overview
27.2 Backup Details

28 Replication Dashboard

28.1 Replication Overview
28.2 Replication Dashboard Tabs
28.3 Replication Logging

29 Topology

30 Reports and Graphs

30.1 All Timeseries Graphs

30.1.1 Graph Controls
30.1.2 Graph Types
30.1.3 Timeseries Data Aggregation

30.2 Database File I/O and Lock Waits

30.2.1 sys Schema
30.2.2 Database File I/O Graphs and Reports
30.2.3 Lock Waits Report

30.3 Processes Report

30.4 Table Statistics

30.5 User Statistics

30.6 Memory Usage Report

30.7 InnoDB Buffer Pool Usage

30.8 NDB Cluster Memory Usage

31 Customizing MySQL Enterprise Monitor

31.1 Creating Advisors and Rules

31.1.1 Creating Advisors
31.1.2 Overview of Graph Creation
31.1.3 Overview of Advisor Creation
31.1.4 Variables
31.1.5 Thresholds
31.1.6 Using Strings
31.1.7 Wiki Format
31.1.8 Creating a New Advisor: An Example
31.1.9 Creating a New Graph: An Example

31.2 Custom Data Collection

31.2.1 Custom.xml
31.2.2 Queries
31.2.3 Data Collection Attributes

31.3 Event Notification Blackout Periods

31.3.1 Scripting Blackouts

V Using the Query Analyzer

32 Query Analyzer View

32.1 Providing Query Analyzer Data

32.1.1 Using the MySQL Performance Schema

32.2 Query Response Time index (QRTi)

32.3 Query Analyzer User Interface

32.4 Detailed Query Information

32.5 Query Analyzer Configuration View

VI Appendices

A MySQL Enterprise Monitor Component Reference

A.1 MySQL Enterprise Service Manager Reference

A.1.1 MySQL Enterprise Service Manager Log Files
A.1.2 The Management Information Base (MIB) File
A.1.3 The config.properties file

A.2 MySQL Enterprise Monitor Agent Reference

A.2.1 Agent Log Files

B Managing the Inventory

B.1 The Inventory Page
B.2 Using the Inventory Page

C MySQL Enterprise Monitor Frequently Asked Questions

D MySQL Enterprise Monitor Support

D.1 Diagnostics Report

MySQL Enterprise Monitor Glossary

HOME NEXT