Appendix B. List of Parameters Changed in InnoDB 1.1 and InnoDB Plugin 1.0

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 storage engine 1.0.4. See Section 7.12, “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 storage engine 1.0.3. See Section 7.4, “Controlling InnoDB Change Buffering” for more information.

innodb_file_format

The default file format for new InnoDB tables. The default is Antelope. To enable support for table compression, change it to Barracuda. This parameter was added in InnoDB storage engine 1.0.1. See Section 4.1, “Enabling File Formats” for more information.

innodb_file_format_check and innodb_file_format_max

Controls whether InnoDB performs file format compatibility checking when opening a database. The default value is innodb-file-format-check=1, with innodb_file_format_max set to the highest format that is used in the database (either Barracuda or Antelope). See Section 4.2.1, “Compatibility Check When InnoDB Is Started” 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 storage engine 1.0.4. To reproduce the earlier behavior, use a value of 100. See Section 7.11, “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 storage engine 1.0.5. See Section 7.15, “Making Buffer Pool 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 storage engine 1.0.5. See Section 7.15, “Making Buffer Pool 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 storage engine 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 storage engine 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 storage engine 1.0.4. See Section 7.14, “Control of 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 storage engine 1.0.2. See Section 8.5, “Controlling Optimizer Statistics Estimation” for more information.

innodb_strict_mode

Whether InnoDB raises error conditions in certain cases, rather than issuing a warning. This parameter was added in InnoDB storage engine 1.0.2. See Section 8.4, “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 storage engine 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 storage engine 1.0.4. See Section 7.8, “Multiple Background I/O Threads” for more information.

innodb_file_io_threads

This parameter has been replaced by two new parameters innodb_read_io_threads and innodb_write_io_threads. See Section 7.8, “Multiple Background I/O Threads” for more information.