MySQL Cache Test

This test reports statistics pertaining to the key buffer cache in the 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

Key reads:

Indicates the number of physical reads of a key block from the disk during the last measurement period.

Number

A high value of this measure indicates that your key_buffer_size variable is probably too small.

Key read requests:

Indicates the number of key read requests received by the cache during the last measurement period.

Number

 

Not flushed key blocks:

Indicates the key blocks in the key cache that have been modified, but have not been flushed to the disk during the last measurement period.

Number