You are here: Home Docs MySQL Monitor 2.0

MySQL Enterprise Monitor 2.0

by Bryan Hinton last modified Jul 03, 2009 05:15 PM

Copyright 2005-2008 MySQL AB, 2009 Sun Microsystems, Inc.

This documentation is NOT distributed under a GPL license. Use of this documentation is subject to the following terms: You may create a printed copy of this documentation solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. You shall not publish or distribute this documentation in any form or on any media, except if you distribute the documentation in a manner similar to how Sun disseminates it (that is, electronically for download on a Web site with the software) or on a CD-ROM or similar medium, provided however that the documentation is disseminated together with the software on the same medium. Any other use, such as any dissemination of printed copies or use of this documentation, in whole or in part, in another publication, requires the prior written consent from an authorized representative of Sun Microsystems, Inc. Sun Microsystems, Inc. and MySQL AB reserve any and all rights to this documentation not expressly granted above.

Copyright © 2009 Sun Microsystems, Inc., 4150 Network Circle, Santa Clara, California 95054, U.S.A. All rights reserved.U.S. Government Rights - Commercial software. Government users are subject to the Sun Microsystems, Inc. standard license agreement and applicable provisions of the FAR and its supplements. Use is subject to license terms. This distribution may include materials developed by third parties.Sun, Sun Microsystems, the Sun logo, MySQL Enterprise Monitor 2.0, MySQL logo(TM) and MySQL(TM) are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.This product is covered and controlled by U.S. Export Control laws and may be subject to the export or import laws in other countries. Nuclear, missile, chemical biological weapons or nuclear maritime end uses or end users, whether direct or indirect, are strictly prohibited. Export or reexport to countries subject to U.S. embargo or to entities identified on U.S. export exclusion lists, including, but not limited to, the denied persons and specially designated nationals lists is strictly prohibited.

Copyright © 2009 Sun Microsystems, Inc., 4150 Network Circle, Santa Clara, California 95054, Etats-Unis. Tous droits réservés.L'utilisation est soumise aux termes de la Licence.Cette distribution peut comprendre des composants développés par des tierces parties.Sun, Sun Microsystems, le logo Sun, MySQL Enterprise Monitor 2.0, MySQL logo(TM) et MySQL(TM) sont des marques de fabrique ou des marques déposées de Sun Microsystems, Inc. aux Etats-Unis et dans d'autres pays.Ce produit est soumis à la législation américaine en matière de contrôle des exportations et peut être soumis à la règlementation en vigueur dans d'autres pays dans le domaine des exportations et importations. Les utilisations, ou utilisateurs finaux, pour des armes nucléaires,des missiles, des armes biologiques et chimiques ou du nucléaire maritime, directement ou indirectement, sont strictement interdites. Les exportations ou réexportations vers les pays sous embargo américain, ou vers des entités figurant sur les listes d'exclusion d'exportation américaines, y compris, mais de manière non exhaustive, la liste de personnes qui font objet d'un ordre de ne pas participer, d'une façon directe ou indirecte, aux exportations des produits ou des services qui sont régis par la législation américaine en matière de contrôle des exportations et la liste de ressortissants spécifiquement désignés, sont rigoureusement interdites.

Abstract

This manual documents the MySQL Enterprise Monitor version 2.0.

Document generated on: 2009-06-12 (revision: 15307)


Table of Contents

