OSX Mysql my.cnf

my.cnf

[client]
port                      = 3306
socket                    = /usr/local/var/run/mysql/mysqld.sock

[mysqld_safe]
open_files_limit          = 16384

[mysqld]
user                      = janoka
pid-file                  = /usr/local/var/run/mysql/mysqld.pid
socket                    = /usr/local/var/run/mysql/mysqld.sock
open-files-limit          = 16384

# Fine tuning:
max_allowed_packet        = 10M
innodb_file_per_table     = 1
innodb_buffer_pool_size   = 1024M
max_allowed_packet        = 20M
thread_stack              = 192K
thread_cache_size         = 8
query_cache_type          = 1
query_cache_size          = 4M
query_cache_limit         = 640M
join_buffer_size          = 1024M
table_open_cache          = 2048M

# Logging
log-error                 = /Users/janoka/www/log/mysql-error.log