For less than 8 month otrs database grew up to 17 GB.
'article_plain' table has 8900 MB in size.
Next one is 'article_attachment' table - 6400 MB.
All other tables are less than 300 MB in size.
After inspecting OTRS's source code I didn't find intensive use of 'article_plain' table.
This topic approve my guess:
viewtopic.php?t=19918
It seems if I will delete all records from this table I will not be able to switch article storage only.
That looks fine for me. But I would like to have backup plan.
Is there any tools which can regenerate 'article_plain' from 'article' and 'article_attachment' tables?
Question about article_plain table.
Moderator: crythias
-
root
- Administrator
- Posts: 4253
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Question about article_plain table.
I don't know any tools. I still recommend to keep this table as designed. To reduce your database size you could switch ArticleStorage from DB to FS.
But the disk usage won't be affected.
But the disk usage won't be affected.
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 ?