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: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
