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 the majority of tickets will load and display in under 1 second.
Had to add more RAM to the server also, MySQL was choking. Currently running; Debian Lenny 64Bit 4Gb RAM Apache2 - Modperl MySQL 5.0.51a-24 *Regards,* *Aaron Guise 027 212 6638 aa...@guise.net.nz * On Wed, Jun 17, 2009 at 10:02 AM, Jon Baker <jba...@wgm.us> 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: > > # Query_time: 160.388061 Lock_time: 0.000103 Rows_sent: 1 > Rows_examined: 930035 > SET timestamp=1245189464; > SELECT main.* FROM Attachments main WHERE (main.Content IS NOT NULL > AND main.Content != '') AND (main.Parent = '964022') AND > (main.ContentType = 'text/plain') ORDER BY main.id ASC; > > I've put an index on the Parent and ContentType columns (it's not > letting me do it on the Content column because it's a BLOB) but that > doesn't seem to be speeding it up. We just passed 30,000 tickets and > the Attachment table is huge (2.4 GiB) Any ideas? > -- > Jon Baker > Information Technology > Willie George Ministries > 1003 N 129th E Ave > Tulsa OK 74116 > (918) 234-5656 > > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com