[rt-users] Slow querys - can I speed this up?

[Ruslan Zakirov]

mysql 5.1.x? report into mysql's bug tracker.

On Wed, Jun 17, 2009 at 2:02 AM, Jon Baker<jbaker at 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.