Innodb_Flush_Log_At_Trx_Commit 0
Innodb_Flush_Log_At_Trx_Commit 0 . However, after doing so, i am still seeing mysqld writing a lot of data to disk, and it is not clear why. It determines the method innodb uses to flush its data and log files. 一张思维导图纵观MySQL数据安全体系 运维派 from www.yunweipai.com I am a little confused. The default setting of 1 means that changes are. Take a peek in log/log0log.c and trx/trx0trx.c, specifically trx_commit_off_kernel() and srv_sync_log_buffer_in_background().