parameter 가이드

##############################
## mysqld_safe section
##############################
[mysqld_safe]
timezone = Asia/Seoul
ledir = /u01/app/percona/bin
mysqld = mysqld_with_numactl
malloc_lib = /usr/lib64/libjemalloc.so.1

##############################
## mysqld section
##############################
[mysqld]
port = 13326
socket = /data1/mysql/mysql.sock
local_infile = 0
back_log = 768
sql_mode = TRADITIONAL
lower_case_table_names=1
max_connect_errors = 99999999
open_files_limit = 65536
log_bin_trust_function_creators = 1
#init_file = /etc/mysql_mem_inventory.sql
default_storage_engine = InnoDB
transaction_isolation = READ-COMMITTED
wait_timeout = 14400
log_error_verbosity = 1
max_allowed_packet = 256M
max_connections = 3000
thread_cache_size = 20
skip_external_locking
skip_name_resolve
sysdate_is_now

## Directory
basedir = /u01/app/percona
secure_file_priv = /data1/mytemp
tmpdir = /data1/mytemp
datadir = /data1/mysql
innodb_data_home_dir = /data1/mysql
innodb_log_group_home_dir = /log1/innodb-log
log_bin = /log1/mysql-log/mysql-binary
relay_log = /log1/relay-log/mysql-relay

## Character Set
character_set_server = euckr
collation_server = euckr_bin

## Performance_schema
performance_schema = ON

## Table Cache
table_open_cache = 2000
table_definition_cache = 2000

## Query Cache
query_cache_size = 64M
query_cache_type = 2

## Connection memory buffer
sort_buffer_size = 64K
join_buffer_size = 64K
read_buffer_size = 64K
read_rnd_buffer_size = 64K
thread_stack = 256K
net_buffer_length = 128K
max_heap_table_size = 512K
tmp_table_size = 512K

## MyISAM storage engine
key_buffer_size = 17M
myisam_sort_buffer_size = 2M

## InnoDB storage engine
innodb_doublewrite = 0
innodb_file_per_table = 1
innodb_lock_wait_timeout = 50
innodb_open_files = 500
innodb_autoinc_lock_mode = 1
innodb_change_buffering = all

innodb_commit_concurrency = 0
innodb_thread_concurrency = 0
innodb_concurrency_tickets = 200
innodb_thread_sleep_delay = 0

innodb_purge_threads = 1
innodb_buffer_pool_size = 48G
innodb_buffer_pool_instances = 16

innodb_io_capacity = 5000
innodb_max_dirty_pages_pct = 75
innodb_old_blocks_time = 500
innodb_sync_spin_loops = 100

innodb_flush_log_at_trx_commit = 1
innodb_adaptive_flushing = ON
innodb_adaptive_hash_index = OFF
innodb_flush_method = ALL_O_DIRECT
innodb_flush_neighbors = 0
innodb_use_native_aio = ON
innodb_write_io_threads = 16
innodb_read_io_threads = 16
innodb_file_format = barracuda
innodb_file_format_max = barracuda
#innodb_large_prefix = 1

innodb_data_file_path = ibdata1:100M:autoextend
innodb_autoextend_increment = 1000

innodb_log_file_size = 3G
innodb_log_files_in_group = 2
innodb_log_buffer_size = 32M

## Logging
slow_query_log = 1
slow_query_log_file = /data1/mysql/mysql-slow.log
long_query_time = 0.5
log_slow_verbosity = Query_plan

## Replication
server_id = 1880555760
sync_binlog = 0
binlog_cache_size = 256K
max_binlog_size = 100M
expire_logs_days = 2
binlog_format = ROW
log_slave_updates
read_only
#rpl_semi_sync_master_enabled= ON
#rpl_semi_sync_slave_enabled = ON
#rpl_semi_sync_master_wait_point = AFTER_SYNC

##############################
## client section
##############################
[client]
port = 13326
socket = /data1/mysql/mysql.sock

##############################
## mysqldump section
##############################
[mysqldump]
max_allowed_packet = 256M
quick

##############################
## mysql section
##############################
[mysql]
default_character_set = euckr
no_auto_rehash