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, [email protected] 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
--
RT Training - Boston, September 9-10
http://bestpractical.com/training
