Reducing Redundant I/O-opracowanie

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
I/O”.
... zobacz całą notatkę