DBUpdate-to-2.4.mysql.sql takes extremely long time

[petfrogg]

Hello!

My database that i am trying to migrate is 6.9 GB large. I know that since i am doing a practice run before upgrading from 2.3->2.4->3.

When running the DBUpdate-to-2.4.mysql.sql the sql statement:
”ALTER TABLE article_attachment ADD content_id VARCHAR (255) NULL;”

Takes extremly long time. After letting it run for the weekend it was still running on monday when i got back i finaly pulled the plug and aborted it. I then ran

ALTER TABLE `article` DISABLE KEYS;
ALTER TABLE `article_attachment` DISABLE KEYS;
ALTER TABLE `mail_account` DISABLE KEYS;
ALTER TABLE `queue` DISABLE KEYS;
ALTER TABLE `sla` DISABLE KEYS;
ALTER TABLE `ticket` DISABLE KEYS;
ALTER TABLE `users` DISABLE KEYS;
ALTER TABLE `xmlstorage` DISABLE KEYS;

(This was due to me checking wrong file of alter tables but i atleast i got the article_attachment)

This was in order to speed it up a little making the database focus on one thing at the time.

Anyway – with my article_attachment containing 75 734 rows should it really takes hours to run the alter table?

CentOS: 6.2
Mysql: Ver 14.14 Distrib 5.1.52, for unknown-linux-gnu (x86_64) using readline 5.1

[jojo]

yes, these scripts can run some hours