[rt-users] deleting attachments

[Woody - Wild Things]

Hi Ken,

Thanks for your quick reply.
There is no specific performance issue that i can see, apart from timley 
nightly backups. Removing large attachments would be fine, but wouldn't 
that remove them all, even the ones from say the past year that i need 
to keep?

Maybe i should just "not worry about it", but i've only got 50G left on 
the server (its only a 230GB drive) so it's something i'll have to 
address soon as each GB the db grows probably adds another 5 in stored 
backups etc

w.

On 09/09/14 15:54, ktm at rice.edu wrote:
> On Tue, Sep 09, 2014 at 01:52:25PM +0300, Woody - Wild Things wrote:
>> Hello,
>>
>> My rt4 database has now hit 10GB and i want to clean it out by
>> removing some old attachments.
>> As far as i an see from rt-shredder attachments can only be removed
>> by size, and not created before a certain date.
>> Can I just delete the attachments directly from the database with
>> sql? or is that unwise?
>>
>> thanks
>>
>> w.
>>
> Hi Woody,
>
> If you are deleting attachments created before a certain date, you are
> effectively removing all of the ticket data so you should just remove
> all tickets before a certain date. They are numbered sequentially so
> that is easy to do. Otherwise, just removing the larger attachments can
> free up space. I am curious, 10GB does not seem terribly large. Is the
> size causing any performance issues with your system?
>
> Regards,
> Ken
>
>