[rt-users] Performance issues

[Wozz]

Greetings,

I'm in the process of moving from one system running RT1 (Ultra 10
running Solaris 2.6 w/256m ram) to a new system running RT2 (4x500mhz
Xeon's with RAID 5 disks 1gig ram).  Naturally, I was expecting a
bit of a performance increase, but in fact, I'm finding that RT2
on this new system is a LOT slower.  Now I understand and appreciate
why that is (attachments/transactions in the database, and more
features) but I'm hoping that with some tweaking I can at least get
it back to the level of performance we had with RT1.  I know that Jesse
added the indexes that had been discussed here in the past to the current
versions, but even with them I'm getting pretty bad performance (~40k
tickets, takes 1+ minute to display a ticket).  I've tweaked mysql a bit
with the following options:

key_buffer_size=128M
table_cache=256
sort_buffer=4M
record_buffer=1M

This has reduced the ticket display from 1+ minute to about 15 seconds.

I'm curious if anyone has any other tweaks that might speed up the system
even more.  I'm fairly certain I'm not disk bound, as I'm holding all the
data on a fairly quick RAID5 array and I've watched iostat and friends and
haven't seen any problems along those lines.  Just curious if anyone knows
of any other tweaks to gain me a bit more speed.  Loading up a queue (with
approx 800 tickets in it) takes about 30 seconds and I'd really like to
reduce that time if possible.  Basically, I'm just looking for any and all
tweaks people have performed that have helped out on speed issues.  Thanks!