[client]
#password   = compaq1
port        = 9481
socket      = /tmp/mysql.sock

[safe_mysqld]
open-files-limit = 1024

# The MySQL server
[mysqld]
language        = korean
port        = 9481
socket      = /tmp/mysql.sock
skip-locking
set-variable    = key_buffer=16M
set-variable    = max_allowed_packet=1M
set-variable    = table_cache=256
set-variable    = sort_buffer=10M
set-variable    = record_buffer=10M
set-variable    = myisam_sort_buffer_size=16M
set-variable    = thread_cache=8
set-variable    = thread_concurrency=4
set-variable    = max_connections=512
default-table-type = innodb
log-bin
#server-id  = 1
log-slow-queries = /data/mysql/log/slow-queries.log
long_query_time=2
skip-name-resolve
datadir = /data/mysql
tmpdir = /data/mysql

innodb_data_home_dir =
innodb_log_group_home_dir = /data/mysql/log
#innodb1_log_arch_dir = /data/mysql/arch
#innodb1_data_file_path = /disk/1/data/ibdata1:512M;/disk/2/data/ibdata2:512M;/disk/3/data/ibdata3:512M;/disk/4/data/ibdata4:512M;/disk/5/data/ibdata5:512M;/disk/6/data/ibdata6:512M;/disk/7/data/ibdata7:512M;/disk/8/data/ibdata8:512M;/disk/9/data/ibdata9:512M;/disk/10/data/ibdata10:512M;/disk/11/data/ibdata11:512M;/disk/12/data/ibdata12:512M

#innodb1_data_file_path = /disk/1/data/ibdata1:512M;/disk/2/data/ibdata2:512M;/disk/3/data/ibdata3:512M;/disk/4/data/ibdata4:512M;/disk/5/data/ibdata5:512M;/disk/6/data/ibdata6:512M;/disk/7/data/ibdata7:512M;/disk/8/data/ibdata8:512M;/disk/9/data/ibdata9:512M;/disk/10/data/ibdata10:512M;/disk/11/data/ibdata11:512M;/disk/12/data/ibdata12:512M;/disk/1/data/ibdata13:1024M;/disk/2/data/ibdata14:1024M;/disk/3/data/ibdata15:1024M;/disk/4/data/ibdata16:1024M;/disk/5/data/ibdata17:1024M;/disk/6/data/ibdata18:1024M;/disk/7/data/ibdata19:1024M;/disk/8/data/ibdata20:1024M;/disk/9/data/ibdata21:1024M;/disk/10/data/ibdata22:1024M;/disk/11/data/ibdata23:1024M;/disk/12/data/ibdata24:1024M;/disk/1/data/ibdata25:1024M;/disk/2/data/ibdata26:1024M;/disk/3/data/ibdata27:1024M;/disk/4/data/ibdata28:1024M;/disk/5/data/ibdata29:1024M;/disk/6/data/ibdata30:1024M;/disk/7/data/ibdata31:1024M;/disk/8/data/ibdata32:1024M;/disk/9/data/ibdata33:1024M;/disk/10/data/ibdata34:1024M;/disk/11/data/ibdata35:1024M;/disk/12/data/ibdata36:1024M

innodb_data_file_path = /disk/1/data/ibdata1:512M;/disk/2/data/ibdata2:512M;/disk/3/data/ibdata3:512M;/disk/4/data/ibdata4:512M;/disk/5/data/ibdata5:512M;/disk/6/data/ibdata6:512M;/disk/7/data/ibdata7:512M;/disk/8/data/ibdata8:512M;/disk/9/data/ibdata9:512M;/disk/10/data/ibdata10:512M;/disk/11/data/ibdata11:512M;/disk/12/data/ibdata12:512M;/disk/1/data/ibdata13:1024M;/disk/2/data/ibdata14:1024M;/disk/3/data/ibdata15:1024M;/disk/4/data/ibdata16:1024M;/disk/5/data/ibdata17:1024M;/disk/6/data/ibdata18:1024M;/disk/7/data/ibdata19:1024M;/disk/8/data/ibdata20:1024M;/disk/9/data/ibdata21:1024M;/disk/10/data/ibdata22:1024M;/disk/11/data/ibdata23:1024M;/disk/12/data/ibdata24:1024M;/disk/1/data/ibdata25:1024M;/disk/2/data/ibdata26:1024M;/disk/3/data/ibdata27:1024M;/disk/4/data/ibdata28:1024M;/disk/5/data/ibdata29:1024M;/disk/6/data/ibdata30:1024M;/disk/7/data/ibdata31:1024M;/disk/8/data/ibdata32:1024M;/disk/9/data/ibdata33:1024M;/disk/10/data/ibdata34:1024M;/disk/11/data/ibdata35:1024M;/disk/12/data/ibdata36:1024M;/disk/1/data/ibdata37:2048M;/disk/2/data/ibdata38:2048M;/disk/3/data/ibdata39:2048M;/disk/4/data/ibdata40:2048M;/disk/5/data/ibdata41:2048M;/disk/6/data/ibdata42:2048M

set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=32M
set-variable = innodb_log_buffer_size=8M

#innodb_flush_log_at_trx_commit=0
#innodb_flush_method=O_DSYNC
innodb_flush_method=fdatasync
innodb_log_archive=0

# For the greatest possible durability and consistency  ==> need to set innodb_flush_method=fdatasync
innodb_flush_log_at_trx_commit=1
###sync-binlog=1
###innodb_safe_binlog

# For skip next-key locking
#innodb_locks_unsafe_for_binlog

set-variable = innodb_buffer_pool_size=256M
set-variable = innodb_additional_mem_pool_size=16M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=10

set-variable = query_cache_type=1
set-variable = query_cache_size=10M

# Point the following paths to different dedicated datas
#tmpdir     = /tmp/
#log-update     = /path-to-dedicated-directory/hostname

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

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

[isamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[myisamchk]
set-variable    = key_buffer=128M
set-variable    = sort_buffer=128M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[mysqlhotcopy]
interactive-timeout


[mysqld]
#log-bin
#server-id=1