Throughout the course of development, InnoDB 1.1 and its predecessor the InnoDB Plugin introduced new configuration parameters.
The following InnoDB-related configuration
parameters were added between MySQL 5.5 and 5.6:
innodb_adaptive_max_sleep_delay,
innodb_buffer_pool_dump_at_shutdown,
innodb_buffer_pool_dump_now,
innodb_buffer_pool_filename,
innodb_buffer_pool_load_abort,
innodb_buffer_pool_load_at_startup,
innodb_buffer_pool_load_now,
innodb_change_buffer_max_size,
innodb_checksum_algorithm,
innodb_disable_sort_file_cache,
innodb_flush_neighbors,
innodb_force_load_corrupted,
innodb_ft_aux_table,
innodb_ft_cache_size,
innodb_ft_enable_diag_print,
innodb_ft_enable_stopword,
innodb_ft_max_token_size,
innodb_ft_min_token_size,
innodb_ft_num_word_optimize,
innodb_ft_server_stopword_table,
innodb_ft_sort_pll_degree,
innodb_ft_user_stopword_table,
innodb_large_prefix,
innodb_lru_scan_depth,
innodb_monitor_disable,
innodb_monitor_enable,
innodb_monitor_reset,
innodb_monitor_reset_all,
innodb_optimize_fulltext_only,
innodb_page_size,
innodb_print_all_deadlocks,
innodb_random_read_ahead,
innodb_sort_buffer_size,
innodb_stats_persistent_sample_pages,
innodb_stats_transient_sample_pages,
innodb_sync_array_size,
innodb_undo_directory,
innodb_undo_logs,
innodb_undo_tablespaces
For better out-of-the-box performance, the following InnoDB configuration parameters have new default values since MySQL 5.1:
Table 14.6. 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 |

User Comments
Add your own comment.