MySQL Bugs: #56474: Displaying values from Evaluated Expression

Bug #56474	Displaying values from Evaluated Expression
Submitted:	1 Sep 2010 21:29
Reporter:	Gary Pendergast	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Enterprise Monitor: Web	Severity:	S4 (Feature request)
Version:	2.2.2.1730	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
It would be good to be able to take a value from the Evaluated Expression, and display it in the Problem Description. For example, for the rule "Table Cache Set Too Low For Startup", this has:

Expression: (%Uptime% < 10800) && ((%table_cache% - %Opened_tables%) <= THRESHOLD)

Evaluated Expression: (2078 < 10800) && ((256 - 268) <= 0)

What I'd like like is to be able to get the value of (256 - 268), and display that in the Problem Description.

How to repeat:
-

Suggested fix:
Perhaps allow value assignment and multi-line Expressions? So the example expression would become:

%my_fancy_var% = (%table_cache% - %Opened_tables%);
(%Uptime% < 10800) && (%my_fancy_var% <= THRESHOLD);

%my_fancy_var% could then be used in the Problem Description, too.

Did try this.. and it looks like value assignment is not working for me .

Expression
%monitored_value% == ((%cpu_idle%/(%cpu_idle%+%cpu_wait%+%cpu_user%+%cpu_sys%))*100) ;
(%monitored_value% <  THRESHOLD) ;

Evaluated Expression
%monitored_value% == ((13576170/(13576170+0+641280+183820))*100) ;
(%monitored_value% <  5) ;