[rt-users] Large Attachments Table

[shayne.alone at gmail.com]

Dear Ken;
I will like that branch... and hope it to an alive branch :-/
tnx


Dear Maciek;
:-)
due the type if our attachments which are JPEG files, don't hope
compression to help me more! but I serious to test it ASAP.
it seems pretty to be able to compress Emails body on side DB engine.
tnx


On Wed, Oct 10, 2012 at 11:13 PM, Maciej Dobrzanski <
reg.bestpractical at posterus.com> wrote:

> 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
>
>


-- 
Regards,
Ali R. Taleghani
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20121011/0ff08b5c/attachment.htm>