Have you tried tuning MySQL with mysqltuner? We had a similar problem when
our attachments table grew over 2.2gb. I was able to resolve the issue we
had by increasing settings based on the recommendations from mysqltuner. We
frequently experienced ticket load times of upto 14 - 30 seconds but now
mysql 5.1.x? report into mysql's bug tracker.
On Wed, Jun 17, 2009 at 2:02 AM, Jon Baker wrote:
> RT frequently acts sluggish (this may or may not be related to my
> other thread about mailgate timing out) so I've turned on the slow
> query log in mySQL, and am getting this error quite frequently:
RT frequently acts sluggish (this may or may not be related to my
other thread about mailgate timing out) so I've turned on the slow
query log in mySQL, and am getting this error quite frequently:
# Query_time: 160.388061 Lock_time: 0.000103 Rows_sent: 1
Rows_examined: 930035
SET timestamp