Database Upgrades

RT Users
1

Hello all,

I just upgraded from RT 3.0.1 to RT 3.0.4 and moved from Mysql 3.23.56
to Mysql 4.0.14. I was wondering what I need to do to my existing
database to make it work better. I saw a comment about changing all the
table types from MyISAM to InnoDB but I havent’ seen much else. I heard
someone say something about indexes but I can’t seem to find that.

The instructions say to check the /etc/upgrades directory but I don’t
see anything in there for upgrading from 3.0.1 to 3.0.4

Thanks
Jason

2

Apply this 2 indexes:
create index group1 on CachedGroupMembers (GroupId);
create index member1 on CachedGroupMembers (MemberId);

Also, I recommend using RT 3.0.5pre3, speed issues resolved in this version.

Also, depending on your RAM capabilites use the correct my.cnf file which
comes with mysql 4 (i recommend my-large.cnf if you have more then 300mb for
RT to run normally).

Also, search the RT mailing list for your answers, this question, with
almost the same answer (about the indexes) was posted atleast 2 times.

A.-----Original Message-----
From: rt-users-admin@lists.fsck.com [mailto:rt-users-admin@lists.fsck.com]
On Behalf Of Jason Alexander
Sent: Wednesday, September 03, 2003 10:08 PM
To: rt-users@lists.fsck.com
Subject: [rt-users] Database Upgrades

Hello all,

I just upgraded from RT 3.0.1 to RT 3.0.4 and moved from Mysql 3.23.56
to Mysql 4.0.14. I was wondering what I need to do to my existing
database to make it work better. I saw a comment about changing all the
table types from MyISAM to InnoDB but I havent’ seen much else. I heard
someone say something about indexes but I can’t seem to find that.

The instructions say to check the /etc/upgrades directory but I don’t
see anything in there for upgrading from 3.0.1 to 3.0.4

Thanks
Jason

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm