# MySQL Instance Manager options section
[manager]
default-mysqld-path = /usr/local/mysql/libexec/MySQLd
socket=/tmp/manager.sock
pid-file=/tmp/manager.pid
passWord-file = /home/cps/.MySQLmanager.passwd
monitoring-interval = 2
port = 1999
bind-address = 192.168.1.5
MySQL實例管理器只在Unix中讀取並管理/etc/my.cnf文件。在Windows中,MySQL實例管理器從Instance Manager的安裝目錄讀取my.ini文件。用--defaults-file=file_ name選項可以更改默認選項文件的位置。
實例部分指定啟動時給每個實例的選項。這些主要是普通MySQL服務器選項,但有一些IM-專用選項:
·mysqld-path = <path-to-MySQLd-binary>
MySQLd服務器二進制的路徑。
·shutdown-delay = Seconds
IM應等待實例關閉的秒數。 默認為35秒。超過延遲時間後,IM假定實例正掛起並試圖“kill –9”它。如果你使用帶large表的InnoDB,你應當增加該值。
·nonguarded
如果你想要為某個實例禁用IM監視功能,應設置該選項。
下面給出了幾個實例示例。
[MySQLd]
mysqld-path=/usr/local/mysql/libexec/MySQLd
socket=/tmp/MySQL.sock
port=3307
server_id=1
skip-stack-trace
core-file
skip-bdb
log-bin
log-error
log=mylog
log-slow-querIEs
[MySQLd2]
nonguarded
port=3308
server_id=2
mysqld-path= /home/cps/mysql/trees/mysql-5.1/sql/MySQLd
socket = /tmp/MySQL.sock5
pid-file = /tmp/hostname.pid5
datadir= /home/cps/MySQL_data/data_dir1
language=/home/cps/mysql/trees/MySQL-5.1/sql/share/english
log-bin
log=/tmp/fordel.log