[rt-users] Performance Issues

[Rick Rezinas]

yes.  It will make a difference for you.  You'll find example my.cnf
files in
/usr/local/src/mysql-standard-4.0.14-sun-solaris2.8-sparc/support-files/
(or wherever your source build is).  Modify and place into /etc/ as
my.cnf and restart the whole shebang.  Give it a shot.

On Thu, 2004-09-09 at 12:14, Dan Pritts wrote:
> 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
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com
-- 
Rick Rezinas
Unix Systems Administrator
Qsent, Inc.