Home
  •  

MySQL Server Connection Use Percent Monitor

Microsoft.MySQLServer.ManagedServer.Unix.ConnectionsUsePct.Monitor (UnitMonitor)

Knowledge Base article:

Summary

The percent of MySQL Server connections that are currently being used. MySQL Server allows a finite amount of connections set by the global variable max_connections. This monitor takes the number of connections from the status variable ‘threads_connected’ and divides by the max_connections variable. The monitor threshold is analyzed against an average of values returned in polls to the agent where the Number of Samples parameter controls the number of samples included in the calculation of the average.

Causes

An unhealthy state indicates the percentage of current connections on the MySQL Server is currently high. This is likely caused by an excessive amounts of connections to the MySQL Server or improper closing of connections.

Resolutions

The global variable max_connections determines the maximum number of concurrent connections to MySQL. Consider adjusting this value to a greater amount and restarting the MySQL Server. Alternatives to adjusting this amount is ensuring client connections are not using persistent connections improperly. The monitor threshold is analyzed against an average of values returned in polls to the agent where the Number of Samples parameter controls the number of samples included in the calculation of the average.

Configuration

Default Configuration

Parameter

Default Value

Warning Threshold

Greater than 80

Error Threshold

Greater than 90

Number of Samples

3

Overrides can be used to change the parameter values defined above for all instances or for specific instances or groups.

Element properties:

TargetMicrosoft.MySQLServer.ManagedServer.Unix
Parent MonitorMicrosoft.MySQLServer.ConnectionsPerformanceRollup
CategoryPerformanceHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityMatchMonitorHealth
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.Oss.WSManEnumeration.GreaterThanThreshold.ThreeState.MonitorType
RemotableTrue
AccessibilityPublic
Alert Message
MySQL Server Connections Use Percent
The current Connections Use Percent ({0}\%) for the MySQL Server is high
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.MySQLServer.ManagedServer.Unix.ConnectionsUsePct.Monitor" Accessibility="Public" Target="Microsoft.MySQLServer.ManagedServer.Unix" TypeID="Oss!Microsoft.Oss.WSManEnumeration.GreaterThanThreshold.ThreeState.MonitorType" Enabled="onStandardMonitoring" ParentMonitorID="Microsoft.MySQLServer.ConnectionsPerformanceRollup">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Microsoft.MySQLServer.ManagedServer.Unix.ConnectionsUsePct.AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/Value$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState HealthState="Success" MonitorTypeStateID="StatusOK" ID="UnderThreshold"/>

    <OperationalState HealthState="Warning" MonitorTypeStateID="StatusWarning" ID="OverWarningThreshold"/>

    <OperationalState HealthState="Error" MonitorTypeStateID="StatusError" ID="OverErrorThreshold"/>

  </OperationalStates>

  <Configuration>

    <Interval>300</Interval>

    <TargetSystem>$Target/Host/Property[Type="Unix!Microsoft.Unix.Computer"]/NetworkName$</TargetSystem>

    <Uri>http://schemas.microsoft.com/wbem/wscim/1/cim-schema/2/MySQL_ServerStatistics?__cimnamespace=root/mysql</Uri>

    <WSManFilter/>

    <ObjectName>MySQL Server</ObjectName>

    <CounterName>Connection Use Pct</CounterName>

    <InstanceXPath>/DataItem/WsManData/*[local-name(.)='MySQL_ServerStatistics']/*[local-name(.)='InstanceID']</InstanceXPath>

    <InstanceName>$Target/Property[Type="Microsoft.MySQLServer.Installation"]/InstanceID$</InstanceName>

    <Value>$Data/WsManData/*[local-name(.)='MySQL_ServerStatistics']/*[local-name(.)='ConnectionsUsePct']$</Value>

    <WarningThreshold>80</WarningThreshold>

    <ErrorThreshold>90</ErrorThreshold>

    <NumSamples>3</NumSamples>

  </Configuration>

</UnitMonitor>