Too Many Attachments's file


#1

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


#2

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,
KenOn 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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


#3

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 :