mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-08-07 11:01:34 +02:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/storage/innobase/handler
History
Exact
Monty 57dbd8162e MDEV-37070 Implement table options to enable/disable features 
Added ADAPTIVE_HASH_INDEX=YES|NO table and index option to InnoDB.
The table and index options only have an effect if InnoDB adaptive hash
index feature is enabled.

- Having the ADAPTIVE_HASH_INDEX TABLE option set to NO will disable
  adaptive hash index for all indexes in the table that does not have
  the index option adaptive_hash_index=yes.
- Having the ADAPTIVE_HASH_INDEX TABLE option set to YES will enable the
  adaptive hash index for all indexes in the table that does not have
  the index option adaptive_hash_index=no.
- Using adaptive_hash_index=default deletes the old setting.
- One can also use OFF/ON as the options. This is to make it work similar
  as other existing options.

Example:
CREATE TABLE t1 (a int primary key, b varchar(100), c int,
index (b) adaptive_hash_index=no, index (c))
engine=innodb, adaptive_hash_index=yes;
2025-08-04 15:16:53 +03:00
..
ha_innodb.cc MDEV-37070 Implement table options to enable/disable features 2025-08-04 15:16:53 +03:00
ha_innodb.h MDEV-37070 Implement table options to enable/disable features 2025-08-04 15:16:53 +03:00
handler0alter.cc MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-07-08 12:30:27 +03:00
i_s.cc MDEV-28933: Per-table unique FOREIGN KEY constraint names 2025-07-08 12:30:27 +03:00
i_s.h Merge 10.5 into 10.6 2021-08-23 11:21:33 +03:00