my.cnf 첨부 해드립니다.
서버사양은 아래의 정보를 참조해 드립니다.
———————————————————————-
cpu: Intel(R) Xeon(TM) MP CPU 2.50GHz * 4
mem:4gb
swap: 3gb
———————————————————————-
[mysqld]
port = 3306
socket = /tmp/mysql.sock
datadir = /usr/local/mysql/data
skip-locking
set-variable = key_buffer=1024M
set-variable = max_allowed_packet=1M
set-variable = table_cache=4096
set-variable = sort_buffer=64M
set-variable = record_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=24
set-variable = max_connections=5000
set-variable = wait_timeout=30
# Try number of CPU’s*2 for thread_concurrency
set-variable = thread_concurrency=24
set-variable = max_connect_errors=5000
MySQL에 대한 튜닝 예제
Leave a reply