Skip to content

Instantly share code, notes, and snippets.

@kaitoii11

kaitoii11/InnoDB change log size

Created February 28, 2019 02:44
Show Gist options
  • Save kaitoii11/9bc41670ebac3343bb565c2bc4309e93 to your computer and use it in GitHub Desktop.
Save kaitoii11/9bc41670ebac3343bb565c2bc4309e93 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
InnoDB change log size
# InnoDB change log size
- innodb_fast_shutdownが2に設定されている場合は1に設定
`mysql> SET GLOBAL innodb_fast_shutdown = 1;`
- シャットダウンし、正常終了することを確認
- ログファイルを削除`/var/lib/mysql/ib_logfile*`
- MySQL/MariaDBを再起動
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment