Spec-Zone .ru
спецификации, руководства, описания, API

14.2.6.1. List of Parameters Recently Changed in InnoDB

14.2.6.1.1. New Parameters

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.7:

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_temp_data_file_path, innodb_undo_directory, innodb_undo_logs, innodb_undo_tablespaces

14.2.6.1.2. Parameters with New Defaults

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