Skip to content

Instantly share code, notes, and snippets.

@HidetakaKojo
Last active February 28, 2019 05:25
Show Gist options
  • Save HidetakaKojo/c2b57eed85dc7386ad08 to your computer and use it in GitHub Desktop.
Save HidetakaKojo/c2b57eed85dc7386ad08 to your computer and use it in GitHub Desktop.
innodb(xtradb)の書き込みをロックを減らすためのチューニングポイント

innodb_stats_update_need_lock

innodb_buffer_pool_instances

innodb_rollback_segments

innodb_sync_spin_loops

  • よく書き込みまわりでチューニングのやりだまに上がる子
  • すごく気を使うところなので詰まりやすくなる問題もあって慎重にさわりたいところ

innodb_use_purge_thread

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment