在同一台机运行多个Mysql服务
2007-05-09 10:57:34 来源:WEB开发网mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
user = mysql
password = mypasswd
[mysqld1]
port = 3306
socket = /tmp/mysql.sock1
skip-locking
pid-file=/usr/local/mysql/data/net-app1a.pid
datadir = /usr/local/mysql/data
log=/usr/local/mysql/data/net-app1.log
user = mysql
log-slow-queries=/usr/local/mysql/data/slowquery.log
long_query_time = 2
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 32
query_cache_size = 32M
thread_concurrency = 2
max_connections=500
log-bin
log-bin=/usr/local/mysql/data/app-net1_1-bin
server-id = 1
[mysqld2]
port = 3307
socket = /tmp/mysql.sock2
pid-file = /usr/local/mysql/data2/net-app1b.pid
datadir = /usr/local/mysql/data2
log=/usr/local/mysql/data2/net-app1.log
user = mysql
log-slow-queries=/usr/local/mysql/data2/slowquery.log
long_query_time = 10
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 1M
read_buffer_size = 1M
myisam_sort_buffer_size = 32M
thread_cache = 32
query_cache_size = 16M
thread_concurrency = 2
- ››多个Android 2.2编译ROM发布 国内市场同步本地化
- ››运行于以太网的基础协议
- ››运行 Android 的魅族 M9 参数细节出炉
- ››运行 Android Emulator 的方法
- ››运行Word总默认打开上次文档怎么办?
- ››运行于 Nexus One 的完整版 Firefox 截图曝光
- ››运行于 Nexus One 的 Opera Mobile for Android 演...
- ››运行 ASP.NET 的进程帐户必须具有IIS 元数据库权限...
- ››多个定时器的使用
- ››运行两个配置完全不同的Firefox
- ››同一邮箱可以注册多个帐号修改方法_for 7.X
- ››多个Excel表中的数据合并计算方法
更多精彩
赞助商链接