MySQL Enterprise subscription, MySQL Enterprise Monitor, MySQL Replication Monitor, and MySQL Query Analyzer are only available to commercial customers. To learn more, see: http://www.mysql.com/products/enterprise/features.html.
The purpose of the MySQL Enterprise Dashboard is to provide you with
information about your MySQL servers. It provides a list of the
latest MySQL Enterprise Advisor reports, server status information,
MySQL Enterprise alerts, and updated views of monitored MySQL
Monitor screen gives a quick
overview of the status of your MySQL servers.
The MySQL Enterprise Dashboard interface is provided through a standard web browser. For more details on the supported browsers, see Section 15.12.2, “Supported Browsers”.
You can open the Dashboard and connect to the MySQL Enterprise Dashboard either
using the standard HTTP protocol, or using an SSL connection
(HTTPS). By default, you can connect to MySQL Enterprise Dashboard using
host is the hostname or IP address of the
MySQL Enterprise Service Manager. The default SSL URL is
These values can be overridden during installation. You can check
the configured values by looking at the
configuration_report.txt file within your
If you are connecting using SSL, the built-in certificate has been self-signed and may be highlighted as 'unsafe' within the browser on initial connection. You should add an exception for the certificate on this server to prevent problems accessing the site.
The Monitoring page provides an instant health check for all of the MySQL servers across the enterprise.
From this page users can:
View monitoring data and all critical MySQL Advisor Rule violations for all or selected servers.
Close and annotate MySQL Advisor Rule violations.
Quickly determine if there is a Monitor Agent that is not communicating with the Service Manager.
Quickly determine if there is a server that is in trouble or completely down.
View indicator value graphs for key MySQL and operating system (OS) level metrics. Graph presentation will default to a thumbnail view but will open into a larger image upon being clicked.
The monitored server or servers are displayed in a tab on the left
known as the
Server Tree. You can navigate to a
number pages that provide more detailed information. These pages
Monitor — the overview page providing
you with a quick summary of the servers, their status, events,
availability and load. The remainder of this chapter details the
contents of this page.
Advisors — shows the various advisors
configured in your installation and allows you to schedule their
execution on different servers, apply and manage rules and
manage the advisor installation itself. For more information,
see Section 15.7, “The Advisors Page”.
Events — provides an interface into the event system that highlights specific issues and problems on your monitored servers. For more information on using Events, see Section 15.8, “The Events Page”.
Query Analyzer — interfaces to the
query monitoring system that can be used to monitor and track
the individual queries that are being executed on a system and
help to highlight problem queries that may need optimization or
that may be affecting server load. For more information, see
Section 15.10, “The Query Analyzer Page”.
Graphs — enables you to view and
configure a number of individual graphcs covering a range of
different statistics. For more details on how to view and use
these graphs, see Section 15.9, “The Graphs Page”.
Replication — provides information on
the status and structure of your servers that are using
replication. This page is only available if you have a suitable
subscription level. For more information, see
Section 15.11, “The Replication Page”.
Settings — controls the settings for
the server, including email configuration, passwords, and server
and user management. For more information, see
Section 15.5, “The Settings Page”.
Graphs are shown in the center of the page beneath the tabs. If applicable, you'll also find a list of critical events.
On the right is the color-coded
showing the advisors that are installed by default. The
Heat Chart shows the most important advisors,
allowing a quick overview of the state of your servers. You may open
Heat Chart in its own window by clicking the
Standalone Heat Chart link. If applicable, you'll
also find a list of critical events.
Show/Hide Legend link toggles display of the
key to the icons used in the
Find colorblind-accessible icons in the
alternate directory. On Linux this directory
is immediately below the
directory. These images are stored in the same directory on
Windows. To use them, backup the originals and then copy and paste
the alternate set into the
If a specific server is selected in the
Tree details about this server are shown beneath the
legend in the
Meta Info area. The information
shown in this area is the host name, the MySQL version number, the
number of scheduled rules, the operating system, and the CPU.
Meta Info section also shows how long the
agent has been running, when it last contacted the MySQL server it
is monitoring, and the last time the agent contacted the dashboard.
Mouse over the date shown beside Up Since and a
pop-up box displays the time that has elapsed since the server
instance was last started. You can also mouse over the
Last MySQL Contact and the Last Agent
In the case of remote monitoring, the agent runs on a different
machine than the MySQL server that it is monitoring. The
Rules information applies to the system being
information applies to the machine on which the agent is running.
For more information about remote monitoring see,
Section 220.127.116.11.4, “Configuring an Agent to Monitor a Remote MySQL Server”.
The top of the screen shows the refresh cycle and
Log Out links. Click
Help link to open the documentation in a
separate browser window. Choose
Log Out if you
wish to leave the Dashboard or to log in as a different user.
Different refresh rates are available from the drop-down listbox.
In the footer are external links to MySQL Enterprise and information about the current user. Users can remain connected to the Dashboard and update their subscription, use the Enterprise Knowledge Base, and contact technical support. Your subscription information is also displayed here, showing the number of days remaining and the number of licenses. The number of licenses indicates to the number of machines that may be monitored; any number of MySQL servers may be running on a specific machine.
The footer also contains a link to the
page. If your subscription is current it reads
Subscription is up-to-date. More info..... For
more information about the
Settings page see
Section 15.5.7, “The Product Information Screen”.