+1 here...

We're running OTRS on Linux - we actually move the directories to a loopback BTRFS filesystem, one mount point per year. BTRFS supports compression - we save approx 50% of the space, plus a large numbers of inodes.

We run this process yearly, for all the tickets of year (current year - 2), which are usually not touched any more anyways.


On 17 Jul 2018, at 07:56, PREF31 OTRS <pref-otrs@haute-garonne.gouv.fr> wrote:

Thanks

Diego Chacón a écrit :
No.

My advice, move attachments from database to filesystem.
OTRS create a folder per year, compress old folders

On Wed, Jul 11, 2018 at 12:38 AM, PREF31 OTRS <pref-otrs@haute-garonne.gouv.fr> wrote:
Hi,

I have too many attachments on my database.

Can I delete oldest attachments directly on the hard drive?

I did a test and it seam correct but your views will help me.

Thanks and best regards.

Claude


Pour une administration exemplaire, préservons l'environnement.
N'imprimons que si nécessaire.
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs



--
Diego Chacón Rojas


---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs


Pour une administration exemplaire, préservons l'environnement.
N'imprimons que si nécessaire.
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs