[rt-users] Re: Performance Issues (a bug?)

[Jesse Vincent]

On Oct 12, 2004, at 3:25 PM, Dan Pritts wrote:

> On Tue, Oct 12, 2004 at 02:43:04PM -0400, Rich West wrote:
>> Actually, each user's *request* goes to a fastcgi server process.  It 
>> is
>> similar to the way that httpd handles requests.  So, if you use a
>> typical browser to pull up a page, it may contain a number of 
>> requests,
>> which get spread across the fastcgi servers.
>
> I am guessing here but I imagine that the frame containing the ticket
> diary is a single http request.  This is where it's so slow.
>
>> I would be curious to see your mysql modifications for my own possible
>> benefit. :)
>
> Look at the example my.cnf files that come with the mysql distribution.
> On my red hat system they are:
>
>     ~@basie% ls /usr/share/doc/mysql-server-3.23.58/
>     my-huge.cnf  my-large.cnf  my-medium.cnf  my-small.cnf
>
> I think my-small is the default.  I took my-large.cnf and tweaked
> it a little so it didn't use quite so much RAM but it still uses 
> plenty.
>
> Didn't make a difference; I had fewer than 100 tickets in the DB.  I'm
> sure it *will* make a difference as my database grows.


You do know that RT flat out _requires_ MySQL 4, right?