Subscribed unsubscribe Subscribe Subscribe

かみぽわーる

kamipo's blog

InnoDB PluginとXtraDBのオプションのメモ

mysql

の場合。

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

それぞれのオプションについてはそのうち調べる。