MySQL :: MySQL Enterprise Monitor 2.3.10 :: 4.1.8 Creating a New Rule: An Example

MySQL Enterprise Monitor 2.3.10 :: 4 Customizing MySQL Enterprise Monitor :: 4.1 Creating Advisors and Rules :: 4.1.8 Creating a New Rule: An Example

« 4.1.7 Wiki Format

4.1.9 Creating a New Graph: An Example »

Section Navigation [Toggle]

4.1 Creating Advisors and Rules
4.1.1 Creating Advisors
4.1.2 Overview of Graph Creation
4.1.3 Overview of Rule Creation
4.1.4 Variables
4.1.5 Thresholds
4.1.6 Using Strings
4.1.7 Wiki Format
4.1.8 Creating a New Rule: An Example
4.1.9 Creating a New Graph: An Example
4.1.10 Creating a Custom Data Collection Item

4.1.8. Creating a New Rule: An Example

This section documents the steps to create a rule. Before creating a rule, review the preceding sections of this chapter.

This example creates a rule that checks the number of rows in a table. We decide that having 50,000 rows in this table triggers a critical alert. Lesser numbers produce informational and warning level alerts.

Begin by navigating to the Advisors tab and clicking the manage rules link. Then choose the create rule button.

Create your custom rule by following these steps:

Using the Rule Name text box, give the rule an appropriate name, in this case something such as "Excessive number of records in table_name table".
From the Advisor drop down list box, choose an advisor group for your rule. The Administration group of rules might be suitable but if you wish, create your own group of advisors. For instructions on doing this, see Section 4.1.1, “Creating Advisors”.
Enter the following expression in the Expression text area: '%table_name_num_rows% > THRESHOLD'. Replace table_name with the name of the table to monitor. Note that the variable %table_name_num_rows% is not yet defined.
Set the Thresholds.
1. Set the Critical Alert level to 50000.
2. Set the Warning Alert level to 10000.
3. Set the Info Alert level to 5000.
Define your variable in the Variable Assignment frame.
1. In the Variable text box, enter '%table_name_num_rows%, the variable used in the Expression text box.
2. In the Data Item drop down list box, find and select the mysql:table:numrows entry. (For a description of all the data items available, see Appendix D, Data Collection Items.)
3. In the Instance text box, enter database_name.table_name.
Add appropriate entries for the Problem Description, the Advice, and the Links text areas. Optionally, use Wiki markup for these text areas. You can also reference the '%table_name_num_rows% variable in these text areas. For example, you can display the current number of rows with a message such as 'table_name currently has %table_name_num_rows% rows.'
Save the rule.

After you create the rule, schedule it against the server that contains the database table to monitor. For instructions on scheduling rules, see Section 2.3.2, “Scheduling Rules”.

Top / Previous / Next / Up / Table of Contents