Discussion of article Make MySQL faster – innodb_flush_log_at_trx_commit=2:
ZitatMySQL optimization – Increase the speed of disk accesses of the transaction log by caching the commits in the cache.
Thus, the data is written to the hard disk with a 1 second delay, which is hugely accumulated with thousands of accesses.
The InnoDB value innodb_flush_log_at_trx_commit = 1 is changed to 2.