Apparently, if you have too many entries in an InnoDB table (say about 36 megarecords), you can't clear the table with a simple "DELETE FROM table" statement. At least under the default configuration, it seems like MySQL will run out of entries in its lock table. It seems silly. I ended up dropping the table and recreating it instead. It actually took less time to drop the table than it did to fail to delete all the entries from it.
Published by
XPostcurses
