… results when we have a slow fsync (write-back cache is disabled), innodb_flush_log_at_trx_commit=1 and sync_binlog=1… see, enabling binary logs with system without writeback cache impacts performance significantly. And the similar with writeback cache enabled thread trx=1, No binlog…
Comment: How to decrease InnoDB shutdown times
April 15, 2009 By 20 Comments
… that makes this faster. It is one thing to ask InnoDB to lower the percentage of dirty buffers, it is another… use include innodb_io_capacity, more background IO threads and a few others. Writes to files in the OS buffer cache are fast. Writes may be slow when: * using innodb_flush_method=O_DIRECT * disabling SATA writeback cache * not using a HW RAID disk cache…