1. Introduction
1.1. An Overview of the Service
1.1.1. The Service Architecture
1.1.2. Service Features
1.1.3. Security
1.2. Conventions Used in This Document
2. Installation and Upgrades
2.1. User Roles
2.1.1. Existing Users
2.1.2. User Created During Installation
2.1.3. Users Created on First Log-in
2.2. Service Manager Installation
2.2.1. Service Manager Installation Common Parameters
2.2.2. Service Manager Installation on Windows
2.2.3. Service Manager Installation on Mac OS X
2.2.4. Service Manager Installation on Unix
2.2.5. Starting/Stopping the MySQL Enterprise Monitor Service on Windows
2.2.6. Starting/Stopping the MySQL Enterprise Monitor Service on Unix and Mac OS X
2.2.7. MySQL Enterprise Service Manager Configuration Settings and Advisor Installation
2.3. Monitor Agent Installation
2.3.1. Creating a MySQL User Account for the Monitor Agent
2.3.2. Installing the Agent on Microsoft Windows
2.3.3. Installing the Agent on Mac OS X
2.3.4. Installing the Monitor Agent on Unix
2.3.5. Starting/Stopping the MySQL Enterprise Monitor Agent
2.3.6. Advanced Agent Configuration
2.3.7. Troubleshooting the Agent
2.4. Unattended Installation
2.4.1. Command-Line Options
2.4.2. Unattended Windows Installation
2.4.3. Unattended Unix and Mac OS X Installation
2.4.4. Starting the Services
2.5. Post-Installation Considerations
2.6. Upgrading, Re-Installing or Changing Your Installation
2.6.1. Upgrading MySQL Enterprise Monitor
2.6.2. Reinstalling MySQL Enterprise Monitor
2.6.3. Changing Your MySQL Enterprise Monitor Installation
2.7. Uninstalling the MySQL Enterprise Monitor
2.7.1. Removing the MySQL Enterprise Monitor: Windows
2.7.2. Removing the MySQL Enterprise Monitor: Unix and Mac OS X
3. Deploying MySQL Enterprise Service Manager
3.1. Backing up MySQL Enterprise Service Manager
3.2. Migrating 1.3.x Historical Data to MySQL Enterprise Monitor 2.0
3.3. Regular MySQL Enterprise Monitor Maintenance
3.4. Choosing Suitable MySQL Enterprise Service Manager Hardware Configurations
4. MySQL Enterprise Dashboard
4.1. The Server Tree
4.2. The Server Graphs and Critical Events
4.3. The Heat Chart
5. The Settings Page
5.1. Global Settings
5.2. User Preferences
5.3. Manage Servers
5.3.1. Renaming a Server
5.3.2. Grouping Servers
5.3.3. Removing a Server From the Dashboard
5.4. Managing Users
5.5. Manage Notification Groups
5.6. Logs
5.7. The Product Information Screen
5.7.1. Subscription Warning
6. The Advisors Page
6.1. Installing and Updating Advisors
6.2. Scheduling Rules
6.2.1. Heat Chart Notifications
6.3. Editing Built-in Rules
6.4. Creating Advisors and Rules
6.4.1. Creating Advisors
6.4.2. Overview of Rule Creation
6.4.3. Variables
6.4.4. Thresholds
6.4.5. Using Strings
6.4.6. Wiki Format
6.4.7. Creating a New Rule: An Example
6.4.8. Creating a Custom Data Collection Item
6.5. Disabling and Unscheduling Rules
6.6. Advisor Blackout Periods
6.6.1. Scripting Blackouts
7. The Events Page
7.1. Closing an Event
8. The Graphs Page
8.1. Displaying Graphs
8.2. Setting an Interval
8.3. Setting a Time Span
9. The Query Analyzer Page
9.1. Enabling Query Analyzer
9.1.1. Enabling Query Analyzer by Changing the MySQL Client Application
9.1.2. Enabling Query Analyzer by Changing MySQL Server
9.2. Getting Detailed Query Information
9.3. Filtering Query Analyzer Data
9.4. Using Query Analyzer Data
9.5. Troubleshooting Query Analyzer
9.6. Query Analyzer Settings
10. The Replication Page
10.1. Replication Page Details
A. MySQL Enterprise Monitor Frequently Asked Questions
B. Files Associated with The MySQL Enterprise Monitor
B.1. Log Files for the MySQL Enterprise Service Manager
B.2. Monitor Agent and Service Manager Installation Log Files
B.3. Agent Log and PID Files
B.4. The Management Information Base (MIB) File
B.5. The config.properties File
C. Error codes
D. MySQL Enterprise Monitor Change History
D.1. Changes in MySQL Enterprise Monitor 2.1.0 (Not yet released)
D.2. Changes in MySQL Enterprise Monitor 2.0.6 (Not yet released)
D.3. Changes in MySQL Enterprise Monitor 2.0.5 (18th March 2009)
D.4. Changes in MySQL Enterprise Monitor 2.0.4 (5th February 2009)
D.5. Changes in MySQL Enterprise Monitor 2.0.3 (23rd January 2009)
D.6. Changes in MySQL Enterprise Monitor 2.0.2 (14th January 2009)
D.7. Changes in MySQL Enterprise Monitor 2.0.1 (15th December 2008)
D.8. Changes in MySQL Enterprise Monitor 2.0.0 (11th December 2008)
E. The Data Collection Items Used to Create Rules

