Trimming the database


#1

Hello. We’ve been running RT for awhile here internally and the database
is starting to really get sluggish. Does anyone have a script to archive
out tickets that are over x months old and closed?

thanks
Mark

Mark Steiger Systems Administrator
651-604-7890 Veritas Software
"A computer system without Microsoft products is
like a dog without bricks chained to its head."
–David Wagle


#2

What version of mysql are you using? What version of RT are you using?
A first step is to add a few indexes, which will greatly increase performance

As far as I know, nobody’s built the data migration / archiving tools yet.
That’s one of those things that I might be willing to take on if a specific
client had an interest in making it happen.

jesseOn Thu, May 11, 2000 at 02:55:13PM -0500, Mark Steiger wrote:

Hello. We’ve been running RT for awhile here internally and the database
is starting to really get sluggish. Does anyone have a script to archive
out tickets that are over x months old and closed?

thanks
Mark


Mark Steiger Systems Administrator
651-604-7890 Veritas Software
"A computer system without Microsoft products is
like a dog without bricks chained to its head."
–David Wagle


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – jrvincent@wesleyan.edujesse@fsck.com
pgp keyprint: 50 41 9C 03 D0 BC BC C8 2C B9 77 26 6F E1 EB 91
sage will enter into a period of
indentured servitude which will last for a period of time no less than seven
years.