I inherited a Zabbix installation. I can see that the PostgreSQL database behind it has been partitioned, likely using the instructions from this website: https://www.zabbix.org/wiki/Docs/how...topartitioning.
I'm still seeing a lot of slow queries (slow queries are those over 3000 milliseconds) that look like the form: "select value from history_uint where itemid=51354 and clock<=1395812454". So, I'm a little confused because I thought my queries would now reference the partitions, like partitions.history_uint_p2014_03_04 instead. My history_syncer process has been spiking for the last two weeks or so, but the history write cache stays around 99% free. I believe it started after I added a bunch of snmp checks for some network devices. I have since removed them, but the saga continues. My queue is ~1500 items behind for Zabbix agents.
My questions are:
1) What exactly does the history syncer process do?
2) If the tables were partitioned after an initial deployment, is it possible that Zabbix is trying to grab data that is not partitioned (i.e. from the main history_uint table)? Should I/could I just delete this data then?
Thanks in advance.
I'm still seeing a lot of slow queries (slow queries are those over 3000 milliseconds) that look like the form: "select value from history_uint where itemid=51354 and clock<=1395812454". So, I'm a little confused because I thought my queries would now reference the partitions, like partitions.history_uint_p2014_03_04 instead. My history_syncer process has been spiking for the last two weeks or so, but the history write cache stays around 99% free. I believe it started after I added a bunch of snmp checks for some network devices. I have since removed them, but the saga continues. My queue is ~1500 items behind for Zabbix agents.
My questions are:
1) What exactly does the history syncer process do?
2) If the tables were partitioned after an initial deployment, is it possible that Zabbix is trying to grab data that is not partitioned (i.e. from the main history_uint table)? Should I/could I just delete this data then?
Thanks in advance.
Attached Files