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?
Ticket::StorageModule DB / FS
Moderator: crythias
-
- 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
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.
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.
-
- 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
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
Thats answer all my question
I will run this on test see how long it will take.
Topic can be closed now.
Rafael
-
- 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
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
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
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Ticket::StorageModule DB / FS
Hi,
I suggest you use InnoDB engine for the OTRS tables. Depending on the setting of innodb_file_per_table a simple frees the memory. If not I recommend asking your DBA.
- Roy
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
- 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 ?
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 ?
-
- 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
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?
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.