Skip to content

Instantly share code, notes, and snippets.

@jermainee

jermainee/z_additional.cnf

Created June 10, 2021 15:23
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 jermainee/aec28cbad3273857e5e6025a77af137c to your computer and use it in GitHub Desktop.
Save jermainee/aec28cbad3273857e5e6025a77af137c to your computer and use it in GitHub Desktop.
Download ZIP
MySQL tweaks - /etc/mysql/conf.d/z_additional.cnf
Raw
z_additional.cnf
[mysqld]
skip-log-bin
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
skip-character-set-client-handshake
# innodb_buffer_pool_size should be about 70% of the ram on db-only servers
innodb_buffer_pool_size = 16G
max_allowed_packet = 1G
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment