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