25
MySQL 这么成熟的数据库，为什么用 mysqldump 老是要锁表，生产环境直接崩溃
source link: https://www.v2ex.com/t/604269
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
程序员 - @kisshere - MySQL5.7 版本，一张 800 万行的 MyISAM 表，准备每天定时备份，导出 SQL 至备份盘。因为是生产环境，肯定不能锁表，那样业务全都被锁死了，于是尝试各种方法：```mysql
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK