MySQL Enterprise Monitor 3.0.25 Manual


This manual documents the MySQL Enterprise Monitor version 3.0.25.

For notes detailing the changes in each release, see the MySQL Enterprise Monitor 3.0 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.

Document generated on: 2016-02-05 (revision: 6284)

Table of Contents

Preface and Legal Notices
I Getting Started with MySQL Enterprise Monitor
1 MySQL Enterprise Monitor Introduction and Architecture
1.1 MySQL Enterprise Monitor Component Overview
1.2 MySQL Enterprise Monitor Agent
1.3 MySQL Enterprise Service Manager
1.4 MySQL Enterprise Monitor Proxy and Aggregator
2 What's new in MySQL Enterprise Monitor 3.0?
II Installing MySQL Enterprise Monitor
3 Installation Prerequisites
3.1 Installer Files
3.2 Prerequisites
3.2.1 System Requirements
3.2.2 Supported Platforms
3.2.3 MySQL Enterprise Monitor Repository
3.3 Credentials Needed for Installation
3.3.1 Existing Users
3.3.2 Users Created During Installation
3.3.3 Users Created on First Log-in
4 Service Manager Installation
4.1 MySQL Enterprise Monitor Installation Types
4.2 MySQL Enterprise Service Manager Graphical Installation Wizard
4.3 Text-Based Installation
4.4 Starting/Stopping the MySQL Enterprise Monitor Services
4.5 MySQL Enterprise Service Manager Configuration Settings
4.5.1 Initial Monitor UI Log-In
4.5.2 Setting the Timezone and Locale
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 Installing the Monitor Agent on Unix and Linux
5.5 Installing the Agent on Microsoft Windows
5.6 Installing the Agent on Mac OS X
5.7 Starting/Stopping the MySQL Enterprise Monitor Agent
5.7.1 Starting/Stopping the Agent on Windows
5.7.2 Starting/Stopping the Agent on Mac OS X
5.7.3 Starting/Stopping the Agent on Unix
5.7.4 sql_mode
5.8 Monitoring Multiple MySQL Servers
5.9 Configuring an Agent to Monitor a Remote MySQL Server
5.10 Monitoring Outside the Firewall with an SSH Tunnel
5.11 HTTP Connection Timeout
5.12 Troubleshooting the Agent
5.13 Agent Backlog
6 Post-installation Considerations
6.1 General Considerations
6.2 Installing SSL Certificates
6.3 Changing an SSH Host Key
7 Upgrading, Re-Installing or Changing Your Installation
7.1 General considerations when upgrading MySQL Enterprise Monitor
7.2 Restoring from Backup
7.3 Guide for Upgrading to MySQL Enterprise Monitor 3.0
7.4 Upgrading an Existing 3.0.x Installation
8 Unattended Installation Reference
8.1 Unattended Installation
8.1.1 Performing an Unattended Installation
8.1.2 MySQL Enterprise Service Manager Options
8.1.3 MySQL Enterprise Monitor Agent Options
9 Performance Tuning MySQL Enterprise Monitor
9.1 Tuning Memory
9.2 Tuning CPU
9.3 Tuning Apache Tomcat Threads
9.4 Tuning Agent Memory Requirements
10 Uninstalling the MySQL Enterprise Monitor
10.1 Removing the MySQL Enterprise Monitor: Windows
10.2 Removing the MySQL Enterprise Monitor: Unix
10.3 Removing the MySQL Enterprise Monitor Mac OS X
10.4 Unattended Uninstallations
11 Proxy and Aggregator Installation
11.1 Proxy Aggregator Architecture
11.2 Prerequisites
11.3 Installing the Proxy and Aggregator
11.4 Graphical Installation Wizard
11.5 Text-Based Installation
11.6 Unattended Installation
11.7 Starting and Stopping the Proxy and Aggregator
11.8 Configuration Options
12 Configuring Connectors
12.1 Using the MySQL Enterprise Plugin for Connector/PHP
12.2 Using the MySQL Enterprise Plugin for Connector/J
12.3 Using the MySQL Enterprise Plugin for Connector/Net
III Using MySQL Enterprise Monitor
13 The User Interface
13.1 General
13.1.1 Status Summary
13.1.2 Asset Selector
13.2 The Query Analyzer
13.3 What's New
14 The Dashboards
14.1 Introduction
14.2 Overview
14.3 Replication
14.4 MySQL Instances Dashboard
14.4.1 MySQL Instance Dashboard UI
14.4.2 MySQL Instance Details
14.4.3 Adding Instances
14.4.4 Filtering MySQL Instances
15 Settings
15.1 Global Settings
15.2 Manage Users
15.3 Logs
15.4 User Preferences
15.5 Diagnostics Report
16 Reports and Graphs
16.1 All Timeseries Graphs
16.2 InnoDB Buffer Pool Usage
17 Events
17.1 Closing an Event
17.2 Notification of Events
18 Event Handling
18.1 Event Handling Page
18.1.1 Event Handlers List
18.1.2 Email Notification Group Controls
18.1.3 Email Settings
18.1.4 Email Notification Status
18.1.5 SNMP Settings
18.1.6 SNMP Notification Status
18.2 Creating Event Handlers
18.2.1 Event Action Log
18.2.2 Suspending an Event Handler
19 Advisors
19.1 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 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 MySQL Server UUID
21.5 CPU Utilization Advisor
21.6 Filesystem Free Space Advisor
21.7 Query Analysis Advisors
22 Customizing MySQL Enterprise Monitor
22.1 Customizing Groups
22.2 Creating Advisors and Rules
22.2.1 Creating Advisors
22.2.2 Overview of Graph Creation
22.2.3 Overview of Advisor Creation
22.2.4 Variables
22.2.5 Thresholds
22.2.6 Using Strings
22.2.7 Wiki Format
22.2.8 Creating a New Advisor: An Example
22.2.9 Creating a New Graph: An Example
22.3 Custom Data Collection
22.3.1 Custom.xml
22.3.2 Queries
22.3.3 Data Collection Attributes
22.4 Event Notification Blackout Periods
22.4.1 Scripting Blackouts
IV Using the Query Analyzer
23 Using the Query Analyzer
23.1 Providing Query Analyzer Data
23.1.1 Using the MySQL Performance Schema
23.2 Query Response Time index (QRTi)
23.3 Query Analyzer User Interface
23.3.1 Getting Detailed Query Information
23.3.2 Using Graphs to Identify Queries
23.3.3 Filtering Query Analyzer Data
23.3.4 Query Analyzer Settings
23.3.5 Exporting Query Information
V Appendices
A MySQL Enterprise Monitor Frequently Asked Questions
B Managing the Inventory
B.1 The Inventory Page
B.2 Using the Inventory Page
C MySQL Enterprise Monitor General Reference
C.1 MySQL Enterprise Monitor Limitations
C.2 Supported Browsers
C.3 Backing up MySQL Enterprise Service Manager
C.4 Regular MySQL Enterprise Monitor Maintenance
D MySQL Enterprise Monitor Component Reference
D.1 MySQL Enterprise Service Manager Reference
D.1.1 Log Files for the MySQL Enterprise Service Manager
D.1.2 The Management Information Base (MIB) File
D.1.3 The file
D.1.4 Using The Service Monitor Repository Configuration Script
D.2 MySQL Enterprise Monitor Agent Reference
D.2.1 MySQL Enterprise Monitor Agent Configurable Options
D.2.2 Agent Log Files
D.2.3 Using The Agent Configuration Script
E Error codes
F Files associated with configuring, debugging, and using MySQL Enterprise Monitor
G Data Collection Items
H MySQL Enterprise Monitor Release Notes
I Licenses for Third-Party Components
I.1 Ant-Contrib License
I.2 ANTLR 2 License
I.3 ANTLR 3 License
I.4 Apache Commons BeanUtils v1.6 License
I.5 Apache Commons BeanUtils v1.7.0 and Later License
I.6 Apache Commons Chain
I.7 Apache Commons Codec
I.8 Apache Commons Collections License
I.9 Apache Commons Daemon
I.10 Apache Commons DBCP License
I.11 Apache Commons Digester License
I.12 Apache Commons Exec
I.13 Apache Commons FileUpload License
I.14 Apache Commons HttpClient
I.15 Apache Commons IO License
I.16 Apache Commons Lang License
I.17 Apache Commons Logging License
I.18 Apache Commons Math License
I.19 Apache Commons Pool License
I.20 Apache Commons Validator License
I.21 Apache HttpComponents HttpClient License
I.22 Apache HttpComponents HttpCore License
I.23 Apache Jakarta ORO License
I.24 Apache JAMES Mime4J License
I.25 Apache License Version 2.0, January 2004
I.26 Apache log4j License
I.27 Apache MINA License
I.28 Apache MINA SSHD License
I.29 Apache Portable Runtime (APR) License
I.30 Apache Struts License
I.31 Apache Tiles
I.32 Apache Tomcat License
I.33 Apache Tomcat Native Library License
I.34 ASM License
I.35 canvg License
I.36 Chardin.js License
I.37 Chosen License
I.38 Code Generation Library License
I.39 Common Public License
I.40 cURL (libcurl) License
I.41 D3 License
I.42 DataTables ColReorderWithResize License
I.43 DataTables ColViz License
I.44 DataTables License
I.45 DOM4J License
I.46 Dropdown Check List License
I.47 dtoa.c License
I.48 Editline Library (libedit) License
I.49 Ehcache License
I.50 EZMorph License
I.51 Felix Framework Distribution
I.52 FindGTest.cmake License
I.53 Fred Fish's Dbug Library License
I.54 FreeMarker License
I.55 getarg License
I.56 gettext-js License
I.57 GLib License (for MySQL Enterprise Monitor)
I.58 GNU General Public License Version 2.0, June 1991
I.59 GNU Lesser General Public License Version 2, June 1991
I.60 GNU Lesser General Public License Version 2.1, February 1999
I.61 GNU Libtool License
I.62 GObject License
I.63 Google Controlling Master Thread I/O Rate Patch License
I.64 Google Perftools (TCMalloc utility) License
I.65 Google Protocol Buffers License
I.66 Google SMP Patch License
I.67 Guava (Google Core Libraries for Java) License
I.68 Harvest License
I.69 Hibernate Annotations License
I.70 Hibernate Commons Annotations License
I.71 Hibernate License
I.72 html2canvas License
I.73 Jackson License
I.74 Java Secure Channel (JSch)
I.75 Java SNMP License
I.76 Javassist License
I.77 Javolution License
I.78 JCommon License
I.79 JDOM Project License
I.80 JFreeChart License
I.81 JLine
I.82 JOpt Simple License
I.83 jQuery Form Example Plugin License
I.84 jQuery License
I.85 jQuery Sparklines Plugin License
I.86 jQuery Templates Plugin License
I.87 jQuery UI License
I.88 JSON-lib License
I.89 json2.js License
I.90 jsTree License
I.91 JUNG License
I.92 junixsocket License
I.93 JZlib License
I.94 LGI License
I.95 License
I.96 libevent License
I.97 Libffi License
I.98 libiconv License
I.99 libintl License
I.100 Libxml2 License
I.101 Linux-PAM License
I.102 LPeg Library License
I.103 Lua (liblua) License
I.104 LuaFileSystem Library License
I.105 MarkdownPapers License
I.106 md5 (Message-Digest Algorithm 5) License
I.107 memcached License
I.108 MIT License
I.109 Moment License
I.110 Moment-Timezone License
I.111 License
I.112 nt_servc (Windows NT Service class library) License
I.113 OGNL (Object-Graph Navigation Language) License
I.114 OpenPAM License
I.115 OpenSSL v1.0 License
I.116 PCRE License
I.117 Percona Multiple I/O Threads Patch License
I.118 PersistJS License
I.119 PNG Behavior License
I.120 PxtoEM License
I.121 Quartz Scheduler License
I.122 Radeox RE
I.123 RegEX-Spencer Library License
I.124 RFC 3174 - US Secure Hash Algorithm 1 (SHA1) License
I.125 RGBColor License
I.126 Richard A. O'Keefe String Library License
I.127 Rickshaw License
I.128 ROME License
I.129 SHA-1 in C License
I.130 Simple Logging Facade for Java (SLF4J) License
I.131 SNMP4J License
I.132 Spring Framework License
I.133 StackBlur License
I.134 StringTemplate Template Engine License
I.135 TEA License
I.136 XWork License
I.137 zlib License
MySQL Enterprise Monitor Glossary

