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

[Ruslan U. Zakirov]

Asif Iqbal wrote:
> 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?
It's mysql :)
As I understood manual ibdata file never become smaller then it was, but 
after DELETE, DROP mysql uses empty blocks.

Mysql allow recreate ibdata file, size would be as much as needed for 
your data.
http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html

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