Slow inserts/restore from backup

[Vladimir Ch]

I created dump in mysql 5.6 and try to restore to mysql 8.0 and the speed of the restore is lower in 7-10 times than restore in mysql 5.6. I tested on Linux and FreeBSD on the same hardware.

This options doesn't helps:

skip-log-bin
ssl=0
innodb_undo_log_truncate=off
innodb_doublewrite=0
innodb-flush-method = O_DSYNC or O_DIRECT there is no difference
transaction_isolation = READ-COMMITTED - any value doesn't matter

Other innodb settings:

# INNODB #
innodb-flush-method = O_DSYNC
innodb-log-files-in-group = 3
innodb-log-file-size = 256M
innodb-flush-log-at-trx-commit = 0
innodb-file-per-table = 1
innodb-buffer-pool-size = 12G
innodb_data_file_path = ibdata1:128M:autoextend
innodb_flush_neighbors = 0
innodb_write_io_threads = 32
innodb_read_io_threads = 32
innodb_thread_concurrency = 32