Nagios Support Forum

Posted: **Wed Feb 05, 2020 9:19 pm**

Hi Nagios support.

We have a situation where 1 of our nagios server (NagiosXI A) the disk for /var/lib/mysql are full hense the db is stop and cannot start.
the size of xi_meta.MYD are so big compare to other DB

unnamed.png

db file size.png

Upon checking i found this thread that suggest to truncate the db.

https://support.nagios.com/forum/viewto ... =6&t=46220

I have another system (NagiosXI B) that monitor 1400 host with 15000 services.
The nagiosxi database (NagiosXI B) are way too small compare to nagiosxi (NagiosXI A)

What actually stored in this nagiosxi database and if i were to truncate the database. what will i be missing?

Posted: **Thu Feb 06, 2020 4:27 pm**

Hello,

The xi_meta table is an intermediate table that Nagios temporarily uses when it is running so it should be cleaned out automatically and not get very large over time.

It should normally be optimized during the database maintenance jobs, so make sure all of the components are running green. Go to Admin > System Information > System Status to check.

Normally, we truncate the events, meta and eventqueue tables to resolve. You can run the following command to do this.

Code: Select all

echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | mysql -u root -pnagiosxi nagiosxi

Posted: **Sat Feb 08, 2020 11:14 am**

Thanks benjaminsmith for the clarification

Posted: **Mon Feb 10, 2020 8:14 am**

safuanmansor wrote:Thanks benjaminsmith for the clarification

Great!

Locking thread

Nagios Support Forum

xi_meta.MYD so big

xi_meta.MYD so big

Re: xi_meta.MYD so big

Re: xi_meta.MYD so big

Re: xi_meta.MYD so big