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: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
