Skip to content

Instantly share code, notes, and snippets.

@hugeval

hugeval/tuning.txg

Last active November 21, 2018 09:44
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 hugeval/b64a52b1238e55ebd244412d71f0e9c8 to your computer and use it in GitHub Desktop.
Save hugeval/b64a52b1238e55ebd244412d71f0e9c8 to your computer and use it in GitHub Desktop.
Download ZIP
tuning.txt
Raw
tuning.txg
php-fpm:
memory_limit=4G
mysql
innodb_buffer_pool_size=1G
table_open_cache=4096
table_definition_cache=4096
thread_cache_size=256
query_cache_size=64M
query_cache_type=1
sort_buffer_size=16M
max_heap_table_size=512M
tmp_table_size=512M
max_connections=500
max_allowed_packet=512M
key_buffer_size=256M
innodb_thread_concurrency=
max_allowed_packet=128M
binlog_error_action=ABORT_SERVER
log_error_verbosity=3
wait_timeout=3600
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment