[rt-users] mysql performance - recommended indicies?

[matthew zeier]

A restart of apache has done wonders for speed.  Running apache 1.3.27 with
mod_perl .

----- Original Message ----- 
From: "matthew zeier" <mrz at intelenet.net>
To: <rt-users at lists.fsck.com>
Sent: Thursday, October 16, 2003 2:46 PM
Subject: [rt-users] mysql performance - recommended indicies?


>
> Running rt3.0.5, mysql 4.0.14.  NOC is starting to see updates taking
longer
> than before (10 seconds sometimes).
>
> 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
>