MySQL Server: Delayed writes Health Monitor

Jalasoft.Xian.SmartManagementPacks.MySQLServers.DelayedWrites.1.1 (AggregateMonitor)

This monitor catches Xian events that notifies when the Delayed writes has changed its state.

Knowledge Base article:

Summary

Outgoing error packets is over threshold.

The number of delayed writes is above the maximum threshold configured in Xian Network Manager 2012.

Causes

Delayed writes gain speed for an optimal use of disk but the flushing of delayed writes to the disk depends on the OS.

Resolutions

Power failures, resets and others may cause loss or mismatch of delayed writes. Backups are recommended when you wish to rely on delayed writes.

Additional

Monitors the number of delayed writes.

Element properties:

Target

Jalasoft.Xian.Common.Elements.ThirdParty.MySQL.JsXInstanceElement

Parent Monitor

System.Health.PerformanceState

Algorithm

WorstOf

Category

StateCollection

Enabled

True

Alert Generate

True

Alert Severity

MatchMonitorHealth

Alert Priority

Low

Alert Auto Resolve

True

Remotable

True

Accessibility

Public

Alert Message

Delayed writes Alert

{0}

Source Code:

<AggregateMonitor ID="Jalasoft.Xian.SmartManagementPacks.MySQLServers.DelayedWrites.1.1" Accessibility="Public" Enabled="true" Target="ThirdParty_MySQL!Jalasoft.Xian.Common.Elements.ThirdParty.MySQL.JsXInstanceElement" ParentMonitorID="SystemHealth!System.Health.PerformanceState" Remotable="true" Priority="Normal">

  <Category>StateCollection</Category>

  <AlertSettings AlertMessage="DelayedWrites_AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Low</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/Params/Param[3]$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <Algorithm>WorstOf</Algorithm>

</AggregateMonitor>