From: Matt Mullenweg
To: Jeff Atwood
Date: April 23, 2008
Subject: Making WordPress Sing

Here's what I'd recommend [for MySQL configuration], after the tmpdir stuff under [mysqld]: (Some of these are high, but you'll never reach them and based on your available memory not a big deal.)

skip-external-locking
skip-slave-start
skip-bdb
skip-innodb
skip-name-resolve

# Global mem settings
key_buffer = 24M

max_connections = 200

# Per client mem settings

sort_buffer_size = 4M
read_buffer_size = 4M
binlog_cache_size = 2M

max_allowed_packet = 12M
thread_stack = 128K

table_cache = 128
thread_cache = 256
thread_concurrency = 4

myisam_sort_buffer_size = 1M
tmp_table_size = 12M
max_heap_table_size = 12M

wait_timeout = 200
interactive_timeout = 300
max_connect_errors = 10000

query_cache_type  = 1
query_cache_limit = 1M
query_cache_size  = 16M

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M