[rt-users] Huge Attachments table in 3.4.4

[Jesse Vincent]

On Tue, Oct 25, 2005 at 04:14:46PM +0930, Luke Vanderfluit 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?

You might want to start with Jeremy Zawodney's 'mytop' tool.  

Jesse

> 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
> 

--