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.
You can try if your MySQL server supports and/or behaves better in your case with setting
innodb_lazy_drop_table=1 in your
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.