artodeto's blog about coding, politics and the world

The issue was, that we've just added more and more systems and with that items to our zabbix monitoring solution.

The housekeeping process was getting slower and slower so we reasked our self "do we need that kind of accuracy"? Well, for the most parts, we figured out a bit "No". What was left was a handfull of critical sytems.

Instead of checking each host and item, we just noted the critical systems. This list represents the hosts we want to check individually. All otheres where "aligned" with one big mass updated.

We will use pure sql here, either via command line, adminer or what ever you like.

What do you need to know? Inside your database zabbix, there is a table called items. Each item has the column delay which represents the update interval.

After knowing this, we just need to know one more thing. What kind of update intervals do we have.

You fetch this information via the following sql statement.

SELECT `delay` FROM `items` GROUP BY `delay`;

After that, you only have to update each fitting item. For example, if you want to raise the delay from 1 minute to 5 minute just execute the following command.

UPDATE `items` SET `delay` = '5m' WHERE `delay` = '1m'

And that's it.