For better out-of-the-box performance, the following InnoDB configuration parameters have new default values since MySQL 5.1:
Table 13.11. InnoDB Parameters with New Defaults
| Name | Old Default | New Default |
|---|---|---|
innodb_additional_mem_pool_size | 1MB | 8MB |
innodb_buffer_pool_size | 8MB | 128MB |
innodb_change_buffering | inserts | all |
innodb_file_format_check | ON | 1 |
innodb_log_buffer_size | 1MB | 8MB |
innodb_max_dirty_pages_pct | 90 | 75 |
innodb_sync_spin_loops | 20 | 30 |
innodb_thread_concurrency | 8 | 0 |