We just now ran a delete query on one of our mysql tables having 54 MM rows. The query was supposed to delete around 40 MM records. It ran for about 2 hours and after that the table state has not changed. Doing
show table status is still showing the same number of rows as before running the delete query. The table engine is InnoDb.
The table is pretty much unusable now. Simple select queries are hanging on that table. Any idea what might have gone wrong ?