I just dropped a rather large MyISAM table (~4 gb); it was 350k rows with about 11k of data per row. However, when I run
df -h on my database server, I am still at 100% disk usage, so much so that I get
Error 28 (out of disk space) when I try to do pretty much anything with my database.
I have heard that due to the way that InnoDB manages tables, you have to do some extra work to reclaim space in certain situations after doing deletes/drops; however I did not think this was the case with MyISAM.
I have read that in some situations, after doing a massive delete from a table, optimizing the table can help free space, however since I have dropped the table, that is not an option.
What am I missing? What can I do to free the space?
I am using Centos 6.4 Final with MySql 5.5.25
EDIT: I learned what the problem was - Our servers are monitored by our hosting provider, and due to this, the result of
df is not live, but rather reflects an infrequent snapshot of our server taken by the monitor. its insanely annoying.