Page 1 of 1

system_log

Posted: Thu Jul 26, 2018 11:05 am
by pribis
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?

Thanks.

Current: 10.6.2
To: 11.0.2
OS: Ubuntu 16.04

Re: system_log

Posted: Thu Jul 26, 2018 11:47 am
by mikeb
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.

Re: system_log

Posted: Fri Jul 27, 2018 5:37 am
by pribis
Sigh, ok. Starting to really loath MySQL. It took 1hr and 12min to complete :) But at least it completed.