Skip to content

Instantly share code, notes, and snippets.

@yoku0825
Created December 27, 2012 08:56
Show Gist options
  • Save yoku0825/4386692 to your computer and use it in GitHub Desktop.
Save yoku0825/4386692 to your computer and use it in GitHub Desktop.
えげつないmysqld_multi用my.cnfになったw
[mysqld_multi]
user = mysqld_multi
password = mysqld_multi
log = /var/log/mysqld_multi.log
[mysqld]
user = mysql
log-error = error.log
log-warnings = 1
log-bin = bin
relay-log = relay
loose-binlog-format = mixed
loose-skip-general-log
loose-general-log-file = general.log
loose-slow-query-log
loose-slow-query-log-file = slow.log
long-query-time = 1
loose-log-output = FILE
character-set-server = utf8
innodb-buffer-pool-size = 1G
innodb-log-file-size = 128M
innodb-file-per-table = 1
[client]
[mysql]
no-auto-rehash
[mysqldump]
single-transaction
triggers
routines
events
[mysqld50]
basedir = /usr/mysql/5.0.96
mysqld = /usr/mysql/5.0.96/bin/mysqld_safe
socket = /usr/mysql/5.0.96/data/mysql.sock
port = 64050
pid-file = /usr/mysql/5.0.96/data/mysql.pid
datadir = /usr/mysql/5.0.96/data
log-slow-queries = slow.log
skip-log = general.log
[mysqld51]
basedir = /usr/mysql/5.1.66
mysqld = /usr/mysql/5.1.66/bin/mysqld_safe
socket = /usr/mysql/5.1.66/data/mysql.sock
port = 64051
pid-file = /usr/mysql/5.1.66/data/mysql.pid
datadir = /usr/mysql/5.1.66/data
[mysqld55]
basedir = /usr/mysql/5.5.29
mysqld = /usr/mysql/5.5.29/bin/mysqld_safe
socket = /usr/mysql/5.5.29/data/mysql.sock
port = 64055
pid-file = /usr/mysql/5.5.29/data/mysql.pid
datadir = /usr/mysql/5.5.29/data
[mysqld56]
basedir = /usr/mysql/5.6.9
mysqld = /usr/mysql/5.6.9/bin/mysqld_safe
socket = /usr/mysql/5.6.9/data/mysql.sock
port = 64056
pid-file = /usr/mysql/5.6.9/data/mysql.pid
datadir = /usr/mysql/5.6.9/data
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment