Skip to content

Instantly share code, notes, and snippets.

@cbrunnkvist
Created October 19, 2010 10:47
Show Gist options
  • Save cbrunnkvist/633997 to your computer and use it in GitHub Desktop.
Save cbrunnkvist/633997 to your computer and use it in GitHub Desktop.
#mysql Ver 14.14 Distrib 5.1.38, for apple-darwin9.5.0 (i386) using readline 5.1
[mysqld]
#Port number to use for connections.
port=3306
#### Values to lower while debugging timeout errors ####
#The number of seconds the server waits for activity on a connection before closing it
#wait_timeout=10
#The number of seconds the server waits for activity on an interactive connection before closing it.
#interactive_timeout=10
#The number of seconds the mysqld server is waiting for a connect packet before responding with 'Bad handshake'
#connect_timeout=10
#The number of seconds the server waits for activity on a connection before closing it
#wait_timeout=10
#### Performance tweaks ####
# Use cache unless told otherwise
query_cache_type=1
#Don't cache results that are bigger than this.
query_cache_size=32M
#How many threads we should keep in a cache for reuse.
thread_cache_size=4
#If an in-memory temporary table exceeds this size, MySQL will automatically convert it to an on-disk MyISAM table.
tmp_table_size=32M
#Don't allow creation of heap tables bigger than this.
max_heap_table_size=32M
#The bigger you set this the less disk I/O is needed to access data in tables. On a dedicated database server you may set this parameter up to 80% of the machine physical memory size. Do not set it too large, though, because competition of the physical memory may cause paging in the operating system.
innodb_buffer_pool_size=384M
#Max packetlength to send/receive from to server.
max_allowed_packet=100M #insane, yes, but it is a workaround
innodb_flush_log_at_trx_commit=2
innodb_doublewrite=0
innodb_support_xa=FALSE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment