[rt-users] Database Upgrades

[Aleš Sušnik]

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 at lists.fsck.com [mailto:rt-users-admin at lists.fsck.com]
On Behalf Of Jason Alexander
Sent: Wednesday, September 03, 2003 10:08 PM
To: rt-users at 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 at 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