16 번 글: [mysql] mysqld_multi |
글쓴이: 산이
[홈페이지]
|
글쓴날: 2003년 10월 06일 00:54:22 월(새벽) |
조회: 3555 |
# safe_mysqld &
# mysqld_multi start
-- my.conf -----------------------------------------
[client]
password = 안 갈쳐조오..
host = localhost
[mysql]
ignore-spaces
[mysqld]
default-character-set = euc_kr
safe-show-database
skip-name-resolve
skip-networking
log
#log-update
user = mysql
#set-variable = key_buffer=1
set-variable = key_buffer=256M
set-variable = thread_cache_size=8
set-variable = table_cache=256
[mysqld_multi]
mysqld = /usr/local/mysql/bin/safe_mysqld
mysqladmin = /usr/local/mysql/bin/mysqladmin
#user = root
[mysqld1]
socket = /tmp/mysql.sock1
#port = 3307
pid-file = /usr/local/mysql/var/home.pid1
datadir = /usr/local/mysql/var
language = /usr/local/mysql/share/mysql/english
skip-name-resolve
skip-networking
log = /usr/local/mysql/var/home.mysqld1.log
user = mysql
[mysqld2]
socket = /tmp/mysql.sock2
#port = 3308
pid-file = /usr/local/mysql/var/home.pid2
datadir = /usr/local/mysql/var
language = /usr/local/mysql/share/mysql/english
skip-name-resolve
skip-networking
log = /usr/local/mysql/var/home.mysqld2.log
user = mysql
[mysqld3]
socket = /tmp/mysql.sock3
#port = 3308
pid-file = /usr/local/mysql/var/home.pid3
datadir = /usr/local/mysql/var
language = /usr/local/mysql/share/mysql/english
skip-name-resolve
skip-networking
log = /usr/local/mysql/var/home.mysqld3.log
user = mysql
[myisamchk]
set-variable = key_buffer=100M
set-variable = sort_buffer=100M
set-variable = read_buffer=3M
set-variable = write_buffer=3M
#set-variable = sort_key_blocks=20
#set-variable = decode_bits=10
[mysqladmin]
#set-variable = connect_timeout=1
#set-variable = shutdown_timeout=1
[mysqldump]
user = root
------------------------------------------------
|
이전글 : Re: 관련 문서
다음글 : Re: 문서화 완료
|
from 61.254.75.40
JS(Redhands)Board 0.4 +@
|