Maria Thread Statistics Test
This test tracks the Maria Database server threads and reports various performance statistics pertaining to them.
Target of the test : A Maria Database server
Agent deploying the test : An internal/remote agent
Outputs of the test : One set of results for the database being monitored.
Parameter | Description |
---|---|
Test Period |
How often should the test be executed. |
Host |
The IP address of the Maria Database server. |
Port |
The port on which the server is listening. |
Database |
Specify the name of the database that is to be monitored on the target Maria Database server. |
User 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 Maria Database server. To know how to create such a user, refer to Configuring the eG Agent with Access Privileges |
Confirm Password |
Confirm the password by retyping it here. |
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Total threads |
Indicates the total number of threads that are currently running on the database server. |
Number |
|
Background threads |
Indicates the number of background threads i.e., internal server threads that are currently executing on the database server. |
Number |
|
Foreground threads |
Indicates the number of foreground threads i.e., user connection threads that are currently executing on the database server. |
Number |
|
Killing threads |
Indicates the number of threads that kill other threads executing on the database server. |
Number |
|
Error threads |
Indicates the number of threads that are error prone on the database server. |
Number |
|
Delayed insert threads |
Indicates the number of threads that inserts the results of the INSERT DELAYED statements. |
Number |
|
Retrieve longdata thread |
Indicates the number of threads that retrieve long data while executing prepared statements on the database server. |
Number |
|
Maximum duration thread |
Indicates the maximum time taken for a thread to execute on the database server. |
Seconds |
|