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