[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
user = _mysql
[mysqld1]
user = _mysql
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
innodb_data_home_dir = /usr/local/mysql/data
log-error = /usr/local/mysql/data/error_log.log
tmpdir = /tmp
pid-file = mysqld1.pid
socket = /tmp/mysql.sock
port = 3306
server_id = 1
log-bin = mysql-bin
binlog-format = mixed
innodb_buffer_pool_size = 8M
innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend
上以设置中,带路径的选项都是需要注意的内容。特别需要注意的内容是:innodb_data_home_dir 和 port, socket,server_id 千万不能重复。
如果 innodb_buffer_pool_size 的大小设置得太大,会造成MySQL无法启动。
上以设置中,带路径的选项都是需要注意的内容。特别需要注意的内容是:innodb_data_home_dir 和 port, socket,server_id 千万不能重复。
如果 innodb_buffer_pool_size 的大小设置得太大,会造成MySQL无法启动。