Skip to content

Instantly share code, notes, and snippets.

@nmusco
Created May 22, 2020 17:05
Show Gist options
  • Save nmusco/4546fda376dad659899b922a8f7884cc to your computer and use it in GitHub Desktop.
Save nmusco/4546fda376dad659899b922a8f7884cc to your computer and use it in GitHub Desktop.
MariaDB configuration file setup specifically for GoAutoDial 3.3
[client-server]
!includedir /etc/my.cnf.d
[mysqld]
log-error=/var/lib/mysql/error.log
slow-query-log-file=/var/lib/mysql/slow.log
slow-query-log=ON
log-queries-not-using-indexes=ON
long-query-time=100
thread_handling=pool-of-threads
thread_pool_size=128
thread-cache-size=1024
thread_pool_idle_timeout=300
skip-name-resolve
skip-host-cache
key_buffer_size=5G
join_buffer_size=1G
max_connections=500
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment