Skip to content

Instantly share code, notes, and snippets.

@petemcw petemcw/.my.cnf
Created Mar 1, 2014

Embed
What would you like to do?
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#
# Include all files from the config directory
#
!includedir /Users/prm/.my.cnf.d
#
# This group is read by the client library. Use it for options that affect all
# clients, but not the server
[client]
#
# This group is read by the server. Use it for options that only affect the
# server.
#
[server]
[mysqld]
# Query cache
query_cache_type = 1
query_cache_limit = 2M
query_cache_size = 64M
# InnoDB
innodb_data_file_path = ibdata1:1G;ibdata2:512M:autoextend
innodb_autoextend_increment = 512
innodb_log_file_size = 512M
innodb_buffer_pool_size = 2G
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.