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.
Navigate to the Graphs page by choosing the
Graphs tab.
By default four graphs are displayed on the Monitor
page. These graphs present information about the currently
selected server or server group, showing the hit ratios, CPU
utilization, connections, and database activity. Color coding helps
distinguish different aspects of each graph.
From the Monitor page you can make permanent or
temporary changes to the way a graph is displayed. For example, you
can choose to display the last hour's activity or you can choose to
view a specific period of time.
Persistent changes to the way the graphs display are only made from
the Monitor page. You can set the size of the
thumbnails and the full-sized graphs and you can also set their
refresh interval. For more information, see
Section 3.2, “The Server Graphs and Critical Events”. As with the
Monitor page, the data shown in the graphs is
determined by the server or group of servers selected in the server
tree.
The Graphs page shows all the available graphs
and provides the capability of adjusting the scale of the graphs,
allowing a more or less detailed view as the situation requires. To
ensure that you have the latest versions of the various graphs click
on the Check For Updates link on the top left
of this page.
The total number of graphs varies depending upon your subscription
level. The four graphs that appear by default on the
Monitor page are:
Hit Ratios
Database Activity
Connections
CPU Utilization
When the Graphs page is first opened, no graphs
are visible. To view a graph click the
button on the left or, to view all graphs, use the
button.
The larger size of graphs is the primary reason for viewing graphs
on the Graphs page rather than on the
Monitor page. Additionally, you can only show a
maximum of six graphs on the Monitor page; the
remaining graphs can only be viewed from the
Graphs page.
Change the interval for a graph by choosing values from the
Hours and Minutes
drop-down list boxes. If necessary adjust the width and height of
the graph and then click the button.
The changes to the time span apply to all the graphs on the
Graphs page but have no
effect on the graphs on the Monitor page.
To change the graphs both here and on the
Monitor page use the configure
graphs link on the top right. This opens a dialog box
for setting the default interval for the x-axis. Save any changes
that you have made and the values chosen will be the defaults
whenever you log in. You can also change the defaults from the
Monitor page as described in
Section 3.2, “The Server Graphs and Critical Events”; defaults for other
users will be unchanged.
Use the button to restore the default value for the interval. Doing this will also reset the default size of the graphs.
Setting a graph to display a time span gives you a historical perspective on server activity. You may want to know what was happening at a specific point in time or you may wish to look at an extended period to determine patterns or trends. Changing the time span gives you the flexibility to do this.
In the Time Display drop-down list box select
the From/To option. Choosing this option
updates the display to include To and
From text boxes.
Set the date you wish to start viewing from by manually entering the date in year, month, and day format (2007-03-14). However, it is much easier to click the calendar icon and choose a date from the drop-down calendar. Enter a terminating date in the same way. If you wish, you may also choose the specific time of day by selecting the hour and minute.
If necessary adjust the width and height of the graph and then
click the button. The changes to the
time span apply to all the graphs on the Graphs
page but have no effect on the graphs on the
Monitor page. You cannot change the time span
of the graphs that appear on the Monitor page.
Changes apply only to the current user; defaults for other users
will be unchanged.
Use the button to cancel your changes.