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/remote agent

Outputs of the test : One set of results for each tablespace managed by the monitored MySQL database server instance

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

Status

Indicates the current status of this tablespace.

 

The values reported by this measure and its numeric equivalents are mentioned in the table below:

Measure Value Numeric Value
Corrupted 0
Discarded 1
Empty 2
Inactive 3
Active 4
Normal 5

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.