[Rt-devel] Upgrading a gigantic 3.4.4 database to 4.0?

[Raed El-Hames]

Jeff:

As suggested I would also recommend a 64-bit kernel, but I would also recommend you consider partitioning the Attachments table, table partitioning is available in mysql versions 5.x

Roy
> -----Original Message-----
> From: rt-devel-bounces at lists.bestpractical.com [mailto:rt-devel-
> bounces at lists.bestpractical.com] On Behalf Of Jeff Albert
> Sent: 04 May 2011 22:07
> To: rt-devel at lists.bestpractical.com
> Subject: Re: [Rt-devel] Upgrading a gigantic 3.4.4 database to 4.0?
> 
> Hey Kevin,
> Thanks for the quick reply. MySQL's error log suggests it's failing to
> allocate memory past about 2.5GB; I'll work with our DBAs to see what we
> can do with MySQL in this area.
> 
> Generally I'm curious about the feasibility of continuing to run a single
> large instance of RT; presumably at some point the query times will just
> become untenable (bringing up the query builder in our existing 3.4
> instance can take up to a minute even now). Would you recommend separating
> into smaller instances, or a different approach?
> 
> Cheers,
> Jeff
> 
> -----Original Message-----
> From: rt-devel-bounces at lists.bestpractical.com [mailto:rt-devel-
> bounces at lists.bestpractical.com] On Behalf Of Kevin Falcone
> Sent: Wednesday, May 04, 2011 1:54 PM
> To: rt-devel at lists.bestpractical.com
> Subject: Re: [Rt-devel] Upgrading a gigantic 3.4.4 database to 4.0?
> 
> On Wed, May 04, 2011 at 01:35:43PM -0700, Jeff Albert wrote:
> >    Now that RT 4.0 is out, I've finally been granted resources to move
> forward from our existing
> >    RT 3.4.4 install. The challenge we've been having with that existing
> install is that it's huge
> >    - over 17GB on disk, with on the order of 250,000 tickets in 71
> active queues, and roughly a
> >    hojillion attachments.
> 
> I've successfully converted larger Attachments tables, so you should be
> fine.
> 
> >    At this point I'm working with a new server and a clone of the 3.4.4
> database, trying to get
> >    through the RT 4.0 schema update steps, and the `ALTER TABLE
> Attachments...' query is running
> >    for many hours and then dying, apparently unsuccessfully; I presume
> the issue is the number
> >    and size of blobs to be processed.
> 
> You should be checking the mysql error logs to find out why it failed, or
> running the output of upgrade-mysql-schema.pl through mysql -v to get some
> more diagnostics.
> 
> Without knowing *why* it failed, it's hard to offer suggestions.
> 
> -kevin
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-
> devel