の場合。
InnoDB -> InnoDB Pluginで増えたオプション
innodb_adaptive_flushing ON innodb_change_buffering inserts innodb_file_format Antelope innodb_file_format_check Antelope innodb_io_capacity 200 innodb_old_blocks_pct 37 innodb_old_blocks_time 0 innodb_read_ahead_threshold 56 innodb_read_io_threads 4 innodb_replication_delay 0 innodb_spin_wait_delay 6 innodb_stats_sample_pages 8 innodb_strict_mode OFF innodb_use_sys_malloc ON innodb_write_io_threads 4
InnoDB Plugin -> XtraDBで増えたオプション
innodb_adaptive_checkpoint estimate innodb_checkpoint_age_target 0 innodb_dict_size_limit 0 innodb_enable_unsafe_group_commit 0 innodb_expand_import 0 innodb_extra_rsegments 0 innodb_extra_undoslots OFF innodb_fast_recovery ON innodb_flush_neighbor_pages 1 innodb_ibuf_accel_rate 100 innodb_ibuf_active_contract 1 innodb_ibuf_max_size 2147467264 innodb_overwrite_relay_log_info OFF innodb_read_ahead linear innodb_recovery_stats OFF innodb_relax_table_creation 0 innodb_show_locks_held 10 innodb_show_verbose_locks 0 innodb_stats_auto_update 1 innodb_stats_method nulls_equal innodb_stats_update_need_lock 1 innodb_thread_concurrency_timer_based OFF innodb_use_purge_thread 1
それぞれのオプションについてはそのうち調べる。
