Skip to content

Instantly share code, notes, and snippets.

@jonathanselander
Created September 25, 2013 18:48
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 jonathanselander/0c4f22ba06b613083d3c to your computer and use it in GitHub Desktop.
Save jonathanselander/0c4f22ba06b613083d3c to your computer and use it in GitHub Desktop.
[mysqld]
server-id = 1
log_bin = mysql-bin.log
expire_logs_days = 5
max_binlog_size = 100M
max_connections=2048
query_cache_size = 128M
key_buffer = 512M
query_cache_limit = 8M
join_buffer_size = 256K
tmp_table_size = 256M
max_heap_table_size = 256M
table_cache = 1024
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 2G
innodb_data_file_path = ibdata1:10M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 300
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment