## /etc/my.cnf
##
## --defaults-file=/others/path/my.cnf 으로 지정하지 않는 이상
## 부팅시나 로그인후에도 기본적으로 /etc/my.cnf  파일을 읽어들임
##
## *주)
## --no-defaults, --defaults-file, --defaults-extra-file 옵션이 다른 옵션보다
## 항상 앞에 와야 함
##
## 만약 mysqld 를 구동할때 추가적으로 /root/.my.cnf 파일을 읽기를
## 원한다면 --defaults-extra-file=/root/.my.cnf 로 지정함.
## or
## --defaults-file=/etc/my.cnf --defaults-extra-file=/root/.my.cnf
##
## 그러나 로그인 상태라면 일반적으로 $HOME/.my.cnf 를 읽어들이기
## 때문에 root 의 경우는 /root/.my.cnf 를 읽어들임
## (이 설정 파일을 /root/.my.cnf 로 지정가능함)
##

## for global USER
##
[mysql]
ignore-spaces
local-infile	= 1
#host		= localhost
#pager		= more -d


## for global mysql configurations
##
[mysqld]
default-character-set	= euc_kr
#log-update
skip-locking
safe-show-database
skip-name-resolve
skip-network
log
log-long-format
bind-address    = 127.0.0.1

set-variable	= back_log=100
set-variable 	= sort_buffer=20M
#set-variable 	= record_buffer=20M
#set-variable 	= record_rnd_buffer=20M
set-variable 	= key_buffer=25M
#set-variable 	= sort_key_blocks=20
#set-variable 	= decode_bits=10
set-variable 	= thread_cache_size=8
set-variable 	= table_cache=256
set-variable	= myisam_max_extra_sort_file_size=256
set-variable	= myisam_max_sort_file_size=2047
set-variable	= myisam_sort_buffer_size=20M
set-variable	= tmp_table_size=32M
set-variable	= interactive_timeout=3600
set-variable	= wait_timeout=20
#set-variable    = open_files_limit=8192

skip-innodb
#innodb_data_home_dir		=
#innodb_data_file_path		= ibdata1:10M:autoextend
#innodb_flush_log_at_trx_commit	= 1
#innodb_log_arch_dir		=
#innodb_flush_method		= fdatasync

#set-variable	= innodb_additional_mem_pool_size=20M
#set-variable	= innodb_buffer_pool_size=1G
#set-variable	= innodb_log_buffer_size=10M
#set-variable	= innodb_log_file_size=150M
#set-variable	= innodb_lock_wait_timeout=50
#set-variable	= innodb_thread_concurrency=8

## yet
#innodb_file_io_threads		= 4
#innodb_force_recovery		= 0
#innodb_fast_shutdown		= ON
#innodb_log_archive		= OFF
#innodb_log_files_in_group	= 2
#innodb_log_group_home_dir	= ./
#innodb_mirrored_log_groups	= 1

[mysqld_multi]
mysqld		= /usr/local/mysql/bin/safe_mysqld
mysqladmin	= /usr/local/mysql/bin/mysqladmin
#mysqld		= /usr/local/mysql4/bin/mysqld_safe
#mysqladmin	= /usr/local/mysql4/bin/mysqladmin

[mysqld1]
safe-show-database
#skip-name-resolve
#skip-network
port		= 3306
#log
#log-bin
#log-update
user		= mysql    ## mysql 유저로 권한으로 실행됨
binlog-do-db	= jsboard
#binlog-ignore-db = test
server-id	= 1
#set-variable 	= key_buffer=256M
#set-variable 	= thread_cache_size=2
#set-variable 	= table_cache=256

[mysqld2]
socket		= /tmp/mysql.sock2
port		= 3307
pid-file	= /usr/local/mysql/var2/home.pid
datadir		= /usr/local/mysql/var2
language	= /usr/local/mysql/share/mysql/english
#skip-name-resolve
#skip-network
log		= /usr/local/mysql/var2/home.mysqld.log

## for replication
## localhost 에서 두개 이상의 mysqld 를 구동할때 하나는 미러링용도임
##
user		= mysqlrep    # mysqld2 는 mysqlrep 권한으로 실행됨
server-id	= 2
master-host	= localhost
master-user	= rep             # master-host 의 mysql.user 에 rep 가 등록되어야 함
master-password = rep의 암호
master-port	= 3306
#set-variable 	= thread_cache_size=3

[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]
user		= root

[mysqldump]
user		= root