innodb_flush_log_at_trx_commit 参数解释:
0(延迟写,实时刷): log_buff --每隔1秒--> log_file —实时刷—> disk
1(每次事务提交时):
log_buff
—
实时写
—>
log_file
—
实时刷
—> disk
2(实时写,延迟刷): log_buff —实时—> log_file --每隔1秒--> disk
===
首先需要大致了解一下mysql日志操作步骤:
log_buff
---
mysql写 (write)
--->
log_file
---
OS刷新 (flush)
---> disk
===
set GLOBAL innodb_flush_log_at_trx_commit = 0