/var/lib/mysql/otrs is taking up a lot of space on disk

Moderator: crythias

Locked
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

/var/lib/mysql/otrs is taking up a lot of space on disk

Post by aph »

My /var/lib/mysql/otrs directory has about 1.3GB of data on it, it is taking up the 80% or my var partition. As far as I can see there are no logfiles etc. that can be deleted but the directory seems to contain required system files acl.frm, acl.MYD. What can I do about it so that I don't run into space problems?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: /var/lib/mysql/otrs is taking up a lot of space on disk

Post by jojo »

enlarge disk (if LVM). Move to another server, get a managed system.

The directory contains the database, so don't ever delete anything from there!
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: /var/lib/mysql/otrs is taking up a lot of space on disk

Post by crythias »

Don't delete, but backup/myslqdump, stop mysql services, change database location in mysql configuration, copy folder structure, start mysql services.

This suggestion is untested by this author. Your data is your responsibility, and this suggestion is provided without warranty or support. Among other potential issues, including data loss, you may have permission issues on the folder structure. Read an appropriate manual on this option by someone you trust.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked