Reducing Redundant I/O-opracowanie

Nasza ocena:

Wyświetleń: 504
Komentarze: 0

Pobierz ten dokument za darmo

Podgląd dokumentu
Reducing Redundant I/O-opracowanie - strona 1

Fragment notatki:

Reducing Redundant I/O
InnoDB has a number of settings that let you choose the balance between high reliability
in case of a crash, and the amount of I/O overhead during high write workloads. For
example, consider setting the configuration options innodb_doublewrite=0 [1752] and
innodb_flush_log_at_trx_commit=2 [1755]. Measure the performance with different settings
for the innodb_flush_method [1756] option. If the binary log is not turned on for the server, use the
setting innodb_support_xa=0 [1784].
For other ways to reduce or tune I/O for table operations, see Section 8.5.7, “Optimizing InnoDB Disk
... zobacz całą notatkę

Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz