MySQL Bugs: #29412: Execute SQL or a script when a rule fires

Bug #29412	Execute SQL or a script when a rule fires
Submitted:	28 Jun 2007 7:26	Modified:	30 Jun 2007 10:16
Reporter:	Kristian Koehntopp	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Enterprise Monitor: Advisors/Rules	Severity:	S4 (Feature request)
Version:	1.1.0	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	script execution tied to rule

Description:
On a certain server, I am seeing "Maximum Connection Limit Nearing Or Reached". To debug this, I am recording SHOW FULL PROCESSLIST output via cron into a ring buffer.

It would be more useful if Merlin had the capability to tie a SQL statement or an external script to a rule and trigger execution of that item to the activation of the rule, then record the result with the rule result.

How to repeat:
Build a situation where you need deeper debug, try to solve the problem. :-)

Suggested fix:
Build a capability into agent and server that allows be to specify

execute SQL/script
on agent/on server
when rule result is info/warning/critical/rule execution failure/test ok
and record/don't record the result (exit status, stderr and stdout)

Sample usecase: See above. "Recording a SHOW FULL PROCESSLIST output on Maximum Connection Limit Nearing or Reached".

Thank you for a reasonable feature request.