MySQL :: InnoDB Plugin 1.0 for MySQL 5.1 (Early Adopter Release) User’s Guide

Section Navigation [Toggle]

C.3. Parameters with New Defaults

For better out-of-the-box performance, InnoDB Plugin 1.0.4 changes the default values for the following configuration parameters:

Table C.2. InnoDB Plugin parameters with new defaults

Name	Old Default	New Default
`innodb_additional_mem_pool_size`	`1MB`	`8MB`
`innodb_buffer_pool_size`	`8MB`	`128MB`
`innodb_log_buffer_size`	`1MB`	`8MB`
`innodb_max_dirty_pages_pct`	`90`	`75`
`innodb_sync_spin_loops`	`20`	`30`
`innodb_thread_concurrency`	`8`	`0`

This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).