[rt-users] Performance Issues

[Kevin Sonney]

I had this same problem and unpgraded MySQL to 4.0 and all has been
well.

Thanks,

Kevin

-----Original Message-----
From: Cliff Flood [mailto:cliff.flood at voxpilot.com] 
Sent: Tuesday, October 19, 2004 9:38 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Performance Issues


Hi Guys,

We have an RT install that is performing quite poorly. Tickets take 
quite a few seconds to open, sometimes 20 or more, depending on the 
number of replies/comments. Our system has 896 tickets at present.

We were running 3.0.11. I upgraded to 3.2.2 hoping I might see some 
performance gains but unfortunately I didn't.

I changed my MySQL (3.23.49) tables from MyISAM to InnoDB with no 
discernible performance gain.

Applied some (Kernel shared memory, MySQL buffers) of the suggestions 
from the PerformanceTuning[1] section of the WiKi, again with no 
noticeable increase in performance. Upgraded DBIx::SearchBuilder to 1.11

Other pertinent stats;

Apache 1.3.31
Perl 5.8.4
Linux 2.4.7-10smp
Dual PIII 500Mhz
512MB RAM
2 reasonably fast 10,000rpm SCSI discs in RAID 1.

When a ticket is being served I can see Apache using 99% CPU time for 
the duration of the serve.

I've done much reading of the available docs. and mailing list archives.

I'm not quite sure what I should look at next. I know this class of 
problem seems to be common. I haven't seen any definitive answers. Any 
pointers would be appreciated.

1. http://wiki.bestpractical.com/index.cgi?PerformanceTuning
-- 
Cliff Flood
Systems Administrator
V O X P I L O T
+353 1 209 1924
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com