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
