Any limit to Database Table in Nagios XI

[Gonela]

Hi Team,

Generally all event logs will store nagios_logentries table. Our table is increasing gradually day by day. The current Size of the database table is mentioned in screenshot. My question is as below.

1) Is there any limit on Size for database tables. (EX: table should not reach 20GB or 10 Miliaons of record in NagiosXI)
2) Is there any cut off or restrictions for database table.

Can you help on these questions.

[scottwilkerson]

There is no limit other than disk space on the XI server.

This table is pruned based on the setting in Admin -> Performance Settings -> Databases Tab -> Max Log Entries Age:

[Gonela]

If we apply new configuration . How much time it will take to reflect.

[scottwilkerson]

If we apply new configuration . How much time it will take to reflect.

It really depends on how many hots /services you have and how fast your disks can process the writes to the database.

this can run from a second, to several minutes win over 10,000 checks

[Gonela]

Hi Team,

Thanks for the reply.

Can you tell me if you make changes log_entries age is 10 days. What will be the impact.

Is there any impact availability report ?
is there any impact on notification report ?
any state history report will impact.

Do we loss any important data will loss in terms of any host details missing ....etc.

[scottwilkerson]

If you change the log entries table to only keep 10 days it would really only impact the Event Log report, you would not be able to loob back further than 10 days.

All other Reports use different methods to get their values