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

[Ruslan U. Zakirov]

		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.

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.
> 
>