Documentation Home
MySQL Enterprise Monitor 8.0 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 6.0Mb
PDF (A4) - 6.0Mb


19.1 Manage Advisors Page

This section describes the main Advisors page.

To display the Advisors page, select Advisors from the Configuration menu.

Figure 19.1 Manage Advisors Page

Content is described in the surrounding text.

The components and controls of the Manage Advisors page are as follows:

Table 19.1 Manage Advisors Page Controls

Name Description

Edit Selected

Opens the edit dialog for the selected advisor. This control can also be used for multiple Advisors, but it is only possible to change the Schedule for multiple Advisors simultaneously. You can also edit an advisor using the drop-down menu adjacent to each advisor’s name.

Disable Selected

Disables all selected Advisors.

Create Advisor

Opens the Create Advisor page.

Import/Export

Opens the Custom Rule/Graph Export page. This functionality is for custom rules and graphs only.

Select All

Selects all Advisors.

Expand All

Expands all categories.

Collapse All

Collapses all categories and clears all selections.

Filter Advisors

Expands or collapses the Advisor filter. The Advisor filter enables you to filter the Advisors, groups and assets. For information on the named filters, see Section 14.3.5, “System and User-defined Filters”.


Advisor Categories

The following types of Advisor are provided:

  • Administration: Checks the MySQL instance installation and configuration.

  • Agent: Checks the status of each MySQL Enterprise Monitor Agent.

  • Availability: Checks the availability of the MySQL process and the connection load.

  • Backup: Checks whether backup jobs succeed or fail, required resources, and information about MySQL Enterprise Backup specific tasks.

  • Cluster: Checks the status of the monitored MySQL Cluster.

  • Graphing: Data for graphs.

  • Memory Usage: Indicate how efficiently you are using various memory caches, such as the InnoDB buffer pool, MyISAM key cache, query cache, table cache, and thread cache.

  • Monitoring and Support Services: Advisors related to the MySQL Enterprise Monitoring services itself.

  • Operating System: Checks the Host Operating System performance.

  • Performance: Identifies potential performance bottlenecks, and suggests optimizations.

  • Query Analysis: Advisors related to Queries and Query Analysis.

  • Replication: Identifies replication bottlenecks, and suggests replication design improvements.

  • Schema: Identifies schema changes.

  • Security: Checks MySQL Servers for known security issues.

It is also possible to create custom Advisors.

To display the Advisors in each category, click on the Category name. For a full description of the default advisors, see Chapter 21, GUI-Based Advisor Reference and Chapter 20, Expression-Based Advisor Reference.

Advisors configure the type of data collected by the Agent. If you do not want to monitor for a specific type of data, disabling the Advisor responsible for that data type instructs the Agents to stop collecting that data.

Advisor Listing Table

The listing table displays all categories, Advisors, monitored instances, and displays information on the configuration of the Advisors.

The configuration information is displayed in the following columns:

Table 19.2 Advisor Information Listing

Name Description

Item

Displays the Advisor name, group name, and monitored instance name. To expand the Advisor, click the expand icon.

Info

Click to display a tooltip which describes the Advisor.

Coverage

Displays the Advisor's coverage of the monitored instance. If the Advisor has been edited for a specific instance, this field is empty for that instance. If the default Advisor settings are used, this field displays (Covered).

Schedule

Displays the defined evaluation schedule. If the Advisor is disabled, this field displays Disabled for the level at which it was disabled, Advisor, Group or monitored instance.

Event Handling

Displays the event handling status icons. For more information, see Chapter 22, Event Handlers.

Parameters

Displays the Advisor's configuration details, thresholds, and so on.

Advisor Menu

To open the Advisor menu, click the drop-down icon next to the Advisor’s name.

Figure 19.2 Advisor Menu Control

Advisor menu drop-down icon is circled.

The Advisor menu is displayed:

Figure 19.3 Advisor Pop-up Menu

Content is described in the surrounding text.

Table 19.3 Advisor Edit Menu Controls

Name Description

Copy Advisor

Opens the Create New Advisor page and appends - Copy 1 to the Advisor name. This enables you to define new Advisors based on existing ones.

Note

This option is only available for expression-based Advisors.

Edit Advisor Configuration

Opens the Edit Advisor dialog. This enables you to change the parameters and schedule of the selected advisor.

Remove Advisor Configuration

Disables the advisor and restores the default values. This is useful if you are experimenting with Advisor configuration, misconfigure the Advisor, and want to start again with the default Advisor configuration.

Disable Advisor

Disables the advisor and its associated graphs.

Delete Advisor

Deletes the selected advisor.

Note

Only available for custom Advisors. It is not possible to delete the default Advisors.


Group and Host Menu

Each advisor contains the list of all groups defined in MySQL Enterprise Monitor. To see these groups, expand the contents of the Advisor by clicking on the Advisor’s name. This enables you to specify the Advisors you want to run for each group.

The top-level advisor contains the global configuration for all groups. That is, the configuration at the advisor-level applies to all groups and hosts it contains. Each nested group, and the monitored hosts contained in the group, have a drop-down menu enabling you to override the global configuration for each group or host, or disable the advisor for the specific group or host. Any change in advisor configuration at the group or host level, overrides the global configuration specified at the advisor level.

To open the Group menu, expand the Advisor and select the drop-down icon next to the Group name. The same menu is used for each host within the group. The menu contains the following items:

  • Override Advisor Configuration: opens the Advisor edit dialog, enabling you to change the Advisor's configuration for the assets in the group. Changes made at the group level, only affect the assets within the group.

    Important

    If a host, Host1 for example, exists in multiple groups and a configuration override is applied to one of those groups, it does not affect Host1. Data is still collected and events generated for Host1 because it exists in different groups within the same advisor. To ensure the override applies to Host1, you must apply the same override to Host1 in each group which contains it.

  • Disable Advisor: disables the Advisor for the selected group or host.

Advisor Filter

The Advisor filter enables you to search for specific Advisors, groups, hosts, or assets using text or regular expressions. To open the filter, click the filter button. For information on the named filters, see Section 14.3.5, “System and User-defined Filters”.

The Advisor Filter is displayed:

Figure 19.4 Advisor Filter Controls

Content is described in the surrounding text.

Table 19.4 Advisor Filter Controls

Name Description

Advisors

Opens a drop-down menu listing all available Advisors. You can select multiple Advisors.

Groups

Opens a drop-down menu listing all defined groups. You can select multiple groups.

Asset 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.

Filter

Filters the Advisors list based on the search terms.

Filter & Expand

Only available for named filters, not for the system filters. Filters the Advisors list based on the search terms and expands the categories and Advisors to display the search results.

Discard Changes

Removes any changes made to the saved filter.

Reset

Resets all filter values.