Page 1 of 1
Posted: Thu Jul 26, 2018 11:05 am
I'm converting our mysql install to postgres. As part of the process we are upgrading from 10.6.2 to 11.0.2. The upgrade is taking a looooong time (like working on forty minutes now). The longest part is the upgrade of the system_log table. It has over 2.5 million records. Can we truncate this to speed things up?
OS: Ubuntu 16.04
Posted: Thu Jul 26, 2018 11:47 am
Unfortunately in some cases MySQL can take an extremely long time to upgrade to v11.0 due to how it handles table schema changes (one of the reasons why we don't support it anymore). If you were to stop it now the database would be corrupt and you would have to restore the entire database from a backup and start it over again (another reason why we don't support it anymore), which would likely take even longer.
I would recommend just waiting it out if possible.
Posted: Fri Jul 27, 2018 5:37 am
Sigh, ok. Starting to really loath MySQL. It took 1hr and 12min to complete
But at least it completed.