Why are these attachments slowing MySQL down? Maybe there is an index
that would help. If it is content searches in the attachment, you will
lose valid search results with this approach. Maybe switching to a DB
backend that supports full text indexing would help. Currently, there
is a wiki entry for how to do it with an Oracle backend and I am working
on a similar entry for PostgreSQL. Just some ideas.
KenOn Sat, Oct 11, 2008 at 10:27:14AM -0700, Kelly Jones wrote:
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
UPDATE Attachments SET Content = ‘’,
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.
Community help: http://wiki.bestpractical.com
Commercial support: email@example.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com