Question
Disk space - not being released?
My MySQL database stopped responding with the following “Got error 28 from storage engine”
df -kh
showed that disk space use was 100%
I managed to release some reserved space with the command
tune2fs -m 0 /dev/vda1
I then deleted substantial number of rows from numerous tables and on each table ran ‘OPTIMISED TABLE {tableName}’
If I then run a mysql query to calculate the size of the DBs < 13GB
But df -kh still shows 18GB
Filesystem Size Used Avail Use% Mounted on
/dev/vda1 20G 18G 2.2G 89% /
1) which is correct? I reckon mySQL count is. So how do I release the space?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×