1

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?

Improve this question
6
  • 1
    This probably might be more appropriate with the dba StackExchange. Stack Overflow is for programming questions.
    – ewokx
    Nov 6 at 8:56
  • Why not try it out and see what happens?
    – Nico Haase
    Nov 6 at 8:57
  • The topic might be too broad because there are cases where dropping table does not necessarily free up disk space. However, if you do mysql dump excluding the corrupted table that will work. Or just do full dump with specific option like --force - since mysqdump will stop if there's an error like "corrupt table", adding --force will "Continue even if an SQL error occurs during a table dump".
    – FanoFN
    Nov 6 at 9:18
  • @FanoFN So let me clear this up should we take the db dumb excluding the corrupted table, then remove the existing db and then import the db dump sql file??
    – Umang Pachaury
    Nov 6 at 9:30
  • Yes @UmangPachaury, so you'll have a new db without the corrupted data.
    – FanoFN
    Nov 6 at 23:10

1 Answer 1

Reset to default
2

Yes, dropping a MyISAM table does free up disk space.

Dropping a table does not use additional disk space.

Improve this answer
1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.