The key features of the MySQL Enterprise Monitor can be summarized as follows:
Group-level or Server-level management options
Enterprise Dashboard for managing all MySQL Servers from a consolidated console
Monitoring page for “at a glance” global health check of key systems
MySQL-provided Advisors and Advisor Rules for enforcing MySQL Best Practices
Advisor Rule Scheduling for unattended operations
Customizable Thresholds and Alerts for identifying Advisor Rule violations
User-Defined Advisor Rules
Event/Alert History browser for researching advisor-specific events and annotations
Query Analyzer functionality allowing you to monitor the execution times, row counts and other data about queries executed on your MySQL server.
These features are presented through the MySQL Enterprise Dashboard which is made up of six main pages:
The Monitor page comprises:
The Server Tree: Easily navigate monitored servers
The Graphing: This capability is built in so you can quickly assess critical functions such as activity, performance metrics, and number of connections
The Heat Chart: Color-coded buttons provide key operating system and database metrics
The Advisors page
This page shows the advisors that are currently scheduled. There are advisors for a variety of topics such as security and indexing. Users can add, edit, or create their own advisors.
The Events page
This page shows rule violations, indicating the server, severity, and time of occurrence. A number of filter options are available, allowing various views of events.
The Graphs page
Use this page to view all the available graphs and to adjust the scale of the graphs, for a more or less detailed view as the situation requires.
The Query Analyzer page
The Replication page
Use this page to keep track of your masters and their slaves (Not available for all subscription levels)
The Settings page
On this page you configure servers, users, email addresses, and notification groups. Entering a user name and password for MySQL Enterprise provides automatic updates.