storage fs in file system
Hia ll, i have my otrs configured with the variable Ticket::StorageModule: to ArticleStorageFS to archive all attachments in a filesystem instead of in a database. It permits to me to work with a database with a "normal" size. The problem became with the number of files that otrs creates, i Have around 2,7 milion of files and 196 GB . The number of files is very high and now the backup takes more than 50 hours. For every ticket ( with out attach) the system creates 3 files : - file-1 - file-1.content_type - plain.txt for every attach the system adds 1 content_type file more and the attach. The text in the content type files is: Text/plain; charset = cp1252 or us-ascii Do you know how to reduce the number of files ? Thanks in advance
Any idea about how to solve this issue? _____ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of IT easyap Sent: lunes, 28 de junio de 2010 19:58 To: 'User questions and discussions about OTRS.' Subject: [otrs] storage fs in file system Hi all, i have my otrs configured with the variable Ticket::StorageModule: to ArticleStorageFS to archive all attachments in a filesystem instead of in a database. It permits to me to work with a database with a "normal" size. The problem became with the number of files that otrs creates, i Have around 2,7 milion of files and 196 GB . The number of files is very high and now the backup takes more than 50 hours. For every ticket ( with out attach) the system creates 3 files : - file-1 - file-1.content_type - plain.txt for every attach the system adds 1 content_type file more and the attach. The text in the content type files is: Text/plain; charset = cp1252 or us-ascii Do you know how to reduce the number of files ? Thanks in advance
Hi, On 06.07.2010, at 17:56, IT easyap wrote:
Any idea about how to solve this issue?
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of IT easyap Sent: lunes, 28 de junio de 2010 19:58 To: 'User questions and discussions about OTRS.' Subject: [otrs] storage fs in file system
Hi all, i have my otrs configured with the variable Ticket::StorageModule: to ArticleStorageFS to archive all attachments in a filesystem instead of in a database. It permits to me to work with a database with a “normal” size.
The problem became with the number of files that otrs creates, i Have around 2,7 milion of files and 196 GB . The number of files is very high and now the backup takes more than 50 hours.
For every ticket ( with out attach) the system creates 3 files :
- file-1 - file-1.content_type - plain.txt
for every attach the system adds 1 content_type file more and the attach.
The text in the content type files is:
Text/plain; charset = cp1252 or us-ascii
Do you know how to reduce the number of files ?
There is no out-of-the-box option to reduce the number of files. But I wonder why you backup everything in every backup run. Wouldn’t it make sense to use an incremental or differential backup method with that amount of data? You could actually run a backup-to-disk with multi-instance jobs and a weekly backup-to-tape full job… Freundliche Grüße / Kind regards Nils Leideck -- Nils Leideck Senior Consultant nils.leideck@leidex.net nils.leideck@otrs.com http://webint.cryptonode.de / a Fractal project
Hi all, i have my otrs configured with the variable Ticket::StorageModule: to ArticleStorageFS to archive all attachments in a filesystem instead of in a database. It permits to me to work with a database with a “normal” size.
The problem became with the number of files that otrs creates, i Have around 2,7 milion of files and 196 GB . The number of files is very high and now the backup takes more than 50 hours.
For every ticket ( with out attach) the system creates 3 files :
- file-1 - file-1.content_type - plain.txt
for every attach the system adds 1 content_type file more and the attach.
The text in the content type files is:
Text/plain; charset = cp1252 or us-ascii
Do you know how to reduce the number of files ?
On 06.07.10 22:53, Nils Leideck - ITSM wrote:
There is no out-of-the-box option to reduce the number of files.
or at least amount of data. I compressed all the plain.txt some time ago although it resulted to showing them as attachments. It would be nice if OTRS could (de)compress those files.
But I wonder why you backup everything in every backup run. Wouldn’t it make sense to use an incremental or differential backup method with that amount of data?
well, we do know that thing like incremental backup exists. However once in a while we all need to do full backup and the more data we have, the longer it takes. -- Matus UHLAR - fantomas, uhlar@fantomas.sk ; http://www.fantomas.sk/ Warning: I wish NOT to receive e-mail advertising to this address. Varovanie: na tuto adresu chcem NEDOSTAVAT akukolvek reklamnu postu. Windows found: (R)emove, (E)rase, (D)elete
Thanks for your response Matus, the problem isn´t the size of the files is the numer of files. To manage more than 2 million files is to slow for every backup systems, the time to analyze all file its almost the same for an incremental backup or for full backup. Our objective its to reduce the number of files. Thanks -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Matus UHLAR - fantomas Sent: miércoles, 07 de julio de 2010 12:59 To: otrs@otrs.org Subject: Re: [otrs] storage fs in file system
Hi all, i have my otrs configured with the variable Ticket::StorageModule: to ArticleStorageFS to archive all attachments in a filesystem instead of in a database. It permits to me to work with a database with a normal size.
The problem became with the number of files that otrs creates, i Have around 2,7 milion of files and 196 GB . The number of files is very high and now the backup takes more than 50 hours.
For every ticket ( with out attach) the system creates 3 files :
- file-1 - file-1.content_type - plain.txt
for every attach the system adds 1 content_type file more and the attach.
The text in the content type files is:
Text/plain; charset = cp1252 or us-ascii
Do you know how to reduce the number of files ?
On 06.07.10 22:53, Nils Leideck - ITSM wrote:
There is no out-of-the-box option to reduce the number of files.
or at least amount of data. I compressed all the plain.txt some time ago although it resulted to showing them as attachments. It would be nice if OTRS could (de)compress those files.
But I wonder why you backup everything in every backup run. Wouldnt it make sense to use an incremental or differential backup method with that amount of data?
well, we do know that thing like incremental backup exists. However once in a while we all need to do full backup and the more data we have, the longer it takes. -- Matus UHLAR - fantomas, uhlar@fantomas.sk ; http://www.fantomas.sk/ Warning: I wish NOT to receive e-mail advertising to this address. Varovanie: na tuto adresu chcem NEDOSTAVAT akukolvek reklamnu postu. Windows found: (R)emove, (E)rase, (D)elete --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
participants (3)
-
IT easyap -
Matus UHLAR - fantomas -
Nils Leideck - ITSM