[rt-users] Huge Attachments table in 3.4.4

Jesse Vincent jesse at bestpractical.com
Wed Oct 26 08:53:03 EDT 2005

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.  


> 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


More information about the rt-users mailing list