List of Figures

1.1 MySQL Enterprise Monitor Architecture
1.2 MySQL Enterprise Monitor Agentless Architecture
4.1 Initial setup for the MySQL Enterprise Monitor User Interface
5.1 Installing Agent on Windows: Host options
5.2 MySQL Enterprise Monitor: Installing Agent on Windows: Agent Authentication
5.3 MySQL Enterprise Monitor: Installing Agent on Windows: Monitored Database Information
5.4 MySQL Enterprise Monitor: Installing Agent on Windows: Additional Agent Users
5.5 MySQL Enterprise Monitor: Agent Monitoring Options
5.6 MySQL Enterprise Monitor: Install as a service
5.7 MySQL Enterprise Monitor: Installing Agent on Mac OS X: MySQL Enterprise Service Manager Options
5.8 MySQL Enterprise Monitor: Installing Agent on Mac OS X: Monitored Database Information (TCIP)
5.9 MySQL Enterprise Monitor: Installing Agent on Mac OS X: Monitored Database Information (Socket)
5.10 MySQL Enterprise Monitor: Installing Agent on OS X: Additional Agent Users
11.1 MySQL Enterprise Monitor Proxy and Aggregator Architecture
12.1 Plugin for PHP and Aggregator Architecture
12.2 Connector Plugin Architecture
12.3 Connector Plugin Architecture
13.1 A Status Summary Example
13.2 The What's New Page
13.3 What's New Configuration
14.1 Group Overview Configuration
14.2 MySQL Instances: Group Context Menu
14.3 Add Instance Connection Settings
14.4 Add Instance Advanced Settings
14.5 MySQL Instance Filter
15.1 MySQL Enterprise Monitor User Interface Settings: Server Locale
15.2 MySQL Enterprise Monitor User Interface Settings: Server Hostname
15.3 MySQL Enterprise Monitor User Interface Settings: Data Purge
15.4 MySQL Enterprise Monitor User Interface Settings: My Oracle Support Credentials
15.5 MySQL Enterprise Monitor User Interface Settings: HTTP Proxy Settings
15.6 MySQL Enterprise Monitor User Interface Settings: Customize MySQL server name
15.7 MySQL Enterprise Monitor User Interface: Manage Users
15.8 MySQL Enterprise Monitor User Interface: Logs
15.9 MySQL Enterprise Monitor User Interface: User Preferences
17.1 MySQL Enterprise Monitor User Interface: Events Screen with Search enabled
18.1 Event Handlers section
18.2 Email Notification Groups section
18.3 Create Group Dialog
18.4 Email Settings section
18.5 SNMP Settings section
18.6 Create Event Handler Dialog
19.1 Advisors Page
19.2 Advisor Menu Control
19.3 Advisor Popup Menu
19.4 Advisor Popup Menu
19.5 Agent Health - General
19.6 Threshold Definitions Example
21.1 Agent Health - General
21.2 Agent Health - General
21.3 Agent Health - Backlog
21.4 CPU Usage
21.5 CPU Outliers
21.6 Filesystem - General
21.7 Filesystem - Estimated Full Capacity
21.8 Filesystem - Percentage of Space
21.9 Filesystem - Percentage Used in Time Range
22.1 Manage Instances example
22.2 Creating a New Advisor
23.1 MySQL Enterprise Monitor User Interface: Query Analyzer
23.2 MySQL Enterprise Monitor User Interface: Canonical Query Tab for a Query
23.3 MySQL Enterprise Monitor User Interface: Example Query Tab for a Query
23.4 MySQL Enterprise Monitor User Interface: Explain Query Tab for a Query
23.5 Graphs Tab for a Query
23.6 MySQL Enterprise Monitor User Interface: Correlated Graphs
23.7 MySQL Enterprise Monitor User Interface: Query Analyzer Filter Options
23.8 MySQL Enterprise Monitor User Interface: Query Analyzer Configuration

