Daniel-Doggy
Verified User
- Joined
- Nov 16, 2019
- Messages
- 471
Hello everyone,
On my DirectAdmin server I have a really large database.
There are two tables in particular that causes problems for me as with these tables are that they are 50 GB each when stored uncompressed. (And the server only has 150 GB of storage.)
So in the database these two tables are configured to be a compressed tables and only take up 8 GB combined. (Data has a lot of replica data so highly compressible.)
Now the two tables do not really create a problem as the database normally only takes up 8GB total due to these tables being configured to be compressed.
But when I update MySQL via CustomBuilds I start to run into the out of space error as CustomBuilds dumps the databases raw and not compressed.
In an ideal world I would like to continue to use the dump before update setting as I think it is a good safety to have. (And also since it is turned on by default.)
But I have no idea how to configure CustomBuilds to dump the databases as a compressed dump.
Does anyone know if this is possible and if so how?
Many thanks in advance
On my DirectAdmin server I have a really large database.
There are two tables in particular that causes problems for me as with these tables are that they are 50 GB each when stored uncompressed. (And the server only has 150 GB of storage.)
So in the database these two tables are configured to be a compressed tables and only take up 8 GB combined. (Data has a lot of replica data so highly compressible.)
Now the two tables do not really create a problem as the database normally only takes up 8GB total due to these tables being configured to be compressed.
But when I update MySQL via CustomBuilds I start to run into the out of space error as CustomBuilds dumps the databases raw and not compressed.
In an ideal world I would like to continue to use the dump before update setting as I think it is a good safety to have. (And also since it is turned on by default.)
But I have no idea how to configure CustomBuilds to dump the databases as a compressed dump.
Does anyone know if this is possible and if so how?
Many thanks in advance