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