# InnoDB log flush once per second to increase speed
Add to my.cnf
innodb_flush_log_at_trx_commit = 0
Note This will cause MySQL to flush log once per second, and IF MySQL crashed, transactions of last second will be erased.
Reference:
Last Update 2016/10/14 17:32:06 +0900
