Re: [rt-users] Large Attachments Table

2012-10-11 Thread k...@rice.edu
On Thu, Oct 11, 2012 at 08:48:36AM +0330, shayne.al...@gmail.com wrote: Dear Ken; I will like that branch... and hope it to an alive branch :-/ tnx I believe that that branch was for a customer and was never released. You would need to engage Best Practical. Cheers, Ken Final RT

Re: [rt-users] Large Attachments Table

2012-10-11 Thread shayne.al...@gmail.com
Dears; I am thinking about a better backend for 'attachments' to be stored on, instead on Mysql and InnoDB engine. is there any try out to force things like couchDBhttp://couchdb.apache.org/into RT? On Thu, Oct 11, 2012 at 4:16 PM, k...@rice.edu k...@rice.edu wrote: On Thu, Oct 11, 2012 at

Re: [rt-users] Large Attachments Table

2012-10-11 Thread Thomas Sibley
On 10/11/2012 07:32 PM, shayne.al...@gmail.com wrote: Dears; I am thinking about a better backend for 'attachments' to be stored on, instead on Mysql and InnoDB engine. is there any try out to force things like couchDB http://couchdb.apache.org/ into RT? CouchDB is primarily a document

[rt-users] Large Attachments Table

2012-10-10 Thread shayne.al...@gmail.com
Dears; I have been face with a problem... after 3 years, out attachments table has been grown over 300GB in size and it's about 15 Million of records. for performance tuning I Ihad changes it's Table Engine into InnoDB and configured MySQL as file_peer_table with Dynamic Row format to bring out

Re: [rt-users] Large Attachments Table

2012-10-10 Thread k...@rice.edu
On Wed, Oct 10, 2012 at 10:36:22PM +0330, shayne.al...@gmail.com wrote: Dears; I have been face with a problem... after 3 years, out attachments table has been grown over 300GB in size and it's about 15 Million of records. for performance tuning I Ihad changes it's Table Engine into InnoDB

Re: [rt-users] Large Attachments Table

2012-10-10 Thread 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

Re: [rt-users] Large Attachments Table

2012-10-10 Thread shayne.al...@gmail.com
Dear Ke; 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. :-) On Wed, Oct 10, 2012 at 10:54 PM, k...@rice.edu k...@rice.edu wrote: On Wed, Oct 10,

Re: [rt-users] Large Attachments Table

2012-10-10 Thread shayne.al...@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