[rt-users] Performance Issues

[Dan Pritts]

On Thu, Sep 09, 2004 at 02:50:26PM -0400, Jesse Vincent wrote:
> Ok. That tells us that 1) you're running mysql in the default
> configuration, which is optimized for a pentium 133 with 64 megs of RAM.
> That's a bad plan. 

Nice.  But is this really the problem here with a db with 100 tickets?

> and 2) you missed the note that said that InnoDB is a
> hard requirement. You _should_ see massively degraded performance if
> you're running without it. And also, database corruption.

Whoops.  I must have modified the my.cnf after installing RT.  I probably 
did this to turn on skip-networking and copied the skip-innodb from
another server without remembering it was necessary.

However, i've turned it on, and restarted mysql, and there's no
apparent effect.   Things still take a long time, and mason_handler.fcgi
processes still eat the CPU (visible via top) while I'm waiting for the
web requests to be fulfilled.

thanks for all your help.

danno
--
dan pritts                                       danno at internet2.edu
systems administrator                            734/352-4953 office
internet2                                        734/834-7224 mobile