I’m working on a plugin for WordPress, currently it is totally work-in-progress.
The idea is to:
- monitor database growth;
- map and monitor the content-type(s) in wp_posts, more-or-less the output of the following query:
- map and monitor the meta_key(s) in wp_postmeta, more-or-less the output of the following query:
The repository is on GitHub: https://github.com/canepa/db-profiler
The trick is measuring the data once a day and identifying and troubleshooting database growth anomalies.