MySQL :: InnoDB 1.1 for MySQL 5.5 User’s Guide (Early Adopter Release)

Section Navigation [Toggle]

B.3. Parameters with New Defaults

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

Table B.2. InnoDB storage engine 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 storage engine 1.1 for MySQL 5.5, generated on 2010-04-13 (revision: 19994) .