PDF (A4) - 5.2Mb
EPUB - 3.7Mb
HTML Download (TGZ) - 3.6Mb
HTML Download (Zip) - 3.6Mb
Abstract
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.
This manual documents the MySQL Enterprise Monitor version 3.0.27.
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.
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: 2016-11-18 (revision: 6682)
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 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.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 [+/-]
- 7 Upgrading, Re-Installing or Changing Your Installation [+/-]
- 8 Unattended Installation Reference [+/-]
- 9 Performance Tuning MySQL Enterprise Monitor [+/-]
- 10 Uninstalling the MySQL Enterprise Monitor [+/-]
- 11 Proxy and Aggregator Installation [+/-]
- 12 Configuring Connectors [+/-]
- III Using MySQL Enterprise Monitor [+/-]
- 13 The User Interface [+/-]
- 14 The Dashboards [+/-]
- 15 Settings [+/-]
- 16 Reports and Graphs [+/-]
- 17 Events [+/-]
- 18 Event Handling [+/-]
- 19 Advisors [+/-]
- 20 Expression-Based Advisor Reference [+/-]
- 21 GUI-Based Advisor Reference [+/-]
- 22 Customizing MySQL Enterprise Monitor [+/-]
- IV Using the Query Analyzer [+/-]
- V Appendices [+/-]
- A MySQL Enterprise Monitor Frequently Asked Questions
- B Managing the Inventory [+/-]
- C MySQL Enterprise Monitor General Reference [+/-]
- D MySQL Enterprise Monitor Component Reference [+/-]
- E Error codes
- F Files associated with configuring, debugging, and using MySQL Enterprise Monitor
- G Data Collection Items
- H MySQL Enterprise Monitor Release Notes
- MySQL Enterprise Monitor Glossary
- Index
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
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 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
config.propertiesFile - D.4 Optional config.properties 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
PDF (A4) - 5.2Mb
EPUB - 3.7Mb
HTML Download (TGZ) - 3.6Mb
HTML Download (Zip) - 3.6Mb

