OTRS DB Size and Attachments

Moderator: crythias

Locked
msksharma
Znuny newbie
Posts: 91
Joined: 24 Mar 2014, 13:58
Znuny Version: 6.0.26
Real Name: Krishna M S
Company: Toradex AG

OTRS DB Size and Attachments

Post by msksharma »

Hi All,

We are running OTRS 6.0.26. Earlier we were using OTRS 3 and we migrated to 6 this year.

The attachments are stored in OTRS_HOME/var/article and the size is 58GB

I also see the size of DB under /var/lib/mysql which is 23 GB.

What i noticed is that the filesystem size has doubled from OTRS 3 to 6 upgrade. Is this something we can finetune?

Regards,
Krishna M S
zzz
Znuny superhero
Posts: 914
Joined: 15 Dec 2016, 15:13
Znuny Version: All
Real Name: Emin
Company: Efflux GmbH
Contact:

Re: OTRS DB Size and Attachments

Post by zzz »

Hello Krishna,

Your FS shouldn't double in size from an update.
Check if your combined databases are also ~23 GB (could be large logs, claimed space by InnoDB, or something else).

Best regards
Emin
Professional Znuny and OTRS services: efflux.de | efflux.de/en/

Free and premium add-ons: German | English
Locked