Hi,
I would need your help.
my otrs server has disk full. I have seen that the database has "article_attachment" and "article_plain" of over 200Gb. Do you think it is possible to reduce them?
I don't need attachments, can I delete them directly from my phpmyadmin in "article_attachment"?
What can I do in "article_plain"?
Best regards,
PP
Database
Moderator: crythias
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Database
Hi,
It depends on your database configuration to free some of this space. If the table type is InnoDB you could delete old tickets and try to reclaim that space. But this is done by copy the remaining data into a temporary table. You need at least the same amount of free space what the size of the table is. Any chance to add disk space to the system?
- Roy
It depends on your database configuration to free some of this space. If the table type is InnoDB you could delete old tickets and try to reclaim that space. But this is done by copy the remaining data into a temporary table. You need at least the same amount of free space what the size of the table is. Any chance to add disk space to the system?
- 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: 44
- Joined: 19 Sep 2017, 11:48
- Znuny Version: 5.0.16
Re: Database
Hi,
thanks for your advice.
I thought I would delete attachments without problems by deleting them from "article_attachment".
My table is InnoDB and unfortunately I cannot expand the space because the server is cloud.
Can't I delete attachments?
PP
thanks for your advice.
I thought I would delete attachments without problems by deleting them from "article_attachment".
My table is InnoDB and unfortunately I cannot expand the space because the server is cloud.
Can't I delete attachments?
PP
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Database
Hi,
Deleting rows from a table with the type InnoDB does not free the space immediately.
I recommend consulting a Linux/Database specialist.
- Roy
Deleting rows from a table with the type InnoDB does not free the space immediately.
Keeping this in mind you need the setting innodb_file_per_table already active and have enough space for the copy process.But, if you are using innodb_file_per_table then you can reclaim the space by running OPTIMIZE TABLE on that table. OPTIMIZE TABLE will create a new identical empty table. Then it will copy row by row data from the old table to the new one. In this process, a new .ibd tablespace will be created and space will be reclaimed.
I recommend consulting a Linux/Database specialist.
- 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: 44
- Joined: 19 Sep 2017, 11:48
- Znuny Version: 5.0.16
Re: Database
I will do what you advise me.
Thank you so much!
PP
Thank you so much!
PP