Disk space - not being released?

September 28, 2017 107 views

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?

Be the first one to answer this question.