List of Tables

3.1 Disk space Required
4.1 Installation Parameters
6.1 Default Root Path ($INSTALL_ROOT)
6.2 SSL Configuration Options For The Agent's
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 MySQL Enterprise Monitor Uninstaller Options
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 Plugin for Connector/J Properties
12.3 MySQL Plugin for Connector/J SSL Properties
14.1 Group Overview Configuration
14.2 Bad Connection List
14.3 Unreachable Agents List
14.4 Unmonitored MySQL Instances List
14.5 MySQL Instance Details Columns
14.6 Connection Settings Tab
14.7 Advanced Settings
14.8 MySQL Instance Filter
18.1 Event Handler List Controls
18.2 Email Notification Groups Controls
18.3 Email Settings Controls
18.4 SNMP Settings Controls
18.5 Create Event Handler Controls
19.1 Advisor Page Controls
19.2 Advisor Information Listing
19.3 Advisor Edit Menu Controls
19.4 Advisor Filter Controls
21.1 MySQL Process Discovery Controls
22.1 MySQL Enterprise Monitor: Wiki Formatting
22.2 Custom Data Collection Class Elements
22.3 Attribute Elements
23.1 QRTi value definitions
D.1 MySQL Enterprise Monitor: Log File Locations
D.2 MySQL Enterprise Monitor: MIB File Locations
D.3 MySQL Enterprise Monitor: Default path of the File
D.4 Optional values
D.5 MEM Repository Configuration Tool Location (default)
D.6 MEM Agent Configuration Tool Location (default)
E.1 MySQL Enterprise Dashboard: GUI Error Codes and Messages
E.2 MySQL Enterprise Monitor: Server Codes and Messages
G.1 MySQL Monitor Data Items