system_log

Ask your questions regarding TimeTrex installation here.
Post Reply
pribis
Posts: 86
Joined: Mon Apr 19, 2010 10:33 am

system_log

Post by pribis » 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?

Thanks.

Current: 10.6.2
To: 11.0.2
OS: Ubuntu 16.04

mikeb
Posts: 541
Joined: Thu Jul 27, 2006 11:58 am

Re: system_log

Post by mikeb » 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.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!

pribis
Posts: 86
Joined: Mon Apr 19, 2010 10:33 am

Re: system_log

Post by pribis » 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.

Post Reply