Ubuntu
mysql-5.7 package

  1. Bug #1789343
  2. Comment #2

Comment 2 for bug 1789343

Revision history for this message
Prakyath Raj (prakyathr) wrote :

Command run to take backup of databases:

for db in $(mysql -e 'show databases;' | grep "DB_PREFIX"); do mysqldump --no-tablespaces --single-transaction $db > "$db_bk.sql"; done

I have added "--no-tablespaces" argument to avoid slowness and load during backup which seemed related to bug https://bugs.launchpad.net/percona-server/+bug/1589334 .

I have attached the output of "SHOW ENGINE INNODB STATUS" query when taking backup.