I'm working on an existing database, whose structure I can't change. I need to clear (empty) several InnoDB tables (that I can't TRUNCATE
due to references in other tables' FK constraints), but I have no interest in any recovery - i.e. if a crash occurs during those operations, I'll clear those tables again on the first occasion.
Can I tell MySQL to not create the redo log about those queries?
I am concerned about speed, as the first thing that can be noted is the time the operation takes. But, space too, I guess. Tables can store 20k-1M rows depending on the specific installation (same schema structure, different usages). I am operating on a bunch of table whose data are related (i.e. products, products_images, products_votes, ...), so FK are not an issue because all data will be deleted consistently without the need of any additional check.