parameters to change, temporarily – while recovering logical dump taken from master on replication slave:
- skip-log-bin
- innodb_doublewrite=off
- innodb_flush_log_at_trx_commit=0 or 2
- innodb_flush_method=nosync
- sync_binlog=0
- innodb_buffer_pool_size=20G # very much depends on the type of data
- max_allowed_packet=1024M# very much depends on the type of data/dump
all together those minimize number of disk operations and significantly speed up restoration of data.