Decrease size of DataBase

Moderator: crythias

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

Decrease size of DataBase

Post by zionlook » 10 Feb 2017, 16:07

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
OTRS guru
Posts: 4795
Joined: 13 Mar 2011, 09:54
OTRS Version?: 3.3.x
Company: Perl-Services.de
Contact:

Re: Decrease size of DataBase

Post by reneeb » 10 Feb 2017, 16:13

There's a script to move attachments from database to the filesystem...
Perl / OTRS development: http://perl-services.de
Free OTRS add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de

zionlook
OTRS newbie
Posts: 41
Joined: 27 May 2014, 16:04
OTRS Version?: 3.5.5

Re: Decrease size of DataBase

Post by zionlook » 10 Feb 2017, 16:14

reneeb wrote:There's a script to move attachments from database to the filesystem...
Where ?

reneeb
OTRS guru
Posts: 4795
Joined: 13 Mar 2011, 09:54
OTRS Version?: 3.3.x
Company: Perl-Services.de
Contact:

Re: Decrease size of DataBase

Post by reneeb » 10 Feb 2017, 16:51

perl bin/otrs.Console.pl Admin::Article::StorageSwitch
Perl / OTRS development: http://perl-services.de
Free OTRS add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de

zionlook
OTRS newbie
Posts: 41
Joined: 27 May 2014, 16:04
OTRS Version?: 3.5.5

Re: Decrease size of DataBase

Post by zionlook » 10 Feb 2017, 16:56

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
Moderator
Posts: 14612
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: Decrease size of DataBase

Post by jojo » 10 Feb 2017, 17:05

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™ 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 :: Share your ideas

Post Reply