xi_meta.MYD so big

[safuanmansor]

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?

[benjaminsmith]

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

[safuanmansor]

Thanks benjaminsmith for the clarification

[scottwilkerson]

Thanks benjaminsmith for the clarification

Great!

Locking thread