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. ** Attachment added: "innodb_status_aug29.txt" https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1789343/+attachment/5182013/+files/innodb_status_aug29.txt -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1789343 Title: mysqldump in MySQL 5.7 running on Ubuntu 18.04 does not release memory To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1789343/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
