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 <[email protected]> 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<[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 > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
