Since version 8.0.21MySQL 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.21The 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 |
![]() |