Home » Categories » Products » Nagios XI » Documentation » Architecture

Nagios XI DB - Maintenance Architecture

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.


Architecture Components And Execution Flow

The general flow of execution of the Event Manager subsystem works as follows:

  1. A user defines the amount of time they would like to keep certain types of data in Admin -> Performance Settings -> Database tab

  2. 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)

  3. 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

  4. The dbmaint.php script truncates entries from tables that are older than the time specified in 

  5. The dbmaint.php script updates the last run time in the xi_meta table of the nagiosxi database


Troubleshooting Problems

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:

  • There may be a problem with the cron job.  Check the cron file /etc/cron.d/nagiosxi to ensure the job is not commented out.
  • Check the /usr/local/nagiosxi/var/dbmaint.log log file for errors
  • The nagios user account is expired causing the cron to not run


Final Thoughts

For any support related questions please visit the Nagios Support Forums at:


0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Nagios XI - Introduction: Getting Started with Nagios XI - NWC14
Viewed 1549 times since Thu, Feb 4, 2016
Nagios XI - Switch and Router Wizard Architecture
Viewed 2747 times since Fri, Feb 6, 2015
Nagios XI - Under the Hood - NWC15
Viewed 1228 times since Thu, Feb 4, 2016
Nagios XI - Terminology Overview
Viewed 1320 times since Sun, Feb 8, 2015
Nagios XI - How XI Works
Viewed 1874 times since Wed, Jul 19, 2017
Nagios XI - Cron Jobs
Viewed 2824 times since Thu, Feb 5, 2015
Nagios XI - High Availability and Failover Solutions for Nagios XI - NWC14
Viewed 2676 times since Thu, Feb 4, 2016
Nagios XI - Web Interface Architecture
Viewed 2101 times since Wed, Jan 28, 2015
Nagios XI - Event Manager Architecture
Viewed 1697 times since Sun, Feb 8, 2015
Nagios XI - Monitoring Using the Full Power of Nagios XI Enterprise - NWC15
Viewed 2354 times since Mon, Feb 8, 2016