- 2 Using and Configuring MySQL Enterprise Dashboard
- 2.1 MySQL Enterprise Dashboard
- 2.2 The Monitor Tab
- 2.3 The Advisors Tab
- 2.4 The Events Tab
- 2.5 The Graphs Tab
- 2.6 The Query Analyzer Tab
- 2.7 The Replication Tab
- 2.8 The Settings Tab
- 2.9 The What's New Tab
- 2.10 Performance Tuning MySQL Enterprise Dashboard for Large Installations
- 2.11 Troubleshooting the MySQL Enterprise Dashboard
The Monitoring tab, which is shown first when you log in to MySQL Enterprise Dashboard, provides a quick overview of your current monitoring information, and provides an instant health check for all of the MySQL servers across the enterprise.
From this page, you can:
View monitoring data and all critical MySQL Advisor Rule violations for all or selected servers.
Close and annotate MySQL Advisor Rule violations.
Determine if there is a Monitor Agent that is not communicating with the Service Manager.
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 defaults to a thumbnail view, but opens into a larger image upon being clicked.
Graphs are shown in the center of the page beneath the tabs. If applicable, you also see a list of critical events.
On the right is the color-coded Heat Chart,
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 can
open the Heat Chart in its own window by
clicking the Standalone Heat Chart link. If
applicable, you also see a list of critical events.
The Show/Hide Legend link toggles display of
the explanations of the icons used in the Heat
Chart.
Find colorblind-accessible icons in the
alternate directory. On Linux, this
directory is immediately below the
/monitor/apache-tomcat/webapps/ROOT/web/resources/images/
directory. These images are stored in the same directory on
Windows. To use them, back up the originals and then copy and
paste the alternate set into the images
directory.
When a specific server is selected in the Server
Tree, the Meta Info area beneath the
legend shows details about this server. 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.
The 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. When you mouse over the date shown beside Up
Since, a pop-up box displays the elapsed time since the
server instance was last started. You can also mouse over the
Last MySQL Contact and the Last
Agent Contact dates.
In the case of remote monitoring, the agent runs on a different
machine than the MySQL server that it is monitoring. The
Hostname, MySQL, and
Rules information applies to the system being
monitored. The OS and CPU
information applies to the machine on which the agent is
running. For more information about remote monitoring, see
Section 5.3.7, “Configuring an Agent to Monitor a Remote MySQL Server”.
