Skip to content

Instantly share code, notes, and snippets.

Avatar
🏠
Working from home

Juan R. De Leon O. juanrdlo

🏠
Working from home
View GitHub Profile
@juanrdlo
juanrdlo / my.cnf
Created Oct 8, 2020 — forked from kenelliott/my.cnf
16CPU / 16GB My.cnf
View my.cnf
[mysqld_safe]
nice = -15
[mysqld]
max_binlog_size = 256M #max size for binlog before rolling
expire_logs_days = 1 #binlog files older than this will be purged
## Per-Thread Buffers * (max_connections) = total per-thread mem usage
thread_stack = 256K #default: 32bit: 192K, 64bit: 256K
sort_buffer_size = 1M #default: 2M, larger may cause perf issues