MySQL Tablespaces Test
Tablespaces should be adequately sized. If not, then the tablespaces may frequently run very low on free space, causing all statements that attempt to acquire new space in the tablespace to fail. This in turn will result in serious performance issues ranging from slowdowns to shutdowns. Continuous monitoring of tablespace size and usage is hence important.
The MySQL Tablespaces test auto-discovers the tablespaces managed by the target MySQL database server, and reports how well each tablespace is utilized. Using this test, you will be able to instantly identify the tablespace left with very little free space.
Target of the test : A MySQL server
Agent deploying the test : An internal
Outputs of the test : One set of results for each tablespace managed by the monitored MySQL database server instance
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 |
Confirm Password |
Confirm the password by retyping it here. |
Measurement | Description | Measurement Unit | Interpretation | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Status |
Indicates the current status of this tablespace. |
|
The values reported by this measure and its numeric equivalents are mentioned in the table below:
Note: By default, this measure reports the Measure Values listed in the table above to indicate the current status of each tablespace. The graph of this measure however, is represented using the numeric equivalents only i.e., 0 to 5. |
||||||||||||||
Allocated size |
Indicates the current allocated size of this tablespace. |
MB |
If a tablespace is not auto-extensible, then its Allocated size will be equal to the Max size. For auto-extensible tablespaces though, the values of the Allocated size and Max size measures could be different. |
||||||||||||||
Used size |
Indicates the size up to which this tablespace has been utilized. |
MB |
If this value is very high, it indicates that the tablespace memory is almost full. |
||||||||||||||
Max size |
Indicates the maximum extent up to which this tablespace can grow. |
MB |
|
||||||||||||||
Free size |
Indicates the amount of unused space available in this tablespace. |
MB |
If this value is very low, then it indicates over-utilization of the tablespace. |
||||||||||||||
Free percentage |
Indicates the space available for overall growth expressed as a ratio of Free size with respect to the Maximum size of the tablespace. |
Percent |
If this value is very low, then it indicates over-utilization of the tablespace. Also, if the value of this measure is below 80%, then sufficient space must be allocated to the tablespace. |