- 8.3 Dynamic Control of System Configuration Parameters
- 8.3.1 Dynamically Changing innodb_file_per_table
- 8.3.2 Dynamically Changing innodb_stats_on_metadata
- 8.3.3 Dynamically Changing innodb_lock_wait_timeout
- 8.3.4 Dynamically Changing innodb_adaptive_hash_index
As described in Section 7.5, “Controlling Adaptive Hash Indexing”, it may be desirable, depending on your workload, to dynamically enable or disable the adaptive hash indexing scheme InnoDB uses to improve query performance.
Version 5.1.24 of MySQL introduced the start-up option
innodb_adaptive_hash_index that allows the adaptive hash index
to be disabled. It is enabled by default. Starting with
InnoDB Plugin 1.0.3, the parameter can be modified by the
SET GLOBAL command, without restarting the
server. Changing the setting requires the
SUPER privilege.
Disabling the adaptive hash index will empty the hash table immediately. Normal operations can continue while the hash table is emptied, and executing queries that have been using the hash table will access the index B-trees directly instead of attempting to utilize the hash index. When the adaptive hash index is enabled, the hash table will be populated during normal operation.
This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).
