This section documents the steps to create an Advisor.
To create an Advisor, select the Advisors page. The new advisor page is displayed:button from the
This example creates an Advisor that checks if connections have
been killed using the
KILL statement and
generates an event.
Create your custom rule by following these steps:
Using the Advisor Name text box, give the Advisor an appropriate name, such as "Connections killed".
From the Advisor Category drop down list box, choose an Advisor category for your Advisor.
Define the variable for your expression in the Variable Assignment frame.
In the Variable text box, enter
%connections_killed%, the variable used in the Expression text box.
In the Data Item drop-down list, select the
For a description of all the data items available, see Appendix G, Data Collection Items.
In the Instance text box, enter
Enter the following expression in the Expression text area.
'%connections_killed% > THRESHOLD'
Set the following threshold:
Set the Info Alert level to
0. An informational event is generated if 1 or more connections are killed.
Add appropriate entries for the Problem Description, Advice, and Links text areas. Optionally, use Wiki markup for these text areas. You can also reference the
%connections_killed%variable in these text areas.
Save the Advisor
After you create the Advisor, schedule it against the MySQL server you want to monitor. For instructions on Configure Advisor, see Table 19.3, “Advisor Edit Menu Controls”.