[rt-users] 2.0.9 bogs with >10K tickets
chris at hostorlando.com
Thu Dec 20 12:55:59 EST 2001
Here's what I have from an old email to the list:
alter table Transactions ADD INDEX TicketIndex(Ticket);
alter table Transactions ADD INDEX EffectiveTicketIndex(EffectiveTicket);
alter table Transactions ADD INDEX CreatorIndex(Creator);
alter table Attachments ADD INDEX CreatorIndex(Creator);
alter table Attachments add index ParentIndex(Parent);
alter table Attachments ADD INDEX TransactionId(TransactionId);
alter table Tickets ADD INDEX EffectiveIdIndex(EffectiveId);
alter table Tickets ADD INDEX OwnerIndex(Owner);
alter table Tickets ADD INDEX CreatorIndex(Creator);
Hope this helps.
Host Orlando, Inc.
> -----Original Message-----
> From: rt-users-admin at lists.fsck.com
> [mailto:rt-users-admin at lists.fsck.com]On Behalf Of Darren Nickerson
> Sent: Thursday, December 20, 2001 12:28 PM
> To: Steve Poirier
> Cc: rt-users at lists.fsck.com
> Subject: Re: [rt-users] 2.0.9 bogs with >10K tickets
> >>>>> On Thu, 20 Dec 2001, "Steve" == Steve Poirier wrote:
> Steve> Hi Darren,
> Steve> Check at archive there are some posts on indexes you can
> apply to your
> Steve> db which greatly improves performance if you hardware is
> suitable for
> Steve> the operations of your box. 10,000 tickets is relativaly
> small for a
> Steve> MySQL database considering the schema of the archive.
> Thanks Steve, I DID check the archives before bothering the list
> and I thought
> I only saw posts which referred to the 1.x release series of RT.
> I has assumed
> that 2.0.9 would have included much of that.
> I'll take a closer look.
> rt-users mailing list
> rt-users at lists.fsck.com
More information about the rt-users