[rt-users] Clearing out old messages from the database

[Steve Phillips]

Hey there :-)

we have an issue with RT running rather slowly when pulling up jobs and the 
like and after some investigation have come to the conclusion that we have 
a rather overloaded database if nothing else.

After 10 months of operation we have an Attachment table that is a little 
over a gig in size and are up to ticket ID 120,000+, I had just upgraded 
the machine the tracking system was running on which didn't help much (its 
now a quad xeon 550 with 4gig of ram) and have been looking about for a 
tool that would pull off all the tickets older than XX date and 
archive/delete them yet cant seem to find anything.

Either that or are there some database optimisations I can do to speed 
things up ? we are running mysql and rt-2.0.15 on a redhat 7.3 box.

I currently have mysql using the my-huge.cnf configuration file.

Any help would be appreciated :-)