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<[email protected]> wrote:
On Tue, 27 Jul 2010 21:28:37 +0200
ronald higgins<[email protected]> 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
