MySQL Forums
Forum List  »  InnoDB

Re: Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ?
Posted by: wenchao wenchao
Date: May 16, 2021 08:58PM

Thank you very much!

Yes, I have now added the --skip-opt option to turn off the default lock table. Now when the mysqldump command is executed, the table is not locked. Will the addition of --skip-opt cause data inconsistency? , Will the method "START TRANSACTION" be added by default to ensure data consistency?

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.