Shredder

Hi There,

It has been a while since I have worked with RT… but I still love it.

I need to shred old tickets, tickets that have been closed for more than a year or two.

Why? Our RT database is now just over 115GB in size and mysql is not coping.

I don’t want to remove the tickets, I want to remove the transactions and attachments.

As I understand it, this will allow someone to still search for a ticket and find some metadata about the ticket - helping the user to find more information elsewhere about the issue.

I couldn’t work out how to do this. How do I use more than 1 plugin at a time?

Does anyone know how?

I look forward to your responses.

Thanks & Regards
Jens

Hi Jens,

I need to shred old tickets, tickets that have been closed for more than a
year or two.

Why? Our RT database is now just over 115GB in size and mysql is not
coping.

OK, thats not so big :wink:

I don’t want to remove the tickets, I want to remove the transactions and
attachments.

We have a RT Addon from BPS which is not removing/deleting the Attachements
but stores them on disk instead of DB, this could work for you.
@BPS: When will the AttachmentOnDisk Addon available at Github?

As I understand it, this will allow someone to still search for a ticket
and find some metadata about the ticket - helping the user to find more
information elsewhere about the issue.

I couldn’t work out how to do this. How do I use more than 1 plugin at a
time?

Under RT 3.8? just add the second besides the first at the RT_SiteConfig.pm
Plugin Entry…?!?

Does anyone know how?

I look forward to your responses.

Thanks & Regards
Jens


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

MFG

Torsten Brumm

http://www.brumm.me