[rt-users] mysql performance - recommended indicies?

[matthew zeier]

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