DB Maintenance Overview
This DB Maintenance cron job of Nagios XI is responsible for optimizing and truncating database tables based on the user defined settings located in Admin -> Performance Settings -> Database Tab.
The general flow of execution of the Event Manager subsystem works as follows:
A user defines the amount of time they would like to keep certain types of data in Admin -> Performance Settings -> Database tab
The settings are saved in the xi_options table of the nagiosxi mysql database (mariadb on cent/rhel 7 and postgresql on XI versions less than 5)
The dbmaint.php script runs as a background process and grabs the settings from xi_options. The dbmaint.php script is located at /usr/local/nagiosxi/cron/dbmaint.php and runs under cron every 5 minutes. The cron job is defined in /etc/cron.d/nagiosxi
The dbmaint.php script truncates entries from tables that are older than the time specified in
The dbmaint.php script updates the last run time in the xi_meta table of the nagiosxi database
Some potential problems with the Event Manager subsystem, as well as troubleshooting information are listed below:
Problem: Admin -> System Status displays a red X next to Database Maintenance
Potential Causes:
For any support related questions please visit the Nagios Support Forums at:
http://support.nagios.com/forum/
Article ID: 70
Created On: Sun, Feb 8, 2015 at 11:59 AM
Last Updated On: Wed, Feb 17, 2016 at 10:37 PM
Authored by: swilkerson
Online URL: https://support.nagios.com/kb/article/nagios-xi-db-maintenance-architecture-70.html