Make MySQL faster – innodb_flush_log_at_trx_commit=2

  • 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 прывітанне

  • Multimedia

    Changed the title of the thread from “Make MySQL faster — innodb_flush_log_at_trx_commit=2” to “Make MySQL faster – innodb_flush_log_at_trx_commit=2”.