[rt-users] Too Many Attachments's file

[Kenneth Marshall]

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
>