[rt-users] speeding up rt-shredder

[ronald higgins]

Well, @ 1 ticket deleted per 40 seconds it will only take 324 days to
clean up the DB.....

This is a bit crazy.


On Tue, Jul 27, 2010 at 10:33 PM, Maxwell Rathbone
<mrathbone at sagonet.com> wrote:
>  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
>>>
>>
>>
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>