mysql /etc/my.cnf


innodb_buffer_pool_size = 12G
# 60% - 70% of your RAM size
innodb_log_buffer_size = 16M
# 16M or 32M
innodb_log_file_size = 3G
# 25% of buffer pool size
innodb_write_io_threads = 32
# 32 based on core and drive count, 64 is maximum
innodb_flush_log_at_trx_commit = 0