hello,
we have cloned our prod zabbix env to a test env and currently running the upgrade from 2.0.6 to 2.2.0.
What I can see in the logs is that zabbix db upgrade process is currently on 16% and on mysql I see fellowing DML running since 1,5 hours
Question:
we have a distributed zabbix setup with following count of rows for the events table:
zabbix master: 119million (34GB)
zabbix node: 439million (574GB)
Is it possible to run that "delete from events" dml before the update to shorten the time of the upgrade process?
we have cloned our prod zabbix env to a test env and currently running the upgrade from 2.0.6 to 2.2.0.
What I can see in the logs is that zabbix db upgrade process is currently on 16% and on mysql I see fellowing DML running since 1,5 hours
Code:
17761:20131205:151632.627 completed 12% of database upgrade 17761:20131205:151632.767 completed 13% of database upgrade 17761:20131205:151633.012 completed 14% of database upgrade 17761:20131205:151633.020 completed 15% of database upgrade 17761:20131205:151633.066 completed 16% of database upgrade
Code:
delete from events where source=0 and object=0 and (value=2 or value_changed=0)
Question:
we have a distributed zabbix setup with following count of rows for the events table:
zabbix master: 119million (34GB)
zabbix node: 439million (574GB)
Is it possible to run that "delete from events" dml before the update to shorten the time of the upgrade process?