PDA

View Full Version : Insert values only on change


RealEnder
27-12-2005, 11:15
Helo,
Is it possible to store only changed data in the database?
For example, when monitoring the state of windows service most time it is running and we want to know only if it is changed and when. This will greatly reduse database inserts (yes, for sure zabbix_server will have to update the date of last chack) and will make possible to monitor such events on lower intervals.

Alexei
27-12-2005, 11:43
You may want to set housekeeping parameters for the item to zero days. ZABBIX won't store new values in the history in this case.

RealEnder
27-12-2005, 11:49
Infact, we still need the old data - to what state went the service and when.
This can be acomplished only when some triger is fired, but it is not nessesary to have one attached to the item.

Alexei
27-12-2005, 11:54
Trigger status change data is something different. It has nothing to do with item's housekeeping parameters and configured separately.

Even if there is nothing in history, trigger status changes are available for reporting purposes from table 'alarms'.