Do I need to manually rebuild a innodb table with massive deletes on MYSQL?

Question

I am currently deleting 9 million rows of a table with 11 million incrementally by 200,000 rows per run.

Will I need to manually rebuild the table and indexes or does this happen automatically after every delete?

Answer 1

Yes, you have to manually rebuild the table, you can do so like this:

ALTER TABLE database.table ENGINE=InnoDB;