2.3.2 Scheduling Rules

2.3.2.1 Heat Chart Notifications

Once the MySQL Enterprise Advisors have been installed, you can configure which advisors you would like to run on a scheduled basis.

You can schedule rules by individual server or by group. This is done by first selecting the desired server or server group from the Server tree found on the left side of the screen. Next select the Advisors tab.

Opening the Advisors tab takes you to the Current Schedule page. If you only recently installed MySQL Enterprise Monitor, you only see the Heat Chart group of advisors. Clicking the + button shows all the rules in the Heat Chart group.

Clicking the + button beside any specific rule shows the servers that this rule is running on, its frequency, and its status. Initially, all the Heat Chart rules are enabled.

For a more complete description of a rule, click the rule's name. This opens a dialog box that gives detailed information about the rule.

To view the advisors other than the Heat Chart group, select the Add to Schedule link.

Rules are grouped by functionality and displayed in alphabetic order. To expand a group click the + button to the left of the advisor name.

To activate all the rules in a group, select the checkbox beside the group name. Then you can apply rules against a specific server or a group of servers. A message showing the selected server or server group is displayed below the schedule button. For example, if the All Servers group is selected in the server tree, then the message is Schedule Advisors Against All Servers.

To select a specific rule, expand the group tree by clicking the + button, then select the checkbox to the left of the rule. Click schedule to display the following dialog box:

Figure 2.4 MySQL Enterprise Monitor User Interface: Scheduling Dialog

MySQL Enterprise Monitor User Interface: Scheduling Dialog

The Schedule dialog box lets you configure the following fields:

Once you have set the schedule parameters, click the schedule button to schedule the advisor.

You can schedule multiple rules by selecting the checkbox next to each rule and clicking the schedule button is an effective way to schedule multiple rules.

When scheduling more than one rule, you can select a checkbox to use the default frequency of each rule, or choose a frequency that applies to all selected rules. When customizing the frequency, choose a value that is appropriate to all the rules selected.

Note

If the agent does not have the SUPER privilege and InnoDB-related rules are scheduled, a warning appears in the DataCollection log. This also occurs if mysqld is started with the skip-innodb option. For more information about agent rights, see Section 5.3.1, “Creating a MySQL User Account for the Monitor Agent”.