Historical values and graphs

[dratliff]

Hello,

I have historical data that I dumped into the history table properly formatted and a proper item id. The data is physically there. I can query it in mysql. I can also display the values for over 6 months in zabbix. When I try to graph the values, they do not display results for beyond 3 days and 8 hours. I clearly have values from over 6 months.

My question is this: If you manually insert data into the history table using a valid itemid, properly formatted clock value and a proper value, is there another table that needs to be updated or inserted additionally?

I have set the retention values for the item to very high numbers (2000) so that it will not remove the data for 2000 days. Is this a problem?

[swaterhouse]

Alexei can confirm but I am pretty sure the default behavior is that graphs use data from the history table for the previous 24 hours and any data older than 24 hours it uses the trends table.

[dratliff]

Thank you, that looks like my issue.

I think I can figure out how this data is formatted, the only questionable field is num. Is that the field that sort of series number for the date?

Here is another question: Does the packet that gets sent to zabbix have an xml tag for timestamp? The code looks as if it can support it. Does it work like I think it works by putting in your own value for a date (assuming a long unix_timestamp). That would make things easier for putting in my timestamp from when the row was written in the source database instead of when it was written in the zabbix database.

Thanks for the help.

Dave

[Alexei]

Alexei can confirm but I am pretty sure the default behavior is that graphs use data from the history table for the previous 24 hours and any data older than 24 hours it uses the trends table.

You are absolutely right!

[fizz]

Hi,
I also need to manually insert history data as I'm migrating to Zabbix from rrdtool, could you please explain whats the num field in the trends table?

Thanks,
--fizz

[Alexei]

Hi,
I also need to manually insert history data as I'm migrating to Zabbix from rrdtool, could you please explain whats the num field in the trends table?

Thanks,
--fizz

The num is a number of values within specific time period (one hour). I think it is not used currently by ZABBIX, perhaps will be used later.

[fizz]

Thanks a lot Alexei!