Cacher is the code snippet organizer for pro developers

vim /etc/mysql/percona-server.conf.d

innodb_buffer_pool_size = 4G
innodb_log_buffer_size = 256M
innodb_log_file_size = 1G
innodb_write_io_threads = 16
innodb_flush_log_at_trx_commit = 0


Restart mysql like this

service mysql restart --innodb-doublewrite=0
This disables the InnoDB Double Write Buffer

Import your data. When done, restart mysql normally

service mysql restart
This reenables the InnoDB Double Write Buffer