ZABBIX Forums  
  #1  
Old 03-12-2017, 03:00
Twenty_eight Twenty_eight is offline
Junior Member
 
Join Date: Dec 2017
Posts: 2
Default 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 at 12:35.
Reply With Quote
  #2  
Old 06-12-2017, 03:39
Twenty_eight Twenty_eight is offline
Junior Member
 
Join Date: Dec 2017
Posts: 2
Default Bump!

"Truth is out there."
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 04:22.