/etc/mysql/mysql.conf.d/mysqld.cnf
skip_log_bin = 1
innodb_buffer_pool_size = 6G
innodb_log_buffer_size = 1G
innodb_log_file_size = 2G
innodb_write_io_threads = 28
innodb_flush_log_at_trx_commit = 0
innodb_fast_shutdown = 0
innodb_file_per_table = 1
https://dba.stackexchange.com/questions/87692/flush-clean-mysql-ib-logfile0-ib-logfile1
mysqladmin shutdown
cd /var/lib/mysql
rm -f ib_logfile*
service mysql start