[rt-users] Huge Attachments table in 3.4.4

[Ruslan Zakirov]

On 10/25/05, Luke Vanderfluit <lvanderf at internode.com.au> wrote:
> Hi.
>
> I have upgraded RT from 3.0.11 to 3.4.4. Mysql 4.0.18, Apache 1.3.27
> (with static modperl module).
> The database we are using is quite large.
> The main problem we are having is when a user needs to comment on a
> ticket, the loading of a ticket can take quite a long time.
> This is due to mysql churning through data.
> I'd like to find out how to speed up this process.
>
> How do I find out what tables mysql is checking through when RT is
> loading the Update.html page?
http://wiki.bestpractical.com/?Debug

>
> I'm pretty sure that the lag is caused by an oversized attachments table.
> Are there any suggestions for additional indexes on the attachments
> table that could speed things up?
>
> Thanks.
>
> Kind regards.
>
> --
> Luke
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
> Buy your copy of our new book, RT Essentials, today!
>
> Download a free sample chapter from http://rtbook.bestpractical.com
>


--
Best regards, Ruslan.