Chapter 4. MySQL Enterprise Dashboard
Color coding helps distinguish different aspects of each graph.
With Database Activity for example, you can
readily distinguish SELECT statements from
database insertions.
Clicking a graph opens a detailed view with Graph
Display and Configure tabs. Choose
the Configure tab to temporarily change the way
that a graph displays. Changes made from this tab only apply to
the standalone graph while it is open. Persistent changes are made
as described above.
Dismiss the enlarged graph by clicking the button.
Critical alerts appear on this page immediately
below the graphs–quickly attracting your attention. For a
description of all the different alarm levels see,
Section 4.3, “The Heat Chart”. This is the subject of
discussion in Chapter 7, The Events Page.
The Heat Chart is found on the right side of
the Monitor page and shows the status of
critical rules. Monitored servers are organized by groups. To view
the status of a specific server, click the
button next to the appropriate server
group.
Whenever a new agent contacts the Service Manager for the first time, all the rules in the Heat Chart Advisor are automatically activated. These Advisors monitor the status of the server and agent, critical operating system indicators, and important events related to your MySQL servers. An example follows.
To interpret the Heat Chart see the following legend.
The status unknown will typically apply when an
agent is down and can no longer report the status of the server
that it is monitoring. The status unknown may
also apply if the data collection that should be collected is not
available on the server being monitored.
You may open the Heat Chart in its own browser window by clicking
the Standalone Heat Chart link immediately
below the Heat Chart on the left. If you like,
the refresh rate can be set to a different rate than the setting
on the Monitor page.
In addition to showing the most important advisors, the
Heat Chart also has columns that display the
number of critical, warning, and informational alarms. Clicking
the hyperlink in any one of these columns takes you to the
Event screen, which gives more detailed
information. For more information about events see,
Chapter 7, The Events Page.
When the Dashboard is first installed no notification groups are associated with the Advisors shown in the Heat Chart. For more information on this topic see, Section 2.2.7.3, “Installing Advisors After Initial Log-in” and, Section 5.5, “Manage Notification Groups”.