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
• Status: Duplicate
• 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.