MySql Activity Test

This test tracks the writes, inserts, deletes, and flushes happening on a MySQL server database.

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

Delayed writes:

Indicates the rate at which rows are written with INSERT DELAYED.

Writes/Sec

 

Delayed errors:

Indicates the rate at errors occurred in the  rows written with INSERT DELAYED.

Errors/Sec

 

Updates:

Indicates the rate at which requests to update a row in a table were received.

Updates/Sec

 

Inserts:

Indicates the rate at which requests to insert a row in a table were received.

Inserts/Sec

 

Deletions:

Indicates the rate at which requests to delete a row in a table were received.

Deletions/Sec

 

Flushes:

Indicates the rate at which FLUSH commands were executed.

Flushes/Sec