## -- MASTER
## -- edit by san2@2004.06.10
## -- 1GB memory and only mysql server
##
## DB_DIR=/databases/mysql
## LOG_DIR=/databases/mysqldlog
## TMP_DIR=/databases/tmpdir

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

[mysqld]

## GLOBAL: set global
##
server-id		= 1			## MASTER
#server-id		= 2			## SLAVE
user			= mysql			## mysqld user
#bind-address		= 127.0.0.1		## only localhost access
default-character-set	= euc_kr
tmpdir			= /databases/tmpdir	## available of 1G over

## GOLBAL: skip an use options
##
#skip-network		## only localhost access
#skip-show-database	## only root and SHOW DATABASES privileges, 3.23.xx(`skip_show_database')
#safe-show-database	## accessable DB and print. It's work, but no value `mysqladmin varialbes'(4.0.xx)
skip-new
skip-innodb
skip-bdb
skip-locking
skip-external-locking	## 3.23.xx, but safe
skip-name-resolve	## only ipv4 address access in `Host' column
use-symbolic-links	## 4.0.xx
symbolic-links		## 3.23.xx, but safe

## GLOBAL: set log and pid file
##
#log-long-format
#log-update
log			= /databases/mysqldlog/mysqld.log
log-error		= /databases/mysqldlog/mysqld.err
pid-file		= /databases/mysqldlog/mysqld.pid
log-slow-queries	= /databases/mysqldlog/slow-queries.log	## refer `-O long_query_time=#'

## MASTER: set replication log-bin file and index file
##
log-bin			= /databases/mysqldlog/master-bin
log-bin-index		= /databases/mysqldlog/master-bin.index

## SLAVE: set replication, relay-log and index file
##
#relay-log		= /databases/mysqldlog/relay-bin
#relay-log-index	= /databases/mysqldlog/relay-bin.index
#relay-log-info-file	= /databases/mysqldlog/relay.info

## MASTER: set replication, databases or tables
##
binlog-do-db		= chat
binlog-do-db		= meeting
binlog-ignore-db	= mysql

## SLAVE: set replication, databases or tables
##
#replicate-do-db	= chat
#replicate-do-db	= meeting
#replicate-ignore-db	= mysql

## SLAVE: set replication, master information
##
#master-info-file	= /databases/mysqldlog/master.info
#master-host		= 211.115.73.61
#master-user		= rep
#master-password	= QjRnrlendwl
#master-port		= 3306
##master-connect-retry	= 5
#skip-slave-start	## auto start in `/usr/local/etc/rc.d/mysql-slave.sh'
##read-only		## read only exception replication threads and users with the SUPER privilege
##slave-skip-errors	= 1050,1051,1052,1053,1060,1061,1062,1146,1136
#slave-skip-errors	= all
##abort-slave-event-count= 1

## GLOBAL: set variable
##
set-variable	= datadir=/databases/mysql	## [base]
set-variable	= back_log=1024			## [base], listen(2)
set-variable	= max_allowed_packet=8M		## [base]
set-variable    = max_connections=512		## [base]
#
set-variable 	= key_buffer_size=512M		## [buffer], not shared
set-variable	= join_buffer_size=1M		## [buffer]
set-variable 	= sort_buffer_size=1M		## [buffer]
set-variable	= myisam_sort_buffer_size=64M	## [buffer]
set-variable 	= read_buffer_size=1M		## [buffer]
set-variable 	= read_rnd_buffer_size=1M	## [buffer]
#
set-variable 	= thread_cache_size=16		## [thread], How many threads we should keep in a cache for reuse
#set-variable	= thread_concurrency=2		## [thread], set CPU's*2, but 4.0.x don't work
#set-variable	= thread_stack=196608		## [thread] The stack size for each thread
#
set-variable 	= table_cache=512		## [thread/table], The number of open tables for all threads
set-variable    = open_files_limit=32768	## [file/table], to reserve file descriptors to use with setrlimit()
#						## max_connections*5 or max_connections + table_cache*2
set-variable	= tmp_table_size=32M		## [misc]
set-variable	= long_query_time=5		## [misc], refer `log-slow-queries'
#set-variable 	= sort_key_blocks=20		## [misc]
#set-variable 	= decode_bits=10		## [misc]
#
set-variable	= interactive_timeout=1200	## [timeout]
set-variable	= wait_timeout=8		## [timeout]
set-variable	= query_cache_size=64M		## [query_cache], it's mean that query cache `ON'
#
#set-variable	= myisam_max_extra_sort_file_size=256	## [myisam] sort file size
#set-variable	= myisam_max_sort_file_size=2047	## [myisam] sort file size

[mysqldump]
quick
set-variable	= max_allowed_packet=16M

[myisamchk]
set-variable	= key_buffer_size=256M
set-variable	= read_buffer_size=2M
set-variable	= sort_buffer_size=256M
set-variable	= write_buffer_size=2M

[mysqlhotcopy]
interactive-timeout

[mysqladmin]
password	= QjRnrlendwl

[mysqlcheck]
password	= QjRnrlendwl