Database growth rate (aggregated)
Job details
Name: | Database growth rate (aggregated) |
Platform: | Mysql |
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_mysql_branch=‘1′]/.[hasengine=‘YES’] |
Parameters
Name | Default value | Description |
---|
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:
Attribute | Description |
Name | Database growth rate (aggregated) |
Company | dbwatch.com |
Scheduled time | At 5:15 and 17:15 every day |
Category | Capacity |
Type | MySQL |
Version | 2.2 |