List of Figures

1.1. MySQL Enterprise Monitor Architecture
2.1. MySQL Enterprise Monitor: Installing Monitor on Windows: Language Selection
2.2. MySQL Enterprise Monitor: Installing Monitor on Windows: Installation Directory
2.3. MySQL Enterprise Monitor: Installing Monitor on Windows: Tomcat Server Options
2.4. MySQL Enterprise Monitor: Installing Monitor on Windows: Repository Configuration
2.5. MySQL Enterprise Monitor: Installing Monitor on OS X: Language Selection
2.6. MySQL Enterprise Monitor: Installing Monitor on OS X: Java Selection
2.7. MySQL Enterprise Monitor: Installing Monitor on OS X: Installation Directory
2.8. MySQL Enterprise Monitor: Installing Monitor on OS X: Tomcat Server Options
2.9. MySQL Enterprise Monitor: Installing Monitor on OS X: Repository Configuration
2.10. MySQL Enterprise Monitor: Initial Dashboard Log-In
2.11. MySQL Enterprise Monitor: Outgoing Email Settings
2.12. MySQL Enterprise Monitor: Installing Agent on Windows: Language Selection
2.13. MySQL Enterprise Monitor: Installing Agent on Windows: Installation Directory
2.14. MySQL Enterprise Monitor: Installing Agent on Windows: Monitored Database Information
2.15. MySQL Enterprise Monitor: Installing Agent on Windows: Query Analyzer Configuration
2.16. MySQL Enterprise Monitor: Installing Agent on Windows: MySQL Enterprise Service Manager Options
2.17. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Language Selection
2.18. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Installation Directory
2.19. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Monitored Database Information
2.20. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Monitored Database Information
2.21. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Query Analyzer Configuration
2.22. MySQL Enterprise Monitor: Installing Agent on Mac OS X: MySQL Enterprise Service Manager Options
2.23. MySQL Enterprise Monitor: Server Update: Language Selection
2.24. MySQL Enterprise Monitor: Server Update: Previous Installation
2.25. MySQL Enterprise Monitor: Server Update: Backup of Previous Installation
2.26. MySQL Enterprise Monitor: Server Update: Completed installing files
2.27. MySQL Enterprise Monitor: Server Update: Final Setup
3.1. MySQL Enterprise Monitor: Historical Data Migration Availability
3.2. MySQL Enterprise Monitor: Confirming Historical Data Migration
3.3. MySQL Enterprise Monitor: Historical Data Migration Progress
4.1. MySQL Enterprise Dashboard: The Graphs Screen
4.2. MySQL Enterprise Dashboard: The Heat Chart
4.3. MySQL Enterprise Dashboard: The Heat Chart Legend
5.1. MySQL Enterprise Dashboard: Settings
5.2. MySQL Enterprise Dashboard: User Preferences
5.3. MySQL Enterprise Dashboard: Manage Servers
5.4. MySQL Enterprise Dashboard: Server Renaming
5.5. MySQL Enterprise Dashboard: Manage Users
5.6. MySQL Enterprise Dashboard: Manage Notification Groups
5.7. MySQL Enterprise Dashboard: Logs
6.1. MySQL Enterprise Dashboard: Scheduling Dialog
6.2. MySQL Enterprise Dashboard: Editing Rules
7.1. MySQL Enterprise Dashboard: Events Screen
9.1. MySQL Enterprise Dashboard: Query Analyzer
9.2. MySQL Enterprise Dashboard: Standard Agent/Monitor Topology
9.3. MySQL Enterprise Dashboard: Query Analyzer Agent/Monitor Topology
9.4. MySQL Enterprise Dashboard: Canonical Query Tab for a Query
9.5. MySQL Enterprise Dashboard: Example Query Tab for a Query
9.6. MySQL Enterprise Dashboard: Explain Query Tab for a Query
9.7. MySQL Enterprise Dashboard: Query Analyzer Configuration
10.1. MySQL Enterprise Dashboard: Replication Groups
Document Actions