MySQL Connection Test

This test gives information about client connections to a MySQL server.

Target of the test : A MySQL server

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for the database being monitored

Configurable parameters for the test
  1. TEST PERIOD – How often should the test be executed
  2. Host – The IP address of the MySQL server
  3. Port – The port on which the server is listening
  4. db – the name of a database on the server
  5. Usernameand password - The eG agent has to be configured with the credentials of a user who has server-wide process and select privileges on the monitored MySQL server. To know how to create such a user, refer to Pre-requisites for Monitoring the MySQL Server topic.
  6. Confirm password – Confirm the password by retyping it here.
Measurements made by the test
Measurement Description Measurement Unit Interpretation

Connection create rate:

The rate at which applications attempted to connect to the MySQL server during the last measurement period

Conns/Sec

The data transmission rate reflects the workload on the server.

Active connections:

The number of currently open connections to the MySQL server

Number

A high value may be indicative of connections not being closed properly by applications, or a bottleneck in the server

Connection aborts:

The number of connections that were aborted because the client terminated without closing the connection properly during the last measurement period

Number

 

Failed connections:

The number of connection attempts to the MySQL server that failed during the last measurement period

Number

A high value can indicate:

  • a configuration problem with the server/clients;
  • some malicious attack on the server;

Max connections:

The maximum number of connections that were in use simultaneously in use during the last measurement period

Number

 

Maximum connection limit

Indicates the maximum number of connections that can be opened on the server.

Number

 

Connection usage

Indicates the percentage utilization of the connections on the server.

Percent