Skip to content

Instantly share code, notes, and snippets.

@ftkro
Created November 14, 2014 07:49
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 ftkro/20aee3dd668d871324ee to your computer and use it in GitHub Desktop.
Save ftkro/20aee3dd668d871324ee to your computer and use it in GitHub Desktop.
MySQL Setting configuration File
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = -12
[mysqld]
skip-external-locking
sql-mode="NO_ENGINE_SUBSTITUTION"
symbolic-links=0
character-set-server = utf8
skip-character-set-client-handshake
skip-name-resolve
default-storage-engine=InnoDB
innodb_strict_mode
innodb_file_per_table
skip-innodb_doublewrite
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size=64M
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_thread_concurrency = 16
innodb_log_file_size=16M
innodb_flush_log_at_trx_commit = 2
innodb_flush_method=O_DIRECT
query_cache_size=64M
query_cache_limit=2M
query_cache_min_res_unit=4k
query_cache_type=1
tmp_table_size=64M
max_heap_table_size=2M
table_open_cache=1024
bulk_insert_buffer_size=16777216
max_allowed_packet=1M
sort_buffer=512K
read_buffer_size=256K
read_rnd_buffer_size=256K
join_buffer_size=256K
key_buffer_size=16M
max_connections=128
thread_cache=128
thread_cache_size=64
wait_timeout=60
thread_concurrency = 128
open_files_limit = 65535
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment