Skip to content

Instantly share code, notes, and snippets.

@samvignoli
Created December 1, 2015 19:53
Show Gist options
  • Save samvignoli/48a28adec2cde11ab15b to your computer and use it in GitHub Desktop.
Save samvignoli/48a28adec2cde11ab15b to your computer and use it in GitHub Desktop.
[mysql]
default-character-set=utf8
socket=/var/run/mysqld/mysqld.sock
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice=0
[mysqld]
sql-mode='NO_ENGINE_SUBSTITUTION'
max_relay_log_size=1073741824
relay_log_space_limit=10485760
user=mysql
relay_log=slave-relay-bin
socket=/var/run/mysqld/mysqld.sock
port=3306
datadir=/var/lib/mysql
tmpdir=/var/tmp
log_error=/var/log/mysql/error.log
bind-address=0.0.0.0
server-id=9022
skip-external-locking
skip-name-resolve
myisam-recover=BACKUP
max_connections=2000
max_heap_table_size=419430400
key_buffer=8G
max_allowed_packet=100M
sort_buffer_size=40M
read_rnd_buffer_size=16M
read_buffer_size=40M
myisam_sort_buffer_size=32M
thread_cache=128
query_cache_size=32M
max_connect_errors=500
join_buffer_size=64M
thread_stack=256K
thread_concurrency=24
connect_timeout=4
wait_timeout=20
query_cache_type=1
tmp_table_size=15G
innodb_file_per_table
innodb_buffer_pool_size=512M
innodb_additional_mem_pool_size=20M
innodb_log_file_size=250M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=2
innodb_lock_wait_timeout=20
innodb_thread_concurrency=20
[mysqldump]
quick
quote-names
max_allowed_packet=16M
socket=/var/run/mysqld/mysqld.sock
[isamchk]
key_buffer=16M
[mysqladmin]
socket=/var/run/mysqld/mysqld.sock
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment