Table icinga_servicechecks about 500 GB

Icinga 2
1

Good morning,

Enviroment:
Icingaweb2 2.7.3
Icinga2 r2.11.3-1
MariaDB 10.1.44
Debiamn 4.9.0-12-amd64 #1 SMP Debian 4.9.210-1 (2020-01-20) x86_64 GNU/Linux

the db table icinga_servicechecks had about 500 GB and I read somewhere, this table should not be filled. I looked around and i do not find the point to disable it as we store our performance data in grafana.
Any help would be nice.

Kind regards
Peer-Mario

2

You need to modify the categories section in your idomyqlconnection. All details can be found here.

3

This is what my config looks like:

object IdoMysqlConnection “ido-mysql” {
user = “icinga2”,
password = “xxx”,
host = “localhost”,
database = “xxx”
}

4

My definition looks the same but I have additionally

library “db_ido_mysql”

in it. Maybe you’ll give it a try.

1 Like
5

@rsx i hope you mean cleanup and not categories.
Cleanup helps only to see a defined timeframe of the tables in the cleanup items. You should run a cronjob regulary that optimze your tables, for details read the docs.

6

@anon66228339 I meant categories as Thomas described DbCatCheck as the culprit here.

7

@rsx I gave it a try and it wrks like expected, thank you.