innodb_flush_log_at_trx_commit

Controls the balance between strict ACID compliance for commit operations and higher performance that is possible when commit-related I/O operations are rearranged and done in batches. You can achieve better performance by changing the default value but then you can lose transactions in a crash.

控制二者的平衡--提交操作遵守严格ACID特性和相关提交操作被重新排列并分批完成的高性能的可能性。您可以通过更改默认值来获得更好的性能，但是在崩溃时可能会丢失事务。

• The default setting of 1 is required for full ACID compliance. Logs are written and flushed to disk at each transaction commit.

默认值是1，完成遵守ACID特性。每次事务提交时，日志都会写入并刷新到磁盘。

• With a setting of 0, logs are written and flushed to disk once per second. Transactions for which
logs have not been flushed can be lost in a crash.

设置为0时，日志每秒写入并刷新到磁盘一次。未刷新日志的事务可能会在崩溃中丢失。

• With a setting of 2, logs are written after each transaction commit and flushed to disk once per
second. Transactions for which logs have no