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/
-------- Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
