I want to drop a 99G mysql table A, table A is useless now, Is it ok to execute the cmd 'drop table A'.I wish no effect on other table's operations.

1 Answers

Bill Karwin On Best Solutions

Occasionally dropping a large table can lock the InnoDB buffer pool for some time, while it purges pages for that table.

For this reason, in my company when we "drop" a table, we really just rename it, and move it to another schema. We leave it alone for 7 days, to allow queries against other tables to gradually evict the table's pages from the buffer pool. Then we drop the useless table.

We do this on tables much larger than yours, sometimes up to 10x larger.

If your table has already been unused for some days, you can probably just drop it now.