[rt-users] Large Attachments Table

Maciej Dobrzanski reg.bestpractical at posterus.com
Wed Oct 10 15:43:09 EDT 2012



Other than modifying RT itself to store attachments outside of the main
database, you could also try InnoDB compression first. It is available in
all recent MySQL versions (5.1, 5.5, 5.6) and it is completely transparent
to queries or applications. Even with some number of larger attachments,
there is always still a lot of plain text in this table (e-mails, comments),
i.e. all the kind of data that should compress very well. You might be able
to reduce the physical table size by 50% or even more this way (the
compression level is actually tunable to some extent, at the expense of
performance of course).


Best regards,



MySQL Consulting Services

PSCE | http://www.psce.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20121010/88bebe3d/attachment.htm>

More information about the rt-users mailing list