xi_meta.MYD

[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

[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'