Database growth rate (aggregated)


Job details

Name: Database growth rate (aggregated)
Platform: Mariadb
Category: Capacity
Description: Collects database size and visualizes the growth rate of the server.
Long description: Collects database size and visualizes the growth rate of the database server (aggregated).
Version: 2.2
Default schedule: 15 5,17 * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & is_mariadb_branch=‘1′]/.[hasengine=‘YES’]

Parameters

Name Default value Description

Job Summary

Job Details

Job Configuration

Dependencies and Cleanup

Implementation

The job involves the creation of a table to store data size, index size, and history date. The size data is aggregated from the MariaDB “information_schema.tables”, and these data points are inserted into the history table. Thereafter, task execution details including total size are updated.

Reporting

SQL Query Summary (Report Generation)

The SQL query used for generating the report pulls and rounds off the size data from the “dbw_db_size_histr_aggr” table, classifying it into ‘Data size’, ‘Index size’, and ‘Total size’. The results are then represented in a categorical chart with dates on the x-axis and size types as series.

Variable Query Description
Size (MB) Extracts and converts the storage size from bytes to megabytes.
Aggregation Type Differentiates between data size, index size, and total size.
History Date Dates on which the respective sizes were logged.

Conclusion

This dbWatch Control Center monitoring job provides crucial visibility into the growth trends of MariaDB databases, which is essential for effective database and capacity management.