Issue with zabbix history table

[akbar415]

As doc's https://www.zabbix.com/documentation...ory_and_trends say history must keep at last n days of each collected data

I have been trying to use a mysql query to get an specific data but it's gathering less than a month of data. Something like 33000 rows. This is th e query:

SELECT * /* h.itemid, from_unixtime(h.clock), h.value */

from history_uint h Join items i ON h.itemid = i.itemid 

where h.itemid = 43390

order by h.clock ASC;

In my zabbix config I have this:



But the in query result the oldest data is from 21 November



But using API I can get the data fine from 4 months.

PS: 1479736538 = Mon, 21 Nov 2016 13:55:38 GMT