Decrease size of DataBase

Moderator: crythias

Post Reply
zionlook
Znuny newbie
Posts: 41
Joined: 27 May 2014, 16:04
Znuny Version: 3.5.5

Decrease size of DataBase

Post by zionlook »

Hello, please tell me how to decrease size of OTRS database.
Currently the database holds 136 GB of which occupy most of the tables:
1) article_attachment (62 GB) - which information contain this table ?
2) article_plain (64 GB) - which information contain this table ?

And the most important question:
1) Can I safely clean this tables (article_attachment and article_plain) and what I lose?
2) Other option how to decrease the size of database ?
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: Decrease size of DataBase

Post by reneeb »

There's a script to move attachments from database to the filesystem...
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
zionlook
Znuny newbie
Posts: 41
Joined: 27 May 2014, 16:04
Znuny Version: 3.5.5

Re: Decrease size of DataBase

Post by zionlook »

reneeb wrote:There's a script to move attachments from database to the filesystem...
Where ?
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: Decrease size of DataBase

Post by reneeb »

perl bin/otrs.Console.pl Admin::Article::StorageSwitch
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
zionlook
Znuny newbie
Posts: 41
Joined: 27 May 2014, 16:04
Znuny Version: 3.5.5

Re: Decrease size of DataBase

Post by zionlook »

Hello I read about this solution, if I will activate this parameter and start to storage in FileSystem, it's mean that all OTRS users must have access into WebServer with OTRS-user role.
It's not possible for me.

Currently the database holds 136 GB of which occupy most of the tables:
1) article_attachment (62 GB) - which information contain this table ?
2) article_plain (64 GB) - which information contain this table ?

And the most important question:
1) Can I safely clean this tables (article_attachment and article_plain) and what I lose?
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Decrease size of DataBase

Post by jojo »

OTRS Customers and Agents will still access the webinterface to retreive and store data, so will not need permission on the file system
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Post Reply