Oracle 5.0, Reference Manual

Page: 1257 / 3232

InnoDB
Startup Options and System Variables
1237
Option-File Format
innodb_adaptive_hash_index
Option Sets Variable Yes,
innodb_adaptive_hash_index
[1236]
Variable Name
innodb_adaptive_hash_index
Variable Scope Global
Dynamic Variable No
Permitted Values
Type
boolean
Default
ON
Whether InnoDB adaptive hash indexes are enabled or disabled (see Section 14.2.9.4,
“Adaptive Hash Indexes” ). This variable is enabled by default. Use
--skip-
innodb_adaptive_hash_index
at server startup to disable it. This variable was added in MySQL
5.0.52.
•
innodb_additional_mem_pool_size
Command-Line Format
--innodb_additional_mem_pool_size=#
Option-File Format
innodb_additional_mem_pool_size
Option Sets Variable Yes,
innodb_additional_mem_pool_size
[1237]
Variable Name
innodb_additional_mem_pool_size
Variable Scope Global
Dynamic Variable No
Deprecated 5.6.3
Permitted Values
Type
numeric
Default
1048576
Range
524288 .. 4294967295
The size in bytes of a memory pool
InnoDB
uses to store data dictionary information and other
internal data structures. The more tables you have in your application, the more memory you need
to allocate here. If
InnoDB
runs out of memory in this pool, it starts to allocate memory from the
operating system and writes warning messages to the MySQL error log. The default value is 1MB.
•
innodb_autoextend_increment
Command-Line Format
--innodb_autoextend_increment=#
Option-File Format
innodb_autoextend_increment
Option Sets Variable Yes,
innodb_autoextend_increment
[1237]
Variable Name
innodb_autoextend_increment
Variable Scope Global
Dynamic Variable Yes
Permitted Values
Type
numeric
Default
8
Range
1 .. 1000
The increment size (in MB) for extending the size of an auto-extending shared tablespace file when
it becomes full. The default value is 8. This variable does not affect the per-table tablespace files