Home
  •  

MySQL Server: Threads open Health Monitor

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

This monitor catches Xian events that notifies when the Threads open has changed its state.

Knowledge Base article:

Summary

Threads open is over threshold.

The number of threads that are currently open is above the maximum threshold configured in Xian Network Manager 2012.

Causes

The number of active threads or clients has increased past your parameters due to demand.

Resolutions

Monitor the origin of queries. If you want to limit the number of threads, you should limit the number of connections. Clients that send several queries to the server could use persistent connections and you can use the max_user_connections variable to limit overall connections or limit per user.

Additional

Monitors the number of open threads.

Element properties:

TargetJalasoft.Xian.Common.Elements.ThirdParty.MySQL.JsXInstanceElement
Parent MonitorSystem.Health.PerformanceState
AlgorithmWorstOf
CategoryStateCollection
EnabledTrue
Alert GenerateTrue
Alert SeverityMatchMonitorHealth
Alert PriorityLow
Alert Auto ResolveTrue
RemotableTrue
AccessibilityPublic
Alert Message
Threads open Alert
{0}

Source Code:

<AggregateMonitor ID="Jalasoft.Xian.SmartManagementPacks.MySQLServers.ThreadsOpen.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="ThreadsOpen_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>