Deleting attachments

RT Users
1

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.

2

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

3

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