delete all records in a table takes forever -- Anyone know why?
I have a table called table_a that has 1 record in it. I delete that record, which because of foreign keys (the tables are type InnoDB) will cause the records in 8 other tables to be deleted.
The 8 other tables have a maximum of 200,000 records in them. 2 of them have that many while the remaining have < 5,000 records.
Currently, deleting that 1 record has taken hours upon hours with no end in site. Does anyone know why in the world this would take so long? Is there any way to speed it up (maybe a config setting I am missing or something)?