general mysql 5.6 config file for os x

my.cnf

[mysql]

# CLIENT #
port                           = 3306
#socket                         = /usr/local/var/run/mysqld/mysqld.sock

[mysqld]

# GENERAL #
#user                           = mysql
default_storage_engine         = InnoDB
#socket                         = /usr/local/var/run/mysqld/mysqld.sock
#pid_file                       = /usr/local/var/run/mysqld/mysqld.pid

# MyISAM #
key_buffer_size                = 32M
myisam_recover_options         = FORCE,BACKUP

# SAFETY #
max_allowed_packet             = 16M
max_connect_errors             = 1000000
skip_name_resolve
innodb                         = FORCE
explicit_defaults_for_timestamp = 0

# MAC OSX. HFS+ is case insensitive
lower_case_table_names = 2

# DATA STORAGE #
datadir                        = /usr/local/var/mysql

# CACHES AND LIMITS #
tmp_table_size                 = 256M
max_heap_table_size            = 2048M
query_cache_type               = 0
query_cache_size               = 0
max_connections                = 500
thread_cache_size              = 50
open_files_limit               = 65535
table_definition_cache         = 4096
table_open_cache               = 4096

# INNODB #
innodb_file_per_table          = 0
innodb_flush_method            = O_DIRECT
#innodb_log_files_in_group      = 2
#innodb_log_file_size           = 512M
#innodb_flush_log_at_trx_commit = 0
innodb_file_per_table          = 1
innodb_buffer_pool_size        = 1G
innodb_data_file_path          = ibdata1:10M:autoextend:max:3999M

# LOGGING #
#log_queries_not_using_indexes  = 1
#slow_query_log                 = 1

These are some variables from my local machine and production. Some are set to prevent specific bugs in the 5.6 release branch from overwhelming memory.

key_buffer = 384M
max_allowed_packet = 32M
table_cache = 512
sort_buffer_size = 10M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 512
query_cache_size = 32M
query_cache_limit = 1M
join_buffer_size = 1M
tmp_table_size = 64M
max_heap_table_size = 2G
max_connections = 512
innodb_stats_on_metadata = 2
innodb_open_files = 300
max_connections = 500
thread_cache_size = 256
table_definition_cache = 400
performance-schema = OFF