MySQL Forums
Forum List  »  InnoDB

Slow inserts/restore from backup
Posted by: Vladimir Ch
Date: October 02, 2018 02:55AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Slow inserts/restore from backup
30
October 02, 2018 02:55AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.