Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
# debug
#log_slow_queries = 1
#long_query_time = 0
slow_query_log_file = "/tmp/slow.log"
# ER_NET_PACKET_TOO_LARGEでるまで放置
max_allowed_packet=300M
# 7Gくらい?
innodb_buffer_pool_size = 1G
#1に設定するとトランザクション単位でログを出力するが
# 2 を指定すると1秒間に1回ログファイルに出力するようになるやつ。
# 0 だと何もださない
innodb_flush_log_at_trx_commit = 0
# ログファイルの書込方式
# nosync
innodb_flush_method=O_DIRECT
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment