MySQL Transactions Test

Rollbacks are costly operations on the database. This test monitors the percentage of rollbacks happening for user transactions in a database instance.

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

Parameter	Description
Test Period	How often should the test be executed.
Host	The IP address of the MySQL server.
Port	The port at which the specified host listens.
Database	Specify the name of a database on the target MySQL database server being monitored
Username 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 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
User commits	Indicates the number of internal COMMIT commands issued during the last measurement period.	Number
User rollbacks	Indicates the number of internal ROLLBACK commands issued during the last measurement period.	Number	Ideally, there should be few user rollbacks happening.
Rollbacks	Indicates the number of internal rollbacks expressed as a percentage of the total transactions with the database.	Percent	Ideally, there should be few user rollbacks happening.