IDO database apply retention policy to an entire database

Icinga 2 Icinga DB
, , ,
1

ido-mysql feature has an attribute cleanup where you can specify table names to set retention policy. How would you apply to the entire database without writing down every table name?

2

Hello,

you dont have to write down every table, only the ones listed under cleanup items in the docs.

Regards,
Carsten

3

So the other tables in an Icinga database don’t accumulate data?

4

By the way, is it just because you want to enable it or do you have problems with you ido or ido size?
What i can recommend to run the ido tunings via cronjob once a week.

Regards,
Carsten

5

I don’t have problems with IDO database size, I just wondered if there’s a built mechanism in Icinga to set retention policy.
Thanks.

EDIT: is the proper way to use cleanup attribute the table name needs to be appended with “_age”, .e.g. tableName_age = 30d ?

6

Hey :slight_smile:

In this list of cleanup items for IdoMySqlConnection you can find the list of cleanup items.

I don’t know about a proper way to use the cleanup attributes, I would’ve tried using placeholders for keeping my configuration short though.

1 Like