[rt-users] speeding up rt-shredder

[Maxwell Rathbone]

  I'd love the ability to export the attachments and store them on the 
filesystem instead of in the database. Would certainly cut down the 
database size!

I did find this, if it helps anyone:
http://github.com/bestpractical/rt-extension-utils/blob/master/sbin/rt-extract-attachment

This allows the extraction or exporting of the attachments. However that 
still doesn't solve the problem of the attachment being in the database, 
or how to reference it from the ticket.

I read on this mailing list on 4/29, regarding "Attachments on disk?":
Hi Thierry,
there is a addon bps wrote but it is not available public at the moment. 
Hopefully Jesse will push it out some day.

Torsten

So as it stands, it appears there still is no method of doing this. So 
if anyone succeeds in writing a patch, please share it!

Max

On 7/27/2010 4:08 PM, Asif Iqbal wrote:
> On Tue, Jul 27, 2010 at 3:54 PM, G.Booth<G.Booth at lboro.ac.uk>  wrote:
>> On Tue, 27 Jul 2010 21:28:37 +0200
>>   ronald higgins<ronald.higgins at gmail.com>  wrote:
>>> Hi Garry,
>>>
>>> The RT DB is currently 215GB in size, 1.5 Million Tickets (Attachments
>>> table has 7 million entries).
>>> Yes, this badboy is what I inherited with the new job. I've already
>>> built another MySQL DB with the tables partitioned intended for
>>> eventual cut over
>>> but the last few days have seen the current prod db taking a hit
>>> performance wise which is when i really started digging through the
>>> tickets looking for a stop gap until we can cut over, and i'm sure
>>> cutting the Tickets down by 700 000 will make a difference.
>>>
>>> By all means, send it :) All tools of the trade are always gladly received
>>> :)
>> OMFG!
>> Mine is 4GB, 150000 tickets, so it looks like you've got some big
>> attachments!
>>
>> Think this will be painful!
>> will send script with explanation when I get back.
>> I'd seriously look at the attachments table as my RT is 10% of yours in
>> tickets, but only 2% the size.
>>
>> Can you zap attachments above 1Gb?
> would be nice if the attachments could be converted to link.
> we have a ftp server in same network  that has lots of space.
>
> Anyone has done anything like this?
>
> If you reply please change the subject too.
>
>>
>> regards
>> Garry
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>
>
>