OS : CentOS 6.x

MySql : 5.6

[code]

[client] 

default-character-set=utf8 

port            = 3306

socket          = /tmp/mysql.sock

[mysqld] 

port            = 3306

socket          = /tmp/mysql.sock

skip-external-locking

key_buffer_size = 128M

max_allowed_packet = 6M

table_open_cache = 4096

sort_buffer_size = 1M

read_buffer_size = 1M

read_rnd_buffer_size = 4M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size= 16M

# 스레드 수 = 코어*2 추천 드림

thread_concurrency = 8

skip-name-resolve

max_connections=170

max_user_connections=100

slow-query-log

long_query_time = 8

wait_timeout=100

#character-set-client-handshake = FALSE

join_buffer_size = 2M

event_scheduler = ON

character-set-server=utf8

binlog_format=mixed

server-id       = 1 

[mysqldump] 

quick

max_allowed_packet = 16M

default-character-set=utf8

[mysql]

no-auto-rehash

default-character-set=utf8

[myisamchk]

key_buffer_size = 128M

sort_buffer_size = 128M

read_buffer = 2M

write_buffer = 2M

default-character-set=utf8

[mysqlhotcopy]

interactive-timeout

default-character-set=utf8

[/code]