add innodb_flush_log_at_trx_commit setting to .my.cnf