Throughout the course of development, the InnoDB Plugin has introduced new configuration parameters. The following table summarizes those parameters:
Table C.1. InnoDB Plugin new parameter summary
Name | Cmd-Line | Option File | System Var | Scope | Dynamic | Default |
---|---|---|---|---|---|---|
innodb_adaptive_flushing |
YES |
YES |
YES |
GLOBAL |
YES |
TRUE |
innodb_change_buffering |
YES |
YES |
YES |
GLOBAL |
YES |
inserts |
innodb_file_format |
YES |
YES |
YES |
GLOBAL |
YES |
Antelope |
innodb_file_format_check |
YES |
YES |
YES |
GLOBAL |
YES |
ON |
innodb_io_capacity |
YES |
YES |
YES |
GLOBAL |
YES |
200 |
innodb_old_blocks_pct |
YES |
YES |
YES |
GLOBAL |
YES |
37 |
innodb_old_blocks_time |
YES |
YES |
YES |
GLOBAL |
YES |
0 |
innodb_read_ahead_threshold |
YES |
YES |
YES |
GLOBAL |
YES |
56 |
innodb_read_io_threads |
YES |
YES |
YES |
GLOBAL |
NO |
4 |
innodb_spin_wait_delay |
YES |
YES |
YES |
GLOBAL |
YES |
6 |
innodb_stats_sample_pages |
YES |
YES |
YES |
GLOBAL |
YES |
8 |
innodb_strict_mode |
YES |
YES |
YES |
GLOBAL|SESSION |
YES |
FALSE |
innodb_use_sys_malloc |
YES |
YES |
YES |
GLOBAL |
NO |
TRUE |
innodb_write_io_threads |
YES |
YES |
YES |
GLOBAL |
NO |
4 |
innodb_adaptive_flushing
Whether InnoDB uses a new algorithm to
estimate the required rate of flushing. The default value is
TRUE
. This parameter was added in
InnoDB Plugin 1.0.4.
See Section 7.11, “Controlling the Flushing Rate of Dirty Pages” for
more information.
innodb_change_buffering
Whether InnoDB performs insert buffering.
The default value is "inserts"
(buffer insert
operations). This parameter was added in InnoDB Plugin 1.0.3.
See Section 7.4, “Controlling InnoDB Insert Buffering”
for more information.
innodb_file_format
Whether to enable the new “Barracuda” file format. The default value is “Antelope”. This parameter was added in InnoDB Plugin 1.0.1. See Section 4.3, “Enabling File Formats” for more information.
innodb_file_format_check
Whether InnoDB performs file format
compatibility checking when opening a database. The default
value is ON
. This parameter was added in
InnoDB Plugin 1.0.1. See
Section 4.4.1, “Startup File Format Compatibility Checking”
for more information.
innodb_io_capacity
The number of I/O
operations that can be performed per second. The allowable value
range is any number 100 or greater, and the default value
is 200
. This parameter was added in
InnoDB Plugin 1.0.4. To reproduce the earlier behavior,
use a value of 100.
See Section 7.10, “Controlling the Master Thread I/O Rate”
for more information.
innodb_old_blocks_pct
Controls the desired percentage of “old”
blocks in the LRU list of the buffer pool. The default value is
37
and the allowable value range is
5 to 95
. This parameter was added in
InnoDB Plugin 1.0.5.
See Section 7.14, “Making Buffer Cache Scan Resistant”
for more information.
innodb_old_blocks_time
The time in milliseconds since the first access to a
block during which it can be accessed again without being made
“young”. The default value is 0
which means that blocks are moved to the “young”
end of the LRU list at the first access. This parameter
was added in InnoDB Plugin 1.0.5.
See Section 7.14, “Making Buffer Cache Scan Resistant”
for more information.
innodb_read_ahead_threshold
Control the sensitivity of the linear read ahead.
The allowable value range
is 0
to 64
and the
default value is 56
. This parameter was added
in InnoDB Plugin 1.0.4. See
Section 7.7, “Changes in the Read Ahead Algorithm” for more
information.
innodb_read_io_threads
The number of background I/O
threads used for reads. The allowable value range
is 1
to 64
and the default
value is
4
. This parameter was added in
InnoDB Plugin 1.0.4. See
Section 7.8, “Multiple Background I/O Threads” for more
information.
innodb_spin_wait_delay
Maximum delay between polling for a spin lock. The
allowable value range is 0
(meaning
unlimited) or positive integers and the default value
is 6
. This parameter was added in
InnoDB Plugin 1.0.4. See
Section 7.13, “Control over spin lock polling” for more
information.
innodb_stats_sample_pages
The number of index pages to sample when calculating
statistics. The allowable value range is
1-unlimited
and the default value is
8
. This parameter was added in InnoDB Plugin
1.0.2. See
Section 8.6, “Controlling Optimizer Statistics Estimation” for
more information.
innodb_strict_mode
Whether InnoDB raises error conditions in
certain cases, rather than issuing a warning. The default value is
OFF
. This parameter was added in
InnoDB Plugin 1.0.2. See
Section 8.5, “InnoDB Strict Mode” for more
information.
innodb_use_sys_malloc
Whether InnoDB uses its own memory allocator
or an allocator of the operating system. The default value is
ON
(use an allocator of the underlying
system). This parameter was added in InnoDB Plugin 1.0.3. See
Section 7.3, “Using Operating System Memory Allocators” for more
information.
innodb_write_io_threads
The number of background I/O
threads used for writes. The allowable value range
is 1
to 64
and the default
value is 4
. This parameter was added in
InnoDB Plugin 1.0.4. See
Section 7.8, “Multiple Background I/O Threads” for more
information.
This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).