We have a mysql database with a size of 2 TB, in which we have for to five big tables ranging from 110GB to 350GB. When we try to drop these tables the mysql goes to the defunct mode and hangs in that state for a long time. Is there a solution to drop these tables without mysql hanging. We have a machine which has a memory of 122GB and swap of 60 GB. We use an InnoDB Engine Hope the information suffices kindly help us with this issue.

  • Table engine? InnoDB or MyISAM? – masegaloeh Dec 4 '14 at 6:16
  • The table engine is InnoDB – Prashanth Ganesh Dec 4 '14 at 6:20
  • Might be better addressed in DBA SE. – mdpc Dec 4 '14 at 6:42

You can try if your MySQL server supports and/or behaves better in your case with setting innodb_lazy_drop_table=1 in your my.cnf file.

This option works for older MySQL versions, my understanding is that the option got removed in the newer versions and the innodb_lazy_drop_table behavior was made the default one.

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