I have a 100G+ innodb table that needs to be dropped in a production environment. I am trying to do this without interruption to service.
The table is no longer being written to, and needs to be dropped to free up space. My MySQL version is 5.1.52.
What is the expected impact to performance while this table is being dropped? I was thinking of slowly shrinking it by deleting rows and then optimizing. However, optimize makes a copy of the table so it will be just as disk IO intensive, if not more.