[rt-users] DB Problems upgrading to RT 3.8.2 from 3.6.5

[David Hobley]

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? 

Cheers, 
David 
----- Original Message ----- 
From: "Aaron Guise" <aaron at guise.net.nz> 
To: "David Hobley" <david.hobley at mionegroup.com> 
Cc: rt-users at lists.bestpractical.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 

Hi Dave, 

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.... 

-- 
Regards 

Aaron 


On Mon, Mar 2, 2009 at 2:16 PM, David Hobley < david.hobley at mionegroup.com > wrote: 




Hello, 

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 
# time `mysql -p rt3 < ~/sql.queries` 
Enter password: 

real 8727m23.622s 
user 0m0.012s 
sys 0m0.004s 

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. 
-- 
Cheers, 
David 


_______________________________________________ 
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users 

Community help: http://wiki.bestpractical.com 
Commercial support: sales at bestpractical.com 


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com 



-- 
Cheers, 
David Hobley 

IT Manager 
Creators of Miessence, MiVitality and MiEnviron 

Phone: +61 (7) 5582 7020 
Fax: +61 (7) 5539 6719 
USA Fax 1800 840 0827 
Email : david.hobley at mionegroup.com 
Website: www.mionegroup.com 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090303/48feffe0/attachment.htm>