[rt-users] Slow ticket open - how to improve performance?
Adolfo Santiago
mailbag at anothernet.com
Tue Feb 24 19:17:18 EST 2004
Follow up...
Put in 512 Megs of RAM to bring up the box to 784 Megs or so.
I see performance improvements here and there, in some cases great
improvements (like bringing up a list of tickets). But there are still
"pockets of resistance". Like this one ticket that takes about 10 seconds
to open. Nothing special about it, just several comments and responses.
But I don't regret putting in the extra memory.
Chago
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com]On Behalf Of Adolfo
> Santiago
> Sent: Tuesday, February 24, 2004 1:41 PM
> To: rt-users at lists.bestpractical.com
> Subject: RE: [rt-users] Slow ticket open - how to improve performance?
>
>
> I'm buying more memory today. The nagging I keep hearing is getting a
> little old...
>
> In any case, I don't understand why we've been so stingy with the
> memory on
> this server. Even our regular office workstations have AT LEAST
> that much.
>
> I'll report back in with the improvement (or lack thereof).
>
> What about any other potential improvements? Anyone?
>
> Chago
>
>
> > -----Original Message-----
> > From: Karl Pietri [mailto:kpietri at nvps.net]
> > Sent: Tuesday, February 24, 2004 1:17 PM
> > To: Adolfo Santiago; rt-users at lists.bestpractical.com
> > Subject: Re: [rt-users] Slow ticket open - how to improve performance?
> >
> >
> > We were experiancing slow being slow in general and also had a
> similar mem
> > situation (11 physical free). Upgrading it to 512 sped things up 90%
> >
> > -Karl Pietri
> > ----- Original Message -----
> > From: "Adolfo Santiago" <mailbag at anothernet.com>
> > To: <rt-users at lists.bestpractical.com>
> > Sent: Tuesday, February 24, 2004 12:54 PM
> > Subject: [rt-users] Slow ticket open - how to improve performance?
> >
> >
> > > Opening tickets can sometimes take a long time (15-20 seconds).
> > Ours is a
> > > brand new installation (just entered the second week), we
> only have two
> > > users, and less than 400 tickets.
> > >
> > > What can we do? We've noticed that tickets with longer histories take
> > > longer to come up (makes sense), but these histories are
> > usually composed
> > of
> > > simple things like status changes, ownership changes, and
> short messages
> > or
> > > comments.
> > >
> > > I've gone over the archives and implemented as many of the
> > improvements I
> > > found (MySQL memory settings, database indexes, etc). Here are the
> > indexes
> > > I created:
> > >
> > > 1. alter table TicketCustomFieldValues add index (Ticket);
> > > 2. create index CacheMemId on CachedGroupMembers(MemberId);
> > > 3. create index CacheGrouID on CachedGroupMembers (GroupId);
> > > 4. create index CacheMemIdGrouId on
> > CachedGroupMembers(MemberId,GroupId);
> > > 5. create index PrincipalType on Principals(PrincipalType);
> > > 6. create index CustomField on TicketCustomFieldValues(CustomField);
> > > 7. create index Domain on Groups(domain);
> > > 8. create index Instance on Groups(instance);
> > >
> > > The above are in addition to the indexes the RT came with "out of the
> > box".
> > >
> > > Our hardware and software set up is:
> > >
> > > 1. RT 3.0.8
> > > 2. Apache 1.3.29 using mod_perl (all compiled with the
> latest source as
> > of
> > > 2/1/2004)
> > > 3. MySQL 3.23.58 (compiled with the latest source as of 2/1/2004)
> > > 4. Athlon 800 Mhz, 256 Meg RAM
> > > 5. 100 Mbit LAN
> > > 6. Caldera OpenLinux 3.11 (Linux kernel v2.4.13).
> > >
> > > What are we missing? How can we improve? Is the hardware not enough?
> > > Should we add more memory? Here's the output of the "free" command:
> > >
> > > total used free shared buffers
> > cached
> > > Mem: 255448 243956 11492 12 2652
> > 87184
> > > -/+ buffers/cache: 154120 101328
> > > Swap: 208836 136640 72196
> > >
> > > Are we too constrained?
> > >
> > > Any help would be much, much appreciated.
> > >
> > > Thanks!
> > >
> > > Chago
> > >
> > >
> > > _______________________________________________
> > > rt-users mailing list
> > > rt-users at lists.bestpractical.com
> > > http://lists.bestpractical.com/mailman/listinfo/rt-users
> > >
> > > Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm
> >
>
> ** CRM114 Whitelisted by: lists.bestpractical.com **
>
_______________________________________________
rt-users mailing list
rt-users at lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users
Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
More information about the rt-users
mailing list