Cleanup the DB from files

Moderator: crythias

Locked
vinc535
Znuny newbie
Posts: 13
Joined: 02 May 2013, 11:32
Znuny Version: 5.0.6
Real Name: Vincent
Company: N/A

Cleanup the DB from files

Post by vinc535 »

Dear all,

Do you have any ideas on how to clean up / light up the OTRS Database size?
I have now reached a Database file of 5,989,586,990 octet, meaning 5 Gb after 2 years.
I am pretty sure the e-mail attached files are the main cause of this big size.
Does anyone know how to remove all attached files in OTRS received or sent e-mails?

Thank you!
Vincent.
Top
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:
Contact crythias

Re: Cleanup the DB from files

Post by crythias »

Take a look at changing from DB to FS (filesystem) attachment storage.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Top
vinc535
Znuny newbie
Posts: 13
Joined: 02 May 2013, 11:32
Znuny Version: 5.0.6
Real Name: Vincent
Company: N/A

Re: Cleanup the DB from files

Post by vinc535 »

I've done this :

Under OTRS Admin page, Core::Ticket, Ticket::StorageModule, change it to ArticleStorageFS.
Then, in the Linux server, run this :
shell> cd /opt/otrs/
shell> bin/otrs.ArticleStorageSwitch.pl -s ArticleStorageDB -d ArticleStorageFS
shell> ./otrs.CleanUp.pl
shell> ./otrs.DeleteCache.pl

shell> mysql -u root -p otrs
optimize table ticket;
optimize table ticket_history;
optimize table article;
optimize table article_plain;
optimize table article_attachment;
optimize table article_flag;
quit

----
The good news now is that the ticketing seems to be faster.
The bad news is that the MYSQLDUMP file is still the same 5,9 Gb size. Any idea why?

Thank you!
Top
Locked

Return to “General”