[rt-users] Performance issues

[Jesse Vincent]

have you installed DBI::SearchBuilder 0.46-test1, as recommended in 
last week's conversation about performance tuning?


On Wed, Oct 17, 2001 at 03:47:16PM -0600, Wozz wrote:
> 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!
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.