[rt-users] Moving large attachments outside of MySQL?

[Kelly Jones]

Our RT is cluttered with large attachments, slowing down the MySQL engine.

Our hack fix: move these attachments to a webserver and do this on the
Attachments table:

UPDATE Attachments SET Content = '<META http-equiv="refresh"
content="0;URL=ourserver.com/queuename/attachmentid/original_filename.original_\
extension">',
ContentType='text/html' WHERE id = attachmentid;

for large attachments.

This helps, but is there a better solution?

-- 
We're just a Bunch Of Regular Guys, a collective group that's trying
to understand and assimilate technology. We feel that resistance to
new ideas and technology is unwise and ultimately futile.