The new Database Growth Monitor plots your database and external data source growth on a chart and allows you to review database growth for a specified period. In this post, I’ll cover all the configuration you need to get started.
To enable growth monitoring on the System Database, we will need to specify the System Database name:
- Visit the System Config module.
- Search for the config key ‘SystemSettings:SystemDatabaseName‘.
- Edit the config value and specify the name of the System Database.
If you have any external data sources configured, we can also enable daily growth monitoring on these databases. There are a few rules that apply to this. Currently, growth monitoring is only available on MySQL databases. The data source needs to use the com.mysql.jdbc.Driver to activate growth monitoring.
- Visit the Data Source Admin module.
- Select an existing data source and click ‘Edit Details’.
- Near the bottom, enable database growth monitoring and specify the name of the database to be monitored. This name has to match the one specified in the connection URL.
Finally, all that’s left to do is enable the daily task that will begin capturing the data.
- Visit the Task Management module.
- Open up the Database Growth Monitor task (ID 3889).
- Click ‘Edit Task’ and activate the task status.
With all that out of the way, you’re ready to sit back and let your data grow! To view the captured data:
- Visit the Database Growth Monitor module.
- The table at the bottom lists the data sources that are configured for growth monitoring. Check the display box to add the source to the graph.
- The date range picker will allow you to select a period for which you would like to review data growth. Simply select a starting and ending date and click ‘Apply Date Range’.
- Hover over data points in the graph to get extra details such as the data source name, the database size in MB and the time of capture.
Please Note: The growth monitor will only begin gathering data one it has been activated, i. e. you can’t report retrospectively.
Well that’s about it. We hope you enjoyed the post and make good use of the new feature. Thanks!