Skip to content

Instantly share code, notes, and snippets.

@hatak
Created July 26, 2012 02:40
Show Gist options
  • Save hatak/3179937 to your computer and use it in GitHub Desktop.
Save hatak/3179937 to your computer and use it in GitHub Desktop.
my.cnf for MySQL-5.5.x (official binary) @ MacOSX
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
user = mysql
pid-file = /usr/local/var/mysql/mysqld.pid
socket = /tmp/mysql.sock
port = 3306
datadir = /usr/local/var/mysql
plugin_dir = /usr/local/mysql/lib/plugin
tmpdir = /tmp
log-error = /usr/local/var/log/mysql/mysqld.err
skip-character-set-client-handshake
character-set-server = utf8mb4
sync_binlog = 1
expire_logs_days = 7
log-bin = mysql-bin
max_binlog_size = 256M
binlog_format = mixed
general_log = 1
general_log_file = /usr/local/var/log/mysql/mysql.log
slow_query_log = 1
slow_query_log_file = /usr/local/var/log/mysql/slow.log
long_query_time = 2
log_queries_not_using_indexes
myisam_repair_threads = 1
myisam_recover
innodb_file_format = Barracuda
innodb_file_format_max = Barracuda
innodb_open_files = 2048
[mysql]
default-character-set = utf8mb4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment