If that is the case, then RT is un-upgradeable. Which would be a problem obviously. I can’t take out our database for 6 days. Over a weekend, sure. But no more than that. Does anyone have any suggestions as to how I can optimise this at all?
David----- Original Message -----
From: “Aaron Guise” firstname.lastname@example.org
To: “David Hobley” email@example.com
Sent: Monday, 2 March, 2009 8:54:58 PM GMT +10:00 Brisbane
Subject: Re: [rt-users] DB Problems upgrading to RT 3.8.2 from 3.6.5
MySQL has to convert each one of those attachments to the new datatype. Sadly this just takes time. Our DB is only miniscule compared to yours and from memory it takes around an 1hour just to get through all of our attachments.
I think it is highly likely that this could be normal due to the amount of data it has to manipulate. But as it said in the docs you need to test everything. especially those binary attachments namely .pdf,.xls etc. I have some difficulty with my database for some reason or another where in doing the schema upgrade it proceeds to corrupt them all…
On Mon, Mar 2, 2009 at 2:16 PM, David Hobley < firstname.lastname@example.org > wrote:
I have a (happily) running RT 3.6.5 with approx 300,000 tickets in it and a database of size of around 9 Gig (lots of attachments sadly). I have the application upgraded, but when I try and run the schema upgrade in my test environment it is taking forever (for values of forever which equate to around 6 days anyway):
perl etc/upgrade/ schema.mysql-4.0-4.1.pl rt3 root "password > ~/sql.queries
mysql -p rt3 < ~/sql.queries
Does anyone have any suggestions as to how I can make this faster? I have tried to optimise MySQL as much as possible, but I am not a db expert and obviously there is something wrong. Nb. The test environment is actually more powerful than the production one after having shutdown evey VM on the machine and ensured I was only running this for the time it took.
Community help: http://wiki.bestpractical.com
Commercial support: email@example.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Creators of Miessence, MiVitality and MiEnviron
Phone: +61 (7) 5582 7020
Fax: +61 (7) 5539 6719
USA Fax 1800 840 0827
Email : firstname.lastname@example.org