Thanks for the data.
Your system is keeping a lot of extra polled_data which in turn keeps extra polled_extra data so a new component was created to remove the older data that is not needed anymore.
To be safe, make a snapshot of the server in case you need to revert.
Attached to this post is a zip file called trimpolled.zip.
Save it to your desktop and go to the Admin > Manage Components menu in Fusion, browse to it and Upload it to the server.
Let the system run for 10 minutes and run the following as root.
Code: Select all
/usr/local/nagiosfusion/cron/dbmaint_subsys.php
This should automatically truncate and optimize the tables in the MYSQL database which should shrink them further.
Then, once a week, it will optimize the data when the script is ran so you will see the database increase a bit for a week then shrink again.
Let us know if it works and how much it shrinks the database.
You do not have the required permissions to view the files attached to this post.