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

[Aaron Guise]

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
aaron at guise.net.nz
 *



On Wed, Jun 17, 2009 at 10: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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090618/1e7944ef/attachment.htm>