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

[RichardH]

At 10:03 PM 10/30/2002, Steve Phillips wrote:
>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 :-)
>
>
>_______________________________________________
>rt-users mailing list
>rt-users at lists.fsck.com
>http://lists.fsck.com/mailman/listinfo/rt-users
>
>Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

This came up recently :
Sven Sternberger wrote:
 > Who can send me a link or the script to purge "dead" tickets.
http://lists.fsck.com/pipermail/rt-users/2002-August/009595.html
-- 
Phil Homewood, Systems Janitor, www.SnapGear.com
pdh at snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20021030/7b2214ef/attachment.htm>