Maria Connections Test

Monitoring client connections to a Maria Database server typically provide insights into the workload of the server and whether/not the server is sized well-enough to handle the load. This is exactly the type of visibility the Maria Connections test provides. This test tracks client connections to the target server and reports their usage. With the help of the metrics reported by this test, administrators can assess the load on the server and can determine whether/not the server has sufficient free connections to handle subsequent connection requests. Based on these insights, administrators can plan the future connection capacity of the server.

Target of the test : A Maria Database server

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for the Maria Database server being monitored

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed.

Host

The IP address of the Maria Database server.

Port

The port on which the server is listening

Database

Specify the name of the database that is to be monitored on the target Maria Database server

User and 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 Maria Database server. To know how to create such a user, refer to Configuring the eG Agent with Access Privileges section.

Confirm Password

Confirm the password by retyping it here.

SSL

This indicates that the eG agent will communicate with the Maria Database via HTTPS or not. By default, this flag is set to No, as the target Maria database is not SSL-enabled by default. If the target database is SSL-enabled, then set this flag to Yes.

Verify CA

If the eG agent is required to establish an encrypted connection with the target Maria Database server by authenticating the server's identity through verifying the server CA certificate, set Verify CA flag to Yes. By default, this flag is set to No.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Active connections

Indicates the count of incoming connections that were opened by the clients to the server.

Number

This is a good measure of the current load on the server.

A persistent high value or a bottleneck in the server is an indication for the administrator to check if the connections are not closed properly.

Connections aborted

Indicates the number of connections that were aborted due to the client terminating the connection instead of closing the connection during the last measurement period.

Number

 

Connections create rate

Indicates the rate at which connections were created to connect to the server from the clients during the last measurement period.

Connections/sec

 

Connections failed

Indicates the number of connection that failed on the server during the last measurement period.

Number

A high value of this measure may be an indication of either a configuration problem with the server/clients or some malicious attack on the server.

Maximum connections

Indicates the maximum number of connections that were simultaneously in use on the server during the last measurement period.

Number