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 ?
Decrease size of DataBase
Moderator: crythias
-
- 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
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
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Re: Decrease size of DataBase
Where ?reneeb wrote:There's a script to move attachments from database to the filesystem...
-
- 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
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
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Re: Decrease size of DataBase
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?
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?
Re: Decrease size of DataBase
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com