[rt-users] Re: Performance issues with rt3 - old topic new again..

[Bob Goldstein]

I'm far from an expert here, but I'd guess that Seph is right,
you shouldn't bother troubleshooting this with anything less than
mysql 4.x, even if that doesn't fix the problem itself.

This seems like a mysql issue to me, not based on any particular
evidence though.  I disagree that subsequent fetches should
be faster necessarily, because: a) with mod_perl, you may hit
a different apache child each request, and that child may
not have anything cached, and b) The ticket info _could_
change between hits, due to incoming mail or some other user,
so that RT may need to re-fetch each time to be sure.

I know that mysql can use several different backends, e.g.
isam, heap, myisam, innodb, bdb, all on a per-table basis.
This, and certainly indices, can affect you greatly.
Is it possible that in moving the data between mysql
versions, you have somehow dropped some indices?

And just to play devil's advocate, are there any non-RT
network or apache issues?  That is, I assume you _can_
display a static html page in much less than 5 secs?

    bobg


>Hi Seph. In my posting you will note that I did indeed list MySQL 4.0 as
>something that I have already tried. Please review the message again if you
>have a chance and can offer any other advice.
>
>Thanks for the tip!
>
>----- Original Message ----- 
>From: "seph" <seph at directionless.org>
>To: "Dustin Puryear" <dpuryear at usa.net>
>Sent: Sunday, December 14, 2003 11:45 AM
>Subject: Re: Performance issues with rt3 - old topic new again..
>
>
>> I haven't stared to hard at the performance threads, so I'm far from
>> authoratative, but..
>>
>> > I have a dual PII 333Mhz system with 512MB of RAM dedicated to the task
>of
>> > running rt3. (Well, at this point rt3 is just a test install.) I am
>running
>> > rt3 with FreeBSD 5.1 with SMP, Apache 1.3, modperl1, and MySQL 3.23. 17
>> > queues, 2 users with rights, less than 500 tickets.
>>
>> erm, I think mysql v4 is really recommended over v3. I forget if
>> that's performance, or something else, but I'd change that first.
>>
>> seph
>
>_______________________________________________
>rt-users mailing list
>rt-users at lists.fsck.com
>http://lists.fsck.com/mailman/listinfo/rt-users
>
>Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>