There is a problem with the history table. It allows for three ways to store the value.
As Is, Delta, Delta Per Sec. But these should be in the show value fields.
The ideal would be to store the value as is in most cases. I man not saying to remove the delta types, but if I want the delta per sec, I show as delta per sec.
The problem came up in that we need to determine some totals over a 24 hour period. This was packet count over a 24 hour period. but the database recorded it as delta/sec. So when we looked in the tables, there was no way to retrieve the values we reported.
On solution would be to add another row that is strictly the "AS IS" data.
If we stored "AS IS", then we couldn't display the values correctly. If we start to do more extensive graphing then we would need the "AS IS" data to develop the relationships to other metrics.
Lets say we want to develop the same type of heat graphs for a systems as they do on the NYSE for tracking the exchange. We need the "AS IS" to do this, but if we want to see the individual graphs within the zabbix web server, they need to be displayed as deltas, or deltas per second.
This should be rethought.
As Is, Delta, Delta Per Sec. But these should be in the show value fields.
The ideal would be to store the value as is in most cases. I man not saying to remove the delta types, but if I want the delta per sec, I show as delta per sec.
The problem came up in that we need to determine some totals over a 24 hour period. This was packet count over a 24 hour period. but the database recorded it as delta/sec. So when we looked in the tables, there was no way to retrieve the values we reported.
On solution would be to add another row that is strictly the "AS IS" data.
If we stored "AS IS", then we couldn't display the values correctly. If we start to do more extensive graphing then we would need the "AS IS" data to develop the relationships to other metrics.
Lets say we want to develop the same type of heat graphs for a systems as they do on the NYSE for tracking the exchange. We need the "AS IS" to do this, but if we want to see the individual graphs within the zabbix web server, they need to be displayed as deltas, or deltas per second.
This should be rethought.
Comment