How to get rid of orphaned InnoDB temporary tables

If InnoDB or XtraDB in MySQL or MariaDB are interrupted while performing an ALTER TABLE, they’ll leave a temporary table sitting in your data directory. This thing will be taking up space, which is no good. If you’re usinginnodb-file-per-table, or…