mysqldump 之--single-transaction

最新推荐文章于 2021-02-01 18:40:17 发布

scan724

最新推荐文章于 2021-02-01 18:40:17 发布

阅读量1.3k

点赞数

分类专栏： Mysql

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/45308295

版权

Mysql 专栏收录该内容

90 篇文章 30 订阅 ¥39.90 ¥99.00

订阅专栏

本文详细介绍了mysqldump的--single-transaction选项，该选项能够为InnoDB存储引擎的表创建一致性快照，避免在备份过程中与其他并发操作冲突。在使用该选项时，需要注意不能同时执行ALTER TABLE, DROP TABLE, RENAME TABLE或TRUNCATE TABLE等语句，以确保备份的完整性和一致性。" 8838620,1355600,使用C#调用Win32 API进行GDI绘图,"['Windows开发', 'C#编程', '图形界面', 'API调用']

摘要由CSDN通过智能技术生成

mysqldump :
--single-transaction
Creates a consistent snapshot by dumping all tables in a
single transaction. Works ONLY for tables stored in
storage engines which support multiversioning (currently
only InnoDB does); the dump is NOT guaranteed to be
consistent for other storage engines. While a
--single-transaction dump is in process, to ensure a
valid dump file (correct table contents and binary log
position), no other connection should use the following
statements: ALTER TABLE, DROP TABLE, RENAME TABLE,

了解本专栏