does mysql undo changes if you kill thread?
i ran a delete rows query. i开发者_开发问答t was taking too long so i killed the thread from administration. did it undo the changes to the table/?
InnoDB
will rollback the transaction.
MyISAM
will leave the changes and possible even the table in corrupt state.
精彩评论