No announcement yet.

Manually run history sync to build trends

  • Filter
  • Time
  • Show
Clear All
new posts

    Manually run history sync to build trends

    Hi to all!

    Is it possible to run, easier as it possible, rebuild trends tables from exist history tables?

    My case, in short, is like that:

    Got disaster in original Zabbix-server storage ->
    Restored Zabbix-server to very slow storage ->
    Start to get every hour messages about "Zabbix-agent not available on host {HOST_NAME}" ->
    Find that getting gaps in history (that why triggers is trigged) every hour ->
    Find that problem is with DB speed on currents storage originally because having 1 file(ibdata1, size ~100GB) for the whole DB (legacy) ->
    Start to kill history sync process that locks DB with disabling housekeep for keeping history ->
    Now solved the problem with the storage(faster storage but lower than before) need to fill gaps in trends by using existing data from history.

    After that will dump-restore database to mode "own file for single table"

    My Zabbix is:
    zabbix_server (Zabbix) 3.0.13
    Revision 74336 7 November 2017, compilation time: Nov 23 2017 16:56:31

    Used forum search before if duplicating, please give a link to the solution.
    Last edited by Twenty_eight; 05-12-2017, 12:35.


    "Truth is out there."