Skip navigation links
15.1.3 Security »
Section Navigation      [Toggle]

15.1.2. Service Features

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.