Maria Files Test

This test monitors the internal files created on the target database server and reports the number of internal files created on the database and the maximum number of files that can be created on the server. Using this test, administrators can also determine the percentage of files created on the database server.

Target of the test : A Maria Database server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for the Maria Database server being monitored

Configurable parameters for the test

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 section.
Confirm Password	Confirm the password by retyping it here.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Files opened	Indicates the total number of internal files that are currently created on the database server.	Number	If the value of this measure is close to the Maximum File Limit measure, then, administrators should try increasing the Maximum File Limit measure.
Maximum file limit	Indicates the maximum number of file instances that can be created on the database server by default.	Number
File usage	Indicates the percentage of files that are currently created on the database server.	Percentage	A value close to 100 indicates that the maximum limit for creating the files on the database server has been reached. To reduce this value, it is necessary to increase the Maximum File Limit measure of the database server.