[rt-users] Large Attachments Table

[Maciej Dobrzanski]

Ali,

 

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,

Maciek

 

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>