[rt-users] Too Many Attachments's file

[Patrick Lafontaine]

Yes it is possible, but it's not very easy. Tables are innodb so the way 
to do is to move the entire tablespace (unless you are using 
innodb_file_per_table). As a MySQL DBA, i do not recommend doing this if 
you are using MySQL 4.

In fact, i wished to solve the problem without modifying the MySQL 
Server structure. I make some test with an external PHP script I wrote. 
Briefly, it takes certain Attachments (PDF, Ms Word, JPG, etc..), store 
them in the filesystem and replace the content by a link. I don't really 
like this solution. I would like to have a built-in solution, but I 
don't know perl..

Patrick


Kenneth Marshall a écrit :
> Patrick,
>
> Does MySQL support tablespaces? You could move the attachments
> table to a tablespace on the "dedicated huge hard disk". If not,
> you may want to move to a different backend. I think that Oracle and
> PostgreSQL both will allow you to do this partitioning. Good luck.
>
> Cheers,
> Ken
>
> On Wed, Jun 11, 2008 at 04:03:17PM -0400, Patrick Lafontaine wrote:
>   
>> Hi everyone
>>
>> I use RT since 2004 and I never got any real problem. But now my MySQL 
>> database increase way too fast. The problem is that RT stores 
>> Attachments file into MySQL. My Attachments table is growing by 1Gb per 
>> month.
>>
>> I want to know if a module or any other procedure exist to store 
>> Attachment directly on the filesystem instead of MySQL. By storing them 
>> on filesystem, I could create a symlink to a dedicated huge hard disk. 
>> It will help MySQL a lot in at same time.
>>
>> Maybe someone got this problem and have a better solution ?
>>
>> Thanks for any comments/ideas/solutions
>>
>> Patrick
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>> Buy a copy at http://rtbook.bestpractical.com
>>
>>     
>
>
>