Proxy and HouseKeeper

[mcmyst]

Hi,

I would like to know how proxy is working when it retrieves data from the network.
Where are these data stored ? In trends and history like on the server ?
What is the normal process ? Retrieve, store locally, push to server and then what happens ? Delete row or wait until housekeeper runs ?

It looks like housekeeper is useful because it is deleting over 1 700 000 rows every hours, but the size of history is only 8.5 KB on my database....

  1508:20130528:113054.738 housekeeper deleted 1742010 records from history (spent 41.667653 seconds)
  1508:20130528:123013.400 executing housekeeper
  1508:20130528:123100.178 housekeeper deleted 1741163 records from history (spent 46.605845 seconds)
  1508:20130528:133013.765 executing housekeeper
  1508:20130528:133054.068 housekeeper deleted 1740463 records from

[neogan]

Hi,

I would like to know how proxy is working when it retrieves data from the network.
Where are these data stored ?

Data stored in the zabbix proxy database.

In trends and history like on the server ?

As far as I know only history.

What is the normal process ? Retrieve, store locally, push to server and then what happens ?

Push to server it it reacheble or stored localy time defined by option ProxyOfflineBuffer in zabbix_proxy.conf

Delete row or wait until housekeeper runs ?

It wait housekeeper.

[mcmyst]

So when I here people saying "Zabbix proxy don't need strong hardware spec" it is not really true if you have big NVPS.

So when we talk about partitioning server database, we also could do that on proxy side in order to be able to disable housekeeping.