Skip to content

Instantly share code, notes, and snippets.

@sidharrell
Created March 15, 2016 10:22
Show Gist options
  • Save sidharrell/be2cc397ba2e6827fbab to your computer and use it in GitHub Desktop.
Save sidharrell/be2cc397ba2e6827fbab to your computer and use it in GitHub Desktop.
minimum mysqld settings. /etc/my.cnf
[mysqld]
## General
ignore-db-dir = lost+found
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
tmpdir = /var/lib/mysqltmp
performance_schema=off
innodb_buffer_pool_size=5M
innodb_log_buffer_size=256K
query_cache_size=0
max_connections=2
key_buffer_size=8
thread_cache_size=2
host_cache_size=0
innodb_ft_cache_size=1600000
innodb_ft_total_cache_size=32000000
# per thread or per operation settings
thread_stack=131072
sort_buffer_size=32K
read_buffer_size=8200
read_rnd_buffer_size=8200
max_heap_table_size=16K
tmp_table_size=1K
bulk_insert_buffer_size=0
join_buffer_size=128
net_buffer_length=1K
innodb_sort_buffer_size=64K
#settings that relate to the binary log (if enabled)
binlog_cache_size=4K
binlog_stmt_cache_size=4K
[mysqld_safe]
log-error = /var/log/mysqld.log
#malloc-lib = /usr/lib64/libjemalloc.so.1
open-files-limit = 65535
[mysql]
no-auto-rehash
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment