How do I best clean out a RT database?

We’ve been running RT since 2001. Our Attachments table in the MySQL
database has reached over 1.3GB in size. What’s the best way to go about
cleaning that up?

I had thought that a simple “DELETE FROM Attachments WHERE Created <
“2008*”” would do the trick. That would easily clean up 2/3s of the
database. Is there a best practices method to go about doing this?

We’re on RT 3.6.6

Ryan Stepalavich
Systems Administrator
S&S Worldwide, Inc.
(800) 537-3451 Ext. 2195
http://www.ssww.com

Hello,

You can do delete from attachments, probably history of those old
tickets will be just empty without any content. You can download
shredder extension from CPAN. Upgrade to 3.8.x where shredder right in
core. If you upgrade to 3.8 then you can use dirty deletion tool from
RT-Extension-Utils. This one is just set of SQL queries that drop all
tickets with status equal to ‘deleted’ without any backups, but very
fast.

Note that ibdata files in this case stay at the same size, but space
got reused later.On Fri, Jul 9, 2010 at 7:39 PM, Ryan Stepalavich ryans@ssww.com wrote:

We’ve been running RT since 2001. Our Attachments table in the MySQL
database has reached over 1.3GB in size. What’s the best way to go about
cleaning that up?

I had thought that a simple “DELETE FROM Attachments WHERE Created <
“2008*”” would do the trick. That would easily clean up 2/3s of the
database. Is there a best practices method to go about doing this?

We’re on RT 3.6.6

Ryan Stepalavich
Systems Administrator
S&S Worldwide, Inc.
(800) 537-3451 Ext. 2195
http://www.ssww.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.