Skip to content

Zabbix: Mass update items update interval

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.


No Trackbacks


Display comments as Linear | Threaded

No comments

The author does not allow comments to this entry

Add Comment

E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.

Markdown format allowed
Form options