upgrade 1.8 to 2.0: The Need for Speed

[Calypso]

I'm wondering if anyone has tested the updated script in ZBX-5359..

https://support.zabbix.com/browse/ZBX-5359

and if there was a definite speed improvement. Thanks!

Tested it today on my events table that has 8.5 million records in it. Machine: Dual E5504 CPU/96 G memory/Percona MySQL 5.5.

Old patch: ran it for 24 hours and it was still stuck on the first query
New patch: converted within one minute...

This was for the part that patches the events table - I usually break up the database patch in parts for every table and run those individually.

That way I'm not forced to reload my whole database and rerun the whole patch in case of a problem ;-)