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

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

The Advisor menu is displayed:

Figure 19.3 Advisor Pop-up Menu

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

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.