We have a MyISAM Table in our database which has around 97 Gb worth of data with resulted in 95% disk utilization. Due to this we started clearing the data from the table by deleting the rows but this also did not result in clearing the space.
So we read about firing the Optimize table command, but due to the lack of space the command was interrupted which resulted in the table being corrupted.
Now my question is, if we drop the corrupted table will it free up my disk space? Also will the drop query require a significant amount of space to execute like optimize query did?