mysql - 升级到mysql8后Mysqldump变慢(Mysqldump slow after upgrade to mysql8)

Question

My earlier verison mysql 5.7.20, all databases structure backup takes 10 minutes.

(我的早期版本是mysql 5.7.20，所有数据库结构备份需要10分钟。)

After upgrade to mysql 8.0.11 structure backups take 51 hours.

(升级到mysql 8.0.11后，结构备份需要51个小时。)

Its huge time for structure backup.

(大量时间用于结构备份。)

Can anyone help what i missing?

(任何人都可以帮助我所缺少的吗？)

  ask by Swati Desai translate from so

Answer 1

If you are not using tablespaces, it might help to use mysqldump's option "--no-tablespaces", that will speed it up considerably if you have many tables.

(如果您不使用表空间，则使用mysqldump的选项“ --no-tablespaces”可能会有所帮助，如果您有很多表，它将大大加快速度。)

See also: https://bugs.launchpad.net/percona-server/+bug/1589334/comments/2

(另请参阅： https : //bugs.launchpad.net/percona-server/+bug/1589334/comments/2)