<html>
At 10:03 PM 10/30/2002, Steve Phillips wrote:<br>
<blockquote type=cite class=cite cite>Hey there :-)<br><br>
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.<br><br>
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.<br><br>
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.<br><br>
I currently have mysql using the my-huge.cnf configuration
file.<br><br>
Any help would be appreciated :-)<br><br>
<br>
_______________________________________________<br>
rt-users mailing list<br>
rt-users@lists.fsck.com<br>
<a href="http://lists.fsck.com/mailman/listinfo/rt-users" eudora="autourl">http://lists.fsck.com/mailman/listinfo/rt-users</a><br><br>
Have you read the FAQ? The RT FAQ Manager lives at
<a href="http://fsck.com/rtfm" eudora="autourl">http://fsck.com/rtfm</a><br>
</blockquote><br>
This came up recently :<br>
Sven Sternberger wrote: <br>
> Who can send me a link or the script to purge "dead"
tickets.<br>
<font color="#0000FF"><u><a href="http://lists.fsck.com/pipermail/rt-users/2002-August/009595.html" eudora="autourl">http://lists.fsck.com/pipermail/rt-users/2002-August/009595.html</a></u></font>
<br>
-- <br>
Phil Homewood, Systems Janitor, <a href="http://www.snapgear.com/" eudora="autourl"><font color="#0000FF"><u>www.SnapGear.com</a></u></font> <br>
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630 <br>
SnapGear - Custom Embedded Solutions and Security Appliances <br><br>
</html>