Skip to content

Instantly share code, notes, and snippets.

@shyazusa

shyazusa/my.cnf

Last active December 16, 2016 06:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shyazusa/7504cecdaf2fcbd143d118cdd5f2ba21 to your computer and use it in GitHub Desktop.
Save shyazusa/7504cecdaf2fcbd143d118cdd5f2ba21 to your computer and use it in GitHub Desktop.
Download ZIP
何かあったときに見直すmy.cnf
Raw
my.cnf
[mysqld]
# 強制起動 起動しなくなったら値を増やす (最大6)
innodb_force_recovery = 0
# DB復元のときに Lost Connectionしてしまうときはこれ
wait_timeout = 86400
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
innodb_buffer_pool_size = 64M
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment