[rt-users] mysql performance - recommended indicies?

[Jesse Vincent]

On Thu, Oct 16, 2003 at 02:46:44PM -0700, matthew zeier wrote:
> 
> Running rt3.0.5, mysql 4.0.14.  NOC is starting to see updates taking longer
> than before (10 seconds sometimes).

It's helpful to turn on mysql logging and slow query logging and see
which queries are taking a long time, assuming it's database side lag
and not perl-side lag. Once you know which queries are killing you, it's
much easier to tune.

It's also worth making sure that if you're running with Sendmail brand
sendmail, you're doing background delivery, rather than actually waiting
for mail to be delivered before returning a page.

	-j

> I'm running with a mostly untweaked copy of my-large.cnf on a box with 1GB
> RAM and 2 CPUs.
> 
> Are there some indices I can add to speed things up or settings in my.cnf
> that would help?
> 
> 
> --
> matthew zeier                        | "Nothing in life is to be feared.
> InteleNet Communications, Inc.       |  It is only to be understood."
> (949) 784-7904                       |       - Marie Curie
> 
> _______________________________________________
> 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
> 

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