Zabbix history syncer problem

[perun.84]

I have problem with my zabbix installation. I have one zabbix server and two proxies. One of proxies has a 600 network devices. I have a problem with stop drawing graphs. Everyday at noon history syncer on zabbix server jumps to 100% and all of graphs don't draw any data. It takes few hours and then everything is going to be ok. There are no gaps in graphs and similar.. My database server is on separate server.

What can be the problem?

On picture you can see situation.

[kloczek]

Your DB backend is chocking because DB housekeepieng is generating to much IOs.
Switching to partitioned history* and trends* tables and disable housekeeping on these tables should solve your issues.

[perun.84]

Thanks for reply. I already partitioned tables. Also in server config is: HousekeepingFrequency=0. I think that housekeeper doesn't start on my server. But I don't know may I disable history syncer and how...

[kloczek]

No. You still need to have enabled HK to maintain audit and events tables.
You must disable history and trends housekeeping over web interface (Administration-General->Housekeeping).

[perun.84]

It's already disabled. On that page only "Override item history period" under History and trends adre checked and for time are written 28 and 730...