Created
August 31, 2016 08:16
-
-
Save yassun/9e27e58c3173d0ef7c7944de70611656 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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