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.



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

Last updated 3 Dec 2020

Return to the Artful MySQL Tips page