Database growth rate (aggregated)

Job details

Parameters

Job Summary

• Purpose: The purpose of this job is to monitor and visualize the growth rate of the MySQL instances’ databases, focusing on their data size, index size, and transaction size.
• Why: This job is essential as it enables users to measure the utilization of their databases over time via the aggregation of data size, index size, and transaction size changes – prompting preventative measures when a significant growth rate is identified that might risk outstripping available resources.
• Manual checking: Users can manually check the database growth through these SQL commands:

SELECT ROUND(data_size / 1024/1024, 1) AS size, 'Data size' as "Aggregation type",histr_date "History date" FROM dbw_db_size_histr_aggr UNION SELECT ROUND(index_size / 1024/1024, 1) AS size,'Index size' as "Aggregation type",histr_date "History date" FROM dbw_db_size_histr_aggr UNION SELECT ROUND((index_size+data_size) / 1024/1024, 1) AS size,'Total size' as "Aggregation type",histr_date "History date" FROM dbw_db_size_histr_aggr;

Dependencies

The job has dependencies on two objects:

• database_growth_rate_aggr: This task is dependent on itself.
• dbw_db_size_histr_aggr: This table is required for the task.

Cleanup Codes

In case of task failure, these codes will be used for cleanup:

DROP TABLE dbw_db_size_histr_aggr;

DROP PROCEDURE database_growth_rate_aggr;

Database Growth Report

The Database growth rate (aggregated) report provides a visual representation of data size, index size and total size, over time. The report’s content is derived from the dbw_db_size_histr_aggr table, showing details in Megabytes (MB) and dates.

Notifications

If the job fails to execute, an alert will be sent out identifying the cause, allowing users to rectify the issue in a timely manner.

Installation

This job is configured to use express installation, enabling a quick and easy set-up process.

Job Attributes

The key metadata for this job: