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

[Aaron Guise]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090302/440b8a0a/attachment.htm>