Attachments table in mysql

Hi,

My Attachments table for rt2 in mysql is near 1.9Go.

What is the best solution to reduce the size only of this table without
affecting the rest of the rt system ?

Thanks,

Cyrille.

My Attachments table for rt2 in mysql is near 1.9Go.

What is the best solution to reduce the size only of this table
without affecting the rest of the rt system ?

Have you looked at the pack_isam and myisampack commands that come as
part of your mysql install?

(darren)

(1) Everything depends.
(2) Nothing is always.
(3) Everything is sometimes.

Hum… if I use myisampack this table will be in read only…

  • After packing, the table is read-only. This is generally intended
    (such as when accessing packed tables on a CD). Also allowing writes to
    a packed table is on our TODO list but with low priority.

Someone can advise me for another solution ?

Thanks,

Cyrille.

darren chamberlain wrote: