InnoDB System Variables Specifies whether to dynamically adjust the rate of flushing dirty pages in the  InnoDB  buffer pool based on the workload. Adjusting the flush rate dynamically is intended to avoid bursts of I/O activity. This setting is enabled by default. See Section 15.8.3.5, “Configuring Buffer Pool Flushing”  for more information. For general I/O tuning advice, see Section 8.5.8, “Optimizing InnoDB Disk I/O” . Defines the low water mark representing percentage of redo log capacity at which adaptive flushing is enabled. For more information, see Section 15.8.3.5, “Configuring Buffer Pool Flushing” . Whether the  InnoDB  adaptive hash index is enabled or disabled. It may be desirable, depending on your workload, to dynamically enable or disable adaptive hash indexing to improve query performance. Because the adaptive hash index may not be useful for all workloads, conduct benchmarks with it both enabled and disabled, using realistic workloads. See Section 15.5.3, “Adaptive Hash Index”  for details. This variable is enabled by default. You can modify this parameter using the  SET GLOBAL  statement, without restarting the server. Changing the setting at runtime requires privileges sufficient to set global 3216 • innodb_adaptive_hash_index • innodb_adaptive_flushing_lwm System Variable innodb_adaptive_flushing Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value ON Command-Line Format --innodb-adaptive-flushing-lwm=# System Variable innodb_adaptive_flushing_lwm Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 10 Minimum Value 0 Maximum Value 70 Command-Line Format --innodb-adaptive-hash-index[={OFF| ON}] System Variable innodb_adaptive_hash_index Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value ON