Speed up dump imports

from the Artful MySQL Tips List


Since version 8.0.21

MySQL Shell has dump & load utilities that can achieve up up to 2.8GB/sec with logical dumps.

MySQL Shell Dump & Load part 1: Demo

MySQL Shell Dump & Load part 2: Benchmarks

MySQL Shell Dump & Load part 3: Load Dump

MySQL Shell Dump & Load part 4: Dump Instance & Schemas

Parallel ImportTable in MySQL Shell

Before version 8.0.21

The 5.7 manual says (http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#mysqldump-performance) "for large-scale backup and restore, a physical backup is more appropriate, to copy the data files in their original format that can be restored quickly", and recommends the MySQL Enterprise mysqlbackup utility.

http://dba.stackexchange.com/questions/13446/slow-load-speed-of-data-from-mysqldump

https://www.percona.com/blog/2018/02/22/restore-mysql-logical-backup-maximum-speed/

... for how to tweak imoorts of mysqldump backups.

Last updated 3 Dec 2020


Return to the Artful MySQL Tips page