[rt-users] RTx::Shredder to delete old tickets

[Asif Iqbal]

Ruslan U. Zakirov wrote:
> 		Hello.
> OO API allow delete any RT object.
> 
> No script (rtx-shredder) is not full featured.
> You can easy comment out Limit(FIELD => 'Status', VALUE => 'deleted') or 
> add another Limit condition.
> 
> If you want delete more then 1k tickets at once you need much memory. I 
> had big memory footprint with 20k tickets, because of it I did step by 
> step wiping out. I'll fix this problem next release.
> 
> 				Best regards. Ruslan.

Is there any tool done by RT community to reduce the size of the ibdata tablespaces?

> 
> Asif Iqbal wrote:
> >Ruslan U. Zakirov wrote:
> >
> >>Asif Iqbal wrote:
> >>
> >>>Hi 
> >>>
> >>>Can RTx::Shredder be used to delete Tickets/Transactions for Tickets
> >>>older than may be one year?
> >>
> >>yes, current rtx-shredder script do exactly this action.
> >>/opt/rt3/local/sbin/rtx-shredder YYYY-MM-DD
> >>Wipeout deleted tickets and all data that depends only on them.
> >
> >
> >How about deleting all tickets (resolved/deleted/stalled/...) from
> >YYYY-MM-DD to the beginning. For examples all tickets that are older
> >than say 2002-12-31
> >
> >Can it do that?
> >
> >
> >>Feedback is more then wellcome, it's required.
> >>
> >>
> >>>I like to use that to reduce the size of my ibdata1 and ibdata2
> >>>tablespaces which are in total over 5 gig which is almost 80% of my file
> >>>partition in Solaris 8. 
> >>
> >>May be after shredding you should do some manipulation with mysql, I 
> >>don't know if InnoDB engine reduce size of files after DELETE's.
> >>
> >>>Thanks for the help
> >>
> >>
> >>					Best regards. Ruslan.
> >
> >
> 

-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
There's no place like 127.0.0.1