We have two MySQL tables, one is InnoDB and the other is MyISAM. If I execute a chunk of inserts in a single transaction on both tables and the power fails in the middle, what will be the status?
What will happen to the newly inserted data on the InnoDB and MyISAM tables?