MySQL Network Test

This test monitors the data transmission between the MySQL server and its clients. 

Target of the test : A MySQL server

Agent deploying the test : An external 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

Data transmit rate:

The rate of data being transmitted by the server in response to client requests during the last measurement period

KB/Sec

The data transmission rate reflects the workload on the server.

Data received  rate:

 

The rate of data received by the server from clients during the last measurement period

KB/Sec

This measure also characterizes the workload on the server.