Skip to content

Instantly share code, notes, and snippets.

@uniacid
Created January 9, 2018 01:17
Show Gist options
  • Save uniacid/b02a52b7953c81d6f76fe6f83d914443 to your computer and use it in GitHub Desktop.
Save uniacid/b02a52b7953c81d6f76fe6f83d914443 to your computer and use it in GitHub Desktop.
gemaire mysql custom.cnf docker
[mysqld]
#innodb_buffer_pool_size=2G
### CACHES AND LIMITS #
back_log = 20
interactive_timeout = 7200
wait_timeout = 7200
net_read_timeout = 120
net_write_timeout = 300
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
join_buffer_size = 2M
tmp_table_size = 128M
max_heap_table_size = 128M
#query_cache_type = 2
#query_cache_size = 128M
max_connections = 150
thread_cache_size = 32
#thread_pool_size = 16
open_files_limit = 65535
table_definition_cache = 4000
table_open_cache = 4000
innodb_thread_concurrency = 0
innodb_lock_wait_timeout = 7200
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 2
innodb_log_files_in_group = 2
innodb_log_file_size = 256M
innodb_log_buffer_size = 32M
innodb_file_per_table = 1
innodb_read_io_threads = 8
innodb_write_io_threads = 8
innodb_buffer_pool_instances = 4
innodb_buffer_pool_size = 4G
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment