Enclose string values within double quotation marks in the
Expression or the
Thresholds text boxes. For example, the
expression for the “Slave I/O Thread Not Running”
advisor is:
(%Slave_running% == "ON") && (%Slave_IO_Running% != THRESHOLD)
Similarly, the Critical Alerts threshold text
box is set to a value of "Yes".
When the expression is evaluated, either
"OFF" or "ON" is
substituted for %Slave_running%, and
"Yes" or "No" for
%Slave_IO_Running%, depending on the state of
your system. If the slave is running but the I/O thread is not,
the expression becomes:
("ON" == "ON") && ("No" != "Yes")
Without quotation marks, this expression would not evaluate to
TRUE as it should.
So that it is interpreted properly, the ==
operator is converted to = before being
passed to the MySQL expression parser.