MySQL Server Connection Use Percent Monitor Monitor

  • ID:  Microsoft.MySQLServer.ManagedServer.Unix.ConnectionsUsePct.Monitor
  • Description:  MySQL Server Connection Use Percent Monitor
  • Target:  Monitored MySQL Server (Linux)
  • Enabled:  On Standard Monitoring

Operational States

Name State Description
Under Threshold Success Under Threshold
Over Warning Threshold Warning Over Warning Threshold
Over Error Threshold Error Over Error Threshold

Overridable Parameters

Parameter Name Default Value Description Override
Interval 300 Interval in seconds
Number of Samples 3 Number of Samples
Warning Threshold 80 Warning Threshold
Error Threshold 90 Error Threshold

Alert Details

Monitor State Message Priority Severity Auto Resolution
Over Warning Threshold (Warning) MySQL Server Connections Use Percent Medium Match Monitor Health Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

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.

External References
This monitor does not contain any external references.

See Also for Open Source Software Preview Management Pack


Downloads for Open Source Software Preview Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED