Skip to content

Instantly share code, notes, and snippets.

@finger-berlin
Created February 20, 2012 13:55
Show Gist options
  • Save finger-berlin/1869325 to your computer and use it in GitHub Desktop.
Save finger-berlin/1869325 to your computer and use it in GitHub Desktop.
very very simple mysql conf... good to start.
[mysqld]
join_buffer_size = 4M
character-set-server = utf8
table_cache = 512
table_definition_cache = 2048
table_open_cache = 2048
innodb_file_per_table
innodb_additional_mem_pool_size = 2M
skip-ssl
innodb = ON
query_cache_limit = 64K
#ansi
innodb_buffer_pool_instances = 1
default-storage-engine = InnoDB
sort_buffer_size = 8M
query_cache_min_res_unit = 0
skip-name-resolve
innodb_fast_shutdown = 1
innodb_buffer_pool_size = 512M
character-set-filesystem = utf8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment