MySQL Sorts Test

The test monitors the sort operation performed on the MySQL database 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

TEST PERIOD – How often should the test be executed Host – The IP address of the MySQL server Port – The port on which the server is listening db – the name of a database on the server 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. Confirm password – Confirm the password by retyping it here.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Range sort rate:	Indicates the rate at which ranges were sorted.	Sorts/Sec
Row sort rate:	Indicates the rate at which rows were sorted	Sorts/Sec
Scan sort rate:	Indicates the rate at which sorting was performed by scanning the table	Sorts/Sec
Merge passed sort rate:	Indicates the rate at which the sort algorithm performed merge passes	Sorts/Sec	If this value is large you should consider increasing the sort_buffer.