Created
October 19, 2010 10:47
-
-
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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