Skip to content

Instantly share code, notes, and snippets.

@steffenr
Created March 21, 2013 07:38
Show Gist options
  • Save steffenr/5211326 to your computer and use it in GitHub Desktop.
Save steffenr/5211326 to your computer and use it in GitHub Desktop.
my.cnf working with large Drupal databases
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 64M
table_open_cache = 256
table_cache = 4096
sort_buffer_size = 64M
read_buffer_size = 64M
read_rnd_buffer_size = 64M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 64M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
wait_timeout = 120
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment