History tables Explanation

[navtek007]

Hi All,

I was wondering what the differece is for all the history tables.

history_uint - table that stores all integer values

history_log - table that stores all log values

history_text - table that store all text values

history_str - table that stores all string values

history - Not quite sure if this table is still needed as i thought that all the history would be stored in their relative data type tables? Is this a legacy table or something or is data stored in history_%type% and then after a time period get sent to the history table?

I'm trying to create some reports so I would like to really know how the data is stored and where it is stored.

Thanks.

[Alexei]

history - table that stores all float values

[navtek007]

thanks for the quick reply. so for reporting, would it be wise to report against the trands table instead of the history table as my history table has about 270 million rows? I am just trying to do a cleanup of the history table now as this amount of rows seems to be too excessive.

If i truncate the history table what kind of data will i loose. Will all my graphs > 1 hour just be hourly averages or will it come up as no data? What are the risks in doing this?

Just so i understand the trends table contains hourly averages of float and integer values or just integer values?

Thanks.

[dratliff]

This is sort of a petty complaint because everyone here knows what the table is about but it makes me insane..

Please fix the history_uint table in the next release to be history_unit.


like nails on a blackboard...sorry.

[Alexei]

so for reporting, would it be wise to report against the trands table instead of the history table as my history table has about 270 million rows?

What?! It is already wise! ZABBIX takes data from trends for all graphing with period longer than 24 hours.

[sticks221]

This is sort of a petty complaint because everyone here knows what the table is about but it makes me insane..

Please fix the history_uint table in the next release to be history_unit.


like nails on a blackboard...sorry.

The tables are names correctly - they store uint values which is the well known data type for "unsigned integers" - aka whole values, nothing to do with units