免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1598 | 回复: 0
打印 上一主题 下一主题

关于mysql多实例启动的配置问题?请指教! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2011-05-24 20:09 |只看该作者 |倒序浏览
本帖最后由 interliuxing 于 2011-05-24 20:30 编辑

mysql安装目录:/opt/mysql5155
操作系统         :centos5.5
my.cnf的配置内容如下:
           [mysqld_multi]
mysqld = /opt/mysql5155/bin/mysqld_safe
mysqladmin = /opt/mysql5155/bin/mysqladmin
user = test
password = test

[client]
port            = 3306
socket          = /tmp/mysql.sock


[mysqld3306]
port            = 3306
socket          = /tmp/mysql3306.sock
pid-file        = /tmp/mysql3306.pid
skip-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
basedir = /opt/mysql5155
datadir = /opt/mysql5155/data
server-id       = 3306


[mysqld3307]
port            = 3307
socket          = /tmp/mysql3307.sock
pid-file        = /tmp/mysql3307.pid
skip-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
basedir = /opt/mysql5155
datadir = /opt/mysql5155/data2
server-id       = 3307


[mysqld3308]
port            = 3308
socket          = /tmp/mysql3308.sock
pid-file        = /tmp/mysql3308.pid
skip-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
basedir = /opt/mysql5155
datadir = /opt/mysql5155/data3
server-id       = 3308


[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout



启动时出现的错误提示:


[root@liuxing mysql5155]# ./bin/mysqld_multi --defaults-file=./my.cnf start 3306
WARNING: my_print_defaults command not found.
Please make sure you have this command available and
in your path. The command is available from the latest
MySQL distribution.
ABORT: Can't find command 'my_print_defaults'.
This command is available from the latest MySQL
distribution. Please make sure you have the command
in your PATH.

怎么看配置和路径也没有错啊!请指教!
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP