Skip to content

Instantly share code, notes, and snippets.

@ijin
Created December 13, 2013 07:40
Show Gist options
  • Save ijin/7941028 to your computer and use it in GitHub Desktop.
Save ijin/7941028 to your computer and use it in GitHub Desktop.
Server Festa 2013 Autumn base my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character-set-server = utf8
max_connections = 1000
key_buffer_size = 32M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 200
#slow_query_log=1
#long_query_time=0
query_cache_type = 0
skip-innodb_doublewrite
innodb_buffer_pool_size = 192M
innodb_log_buffer_size = 4M
innodb_flush_log_at_trx_commit = 0
innodb_support_xa = 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment