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
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@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@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances