Bug #45237 Merlin advisor emails should show the triggered value not just the expression
Submitted: 1 Jun 2009 9:10 Modified: 10 Jun 2009 22:46
Reporter: Bogdan Kecman Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Enterprise Monitor: Advisors/Rules Severity:S4 (Feature request)
Version:2.0 OS:Any
Assigned to: Mark Matthews CPU Architecture:Any

[1 Jun 2009 9:10] Bogdan Kecman
Description:
The alert email from MEM show expression instead of value .. for example:

...
Expression
(%Uptime% > 10800) && (100-((%Threads_created% / %Connections%)*100) < THRESHOLD)

Evaluated Expression
(2908145 > 10800) && (100-((160 / 2504)*100) < 95) 
...

How to repeat:
look at alerter emails

Suggested fix:
instead of showing the expression evaluated (or in addition to it) display the real values:

...
Expression
(%Uptime% > 10800) && (100-((%Threads_created% / %Connections%)*100) < THRESHOLD)

Evaluated Expression
(2908145 > 10800) && (100-((160 / 2504)*100) < 95) 

Thread cache hit ratio is 93.6%, below threshold of 95%
...
[10 Jun 2009 22:46] Andy Bang
This is essentially a duplicate of Bug #40220 - Show calculated values for MEM rules.