This section documents the steps to create an Advisor.
To create an Advisor, select the Create Advisor button from the Advisors page. The new advisor page is displayed:
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,
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
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”.