MySQL :: Re: Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ？

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

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?

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ？

620

wenchao wenchao

May 14, 2021 02:24AM

Re: Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ？

300

Peter Brawley

May 14, 2021 11:42AM

Re: Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ？

297

wenchao wenchao

May 16, 2021 08:58PM

Re: Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ？

280

Peter Brawley

May 17, 2021 09:38AM

Re: Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ？

263

wenchao wenchao

May 18, 2021 12:07AM

Sorry, you can't reply to this topic. It has been closed.

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.