Make MySQL faster – innodb_flush_log_at_trx_commit=2

    • Official Post

    Discussion of article Make MySQL faster – innodb_flush_log_at_trx_commit=2:

    MySQL 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.

    Hola Hello ஹலோ Halo привет Hallo Salut Ciao Olá 你好 Γεια σας もしもし Pozdravljeni สวัสดี Habari ਹੈਲੋ Salve прывітанне