XI_meta file growing in size

[karthek]

Hi,

xi_meta.MYD file is constantly growing in size, crashing our XI server.

we have truncated the XI_meta table and it got cleaned up. But, again in no time it started growing in size.

XI server has less than 10 hosts and 300 services.
Other XI that has 70K+ services works just fine with 9MB of xi_meta file.

We have tried repairing the DB, running the dbmaint.php script but no use. Everything completes just fine but doesn't fix the issue.

Please share your thoughts.

[dwasswa]

Hi @karthek,

Please PM your profile by following the steps below:

Go to Admin >> System Profile >> Download Profile

Download_system_profile.PNG

PM the profile after downloading it.

Please open /etc/cron.d/nagiosxi and make sure the cron job */5 * * * * nagios /usr/bin/php -q /usr/local/nagiosxi/cron/dbmaint.php >> /usr/ local/nagiosxi/var/dbmaint.log 2>&1 is not commented out.

Please attach a copy of dbmaint.log log file located at /usr/local/nagiosxi/var.

Here is also a kb article on how you can optimize your database to prevent issues in the future...Nagios-XI-Database-Optimization

[karthek]

we have fixed this issue by truncating the xi_eventqueue table.

For some reason the data in that table was not getting auto deleted, even though the eventhandler.php was running.

[dwasswa]

Hi @karthek,

Good to know that your issue was resolved.

In regards to:

For some reason the data in that table was not getting auto-deleted, even though the eventhandler.php was running

It is likely that the table could have had a bad entry that prevented it from being truncated; so you had to do it manually.

Thank you for using the Nagios Support Forum. We will now close this thread as resolved.

If you have any questions, please open a new thread.