Bug #43243 Server restart adviser rule

• Submitted: 26 Feb 2009 22:33
• Modified: 25 Jun 2009 9:53
• Reporter: Adam Dixon
• Status: Closed
• Category: MySQL Enterprise Monitor: Advisors/Rules
• Severity: S3 (Non-critical)
• Version: 2.x
• OS: Any
• Assigned to: Andy Bang
• CPU Architecture: Any

[26 Feb 2009 22:33] Adam Dixon

Description:
Signal server restarts. I created a Rule name "Server Restarted" as a Heat Chart advisor with the following options, can this be included in default advisers bundles:

Expression: (%Uptime% < THRESHOLD)

Critical Alert: 600
Warning Alert: 600
Info Alert: 600

Variable: %Uptime%

Data Item: mysql.status:Uptime

Instance: local

Default frequency: 5 minutes
--

I set the default frequency to 5 minutes (300 seconds). This way we shouldn't miss one if Alerts are set at < 600 (seconds).

How to repeat:
No need.

Suggested fix:
Please add to built adviser bundles.

[10 Apr 2009 23:26] Andy Bang

In the 2.1 codeline: Pushed up to revision 258.

[16 Apr 2009 20:27] Keith Russell

Patch installed in versions => 2.1.0.1026.

[2 Jun 2009 15:14] Keith Russell

Patch installed in versions => 2.1.0.1053.

[2 Jun 2009 20:39] Marcos Palacios

Verified fixed in advisor build 2.1.0.1053.

[25 Jun 2009 9:53] Tony Bedford

An change entry has been added to the 2.1.0 changelog:

A rule has been added named “Server Restarted” to signal a server restart. This has been added as a Heat Chart advisor to the Silver level advisor bundle. The rule has the following options:

Expression: (%Uptime% < THRESHOLD)

Critical Alert: 600
Warning Alert: 600
Info Alert: 600

Variable: %Uptime%

Data Item: mysql.status:Uptime

Instance: local

Default frequency: 5 minutes