Documentation Home
MySQL Enterprise Monitor 3.4 Manual
Related Documentation Download this Manual

20.1.1 Graph Controls

This section describes the controls available on the All Timeseries Graphs page.

Asset Selector

The Asset Selector is a treeview container on the left side of the page. It lists all the hosts to which the user has access. The hosts are organized by group.

The group displayed depend on those configured. If no groups are configured, the All group is the only group displayed, and all hosts are contained within it.

The graphs displayed depend on what is selected in the Asset Selector. The Asset Selector displays the following:

  • Group

  • Host

  • Instance

  • Network Interface

  • Filesystem

  • Agent (if installed on host)

Important

The Asset Selector displays only those assets to which you have access.

The Asset Selector can be filtered to display specific assets. To filter the Asset Selector, click the filter icon in the top-right corner of the Asset Selector frame. The Filter field is displayed. Enter the text to filter on. The Asset Selector displays the filtered results.

To display monitored instances only, deselect the Show All Assets check box.

Graph Filter

The graph filter enables you to display a subset of the available graphs.

Table 20.1 Timeseries Graph Filter

Name Description

Graph Name

Opens a drop-down menu listing the available search types:

  • Contains

  • Doesn't Contain

  • Regex

  • Negative Regex

Value

Free text field for the search term or regular expression.

Time Range

Drop-down lists containing the time periods to apply to the graphs. The possible values are:

  • Interval: select the duration for the overview data. If you select 1 hour, the data collected in the last hour is displayed.

  • From/To: select a date and time range for the overview data.

Filter

Apply the defined filter.

Save as Default

Sets the selected group and time range as the default.

It is not possible to save a date range, using From/To, as the default for a group.

Reset to Default

Resets the graph display to the previously saved values.


Graph Manipulation

This section describes the various actions you can perform on individual graphs.

  • Graph Height: slider which enables you to increase or decrease the height of the graph in pixels. This slider does not affect the values of the x or y axes, just resizes the graph.

  • Export as CSV: downloads a CSV containing all data currently displayed in the selected graph.

  • Export as PNG: generates a PNG image file of the selected graph. The image is displayed in a pop-up. To save the image, right-click and select Save image as....

  • Move: enables you to move the selected graph to another location on the page.

  • Stacked/Line: enables you to change how the graph is displayed. Line displays a line graph, while Stacked displays each data source as a solid color.

  • Legend: lists the sources of information displayed in the graph. The color of the name matches the line/stack used in the graph. To display individual sources, click the required source in the Legend. To highlight individual sources in the graph, hover the cursor over the source's name.

Graph Query Analysis

Graph Query Analysis enables you to examine the queries which were running during specific intervals. To open the Query Analyzer for a specific range on a graph, do the following:

  1. On a graph, select a range by clicking at the required start point, and dragging the cursor across the graph until you reach the required interval endpoint and release the mouse button. This selects the range.

  2. Several icons are displayed in the top-right corner of the selection. An x to close the selection, a database icon, and a magnifying glass. Click the database icon to open the Query Analyzer's Browse Queries page. Click the magnifying glass to zoom in on the selected range.

    Browse Queries displays all the queries which were running during the defined time period. This enables you to drill down into potential query bottlenecks and performance hotspots and tune your queries accordingly.

    For more information on the Query Analyzer, see Section 29.3, “Query Analyzer User Interface”.