Re: Delete attachments

Olivier Macchioni <[email protected]> Tue, 17 Jul 2018 15:40:37 +0200
Newsgroups	gmane.comp.otrs.user
Message-ID	<[email protected]>
+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 <[email protected]> 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 <[email protected] <mailto:[email protected]>> 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/ <http://otrs.org/>
>> Archive: http://lists.otrs.org/pipermail/otrs <http://lists.otrs.org/pipermail/otrs>
>> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs <http://lists.otrs.org/mailman/listinfo/otrs>
>> 
>> 
>> 
>> --
>> Diego Chacón Rojas
>> * E-mail: [email protected] <mailto:[email protected]>
>> 
>> 
>> ---------------------------------------------------------------------
>> OTRS mailing list: otrs - Webpage: http://otrs.org/ <http://otrs.org/>
>> Archive: http://lists.otrs.org/pipermail/otrs <http://lists.otrs.org/pipermail/otrs>
>> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs <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

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
signature.asc (application/pgp-signature, 842 B)