topic Re: Upgrading from 1.2.1 to 1.3 in Alfresco Archive

Upgrading from 1.2.1 to 1.3

onlaed — Mon, 03 Jul 2006 10:40:06 GMT

I currrent have approx 30GB of data in my alfresco repository. The MySQL data len is approx 140MB and the Index Length is approx 100MBWhy does does the migration takingso long? So far over 32 hours?

Re: Upgrading from 1.2.1 to 1.3

cludt — Wed, 12 Jul 2006 10:17:28 GMT

If you have a look at the mysql update script, you'll see that temporary tables are created and that the data from the old tables is inserted in the temp ones. Then, the new "working" tables are created and the data is copied from the temporary tables to the "working" ones.
During the insertion of the data, nested queries are performed. And as you seem to have got a lot of data, this takes a long, long time.

Re: Upgrading from 1.2.1 to 1.3

derek — Wed, 12 Jul 2006 11:03:09 GMT

Hi,

Some of our support customers requested a changed script and this looks to be working and is in the process of being tested. It'll feed into the code streams at some point, but essentially you just need to add indexes to all the protocol-identifier-guid columns in the T_ tables.

Regards