Page 1 of 1

xi_meta.MYD

Posted: Thu Nov 02, 2017 1:01 pm
by jorgeaaq
Hi:

i have a system with around 9,000 hosts and 11,000 monitors

right now i found a file xi_meta.MYD with 88Gb of size

is this normal?

what is stored in this table?

how can I debug this table or reduce his size?

thanks in Advance

Jorge Arenas

Re: xi_meta.MYD

Posted: Thu Nov 02, 2017 2:18 pm
by dwhitfield
That particular table, of that size, I would suggest truncating the table.

Code: Select all

mysql -u ndoutils -pn@gweb nagiosxi -e 'TRUNCATE TABLE xi_meta'