[rt-users] 2.0.9 bogs with >10K tickets

[Darren Nickerson]

Folks,

Poor MySQL is pegging CPU trying to update tickets these days. I'm not sure
when this began, but we just exceeded the 10,000 mark on tickets today, which
prompted me to spend a little time looking at the performance scaling.

Are there any knobs I can twiddle to improve MySQL's response time? I haven't
spent a lot of time digging into the schema . . . but would assume that a great
deal of thought had gone into this already.

Thanks!

-Darren