I am using amazon rds mysql 5.6 master instance and 4 slaves. there is big table with 800 GIB size that i want to drop it for releasing space. But when i execute drop command, the server entering to "freeze mode" and cant execute any kind of commands.
similar issue : https://bugs.mysql.com/bug.php?id=44757
I need to remove it from production rds.
- there is no transactions on this table
- innodb_file_per_table = ON
I though about Deleting rows in chunks for not create big lag for slaves and then (optional optimize) drop the table.