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: Peter Brawley
Date: May 14, 2021 11:42AM

--opt is on by default (https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_opt), it sets ...

--add-drop-table
--add-locks
--create-options
--disable-keys
--extended-insert
--lock-tables
--quick
--set-charset

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 ？

754

wenchao wenchao

May 14, 2021 02:24AM

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

409

Peter Brawley

May 14, 2021 11:42AM

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

373

wenchao wenchao

May 16, 2021 08:58PM

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

349

Peter Brawley

May 17, 2021 09:38AM

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

344

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.