mysql dump 文件怎么打开_mysqldump | mysql会产生“太多打开的文件”的错误。为什么？...

据报道，mysqldump会导致大型数据库出错(1，2，3)。来自MySQL Bugs的解释和解决方法：

[3 Feb 2007 22:00] Sergei Golubchik

This is not really a bug.

mysqldump by default has --lock-tables enabled, which means it tries to lock all tables to

be dumped before starting the dump. And doing LOCK TABLES t1, t2, ... for really big

number of tables will inevitably exhaust all available file descriptors, as LOCK needs all

tables to be opened.

Workarounds: --skip-lock-tables will disable such a locking completely. Alternatively,

--lock-all-tables will make mysqldump to use FLUSH TABLES WITH READ LOCK which locks all

tables in all databases (without opening them). In this case mysqldump will automatically

disable --lock-tables because it makes no sense when --lock-all-tables is used.

编辑：请在下面的评论中查看Dave对InnoDB的解决方法。