Ticket::StorageModule DB / FS

Moderator: crythias

Post Reply
Volverine87
Znuny newbie
Posts: 40
Joined: 14 Nov 2017, 15:19
Znuny Version: OTRS 5.0.20
Real Name: Rafal
Company: UKWSL

Ticket::StorageModule DB / FS

Post by Volverine87 »

Hi All,

Not sure if anyone done this before but I'm concern about consequence of switching attachment from DB to FS my business receive a lot of attachment and some of weight over 4mb each.
after 6 months running my database size increase to 30gb. I rather keep it separate as its slowing down backups and consume loads of space.
Is there any downsize of changing it in live environment?
IS search function will be affected in any way?
Will I be able to access attachment from DB and FS at same time after change or I will lose it?
Any other possible downsize?
wurzel
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: Ticket::StorageModule DB / FS

Post by wurzel »

Hi,

everything you ask for, is here
http://doc.otrs.com/doc/manual/admin/st ... rs-storage

Florian
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
Volverine87
Znuny newbie
Posts: 40
Joined: 14 Nov 2017, 15:19
Znuny Version: OTRS 5.0.20
Real Name: Rafal
Company: UKWSL

Re: Ticket::StorageModule DB / FS

Post by Volverine87 »

Thank you Florian

Thats answer all my question :)
I will run this on test see how long it will take.
Topic can be closed now.

Rafael
Volverine87
Znuny newbie
Posts: 40
Joined: 14 Nov 2017, 15:19
Znuny Version: OTRS 5.0.20
Real Name: Rafal
Company: UKWSL

Re: Ticket::StorageModule DB / FS

Post by Volverine87 »

Referring back to main subject,
all article move from DB to FS went smooth, but i believe they are duplicated now as double amount of space on server been used?
Any idea can you delete the article from DB if yes how? to not destroy the connection
I already restarted server and delete otrs cache, rebuilded config nothing help.

Thanks for support
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Ticket::StorageModule DB / FS

Post by root »

Hi,

I suggest you use InnoDB engine for the OTRS tables. Depending on the setting of innodb_file_per_table a simple

Code: Select all

ALTER TABLE tablename ENGINE=InnoDB
frees the memory. If not I recommend asking your DBA.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
Volverine87
Znuny newbie
Posts: 40
Joined: 14 Nov 2017, 15:19
Znuny Version: OTRS 5.0.20
Real Name: Rafal
Company: UKWSL

Re: Ticket::StorageModule DB / FS

Post by Volverine87 »

Hi,
So i done swap article from DB to FS on live system last night,
changed setting first in sysconfig:


I run later below command as otrs user:
/opt/otrs/bin/otrs.Console.pl Admin::Article::StorageSwitch --target ArticleStorageFS

but Im sure article left in DB as i lost 33GB since last night.
I though this suppose to move article from 1 place to another not copied them over?
option for Checkallbackends is switch off.
Did i missed anything in the process?
I would like to remove them article from mysql DB as if you can see 33GB database is huge, creating trouble when you want to backup it.
I should be below 1GB if article will disappear.
I'm just learning sql DB so apologise for dummy question.
anything can be change from sysconfig? or its only manual removal of table in DB?
You do not have the required permissions to view the files attached to this post.
Post Reply