중소형 웹호스팅에서 커뮤니티 운영할때 최적화 세팅입니다.

하루 방문자 3천명 내외이고, 4GB이하 램의 웹서버에 추천합니다.

[mysql]

max_allowed_packet = 32M

[mysqld]

local-infile=0

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

symbolic-links=0

back_log = 75

max_connections = 300

key_buffer_size = 32M

myisam_sort_buffer_size = 32M

myisam_max_sort_file_size = 2048M

join_buffer_size = 64K

read_buffer_size = 64K

sort_buffer_size = 128K

table_definition_cache = 4096

table_open_cache = 2048

thread_cache_size = 64

wait_timeout = 1800

connect_timeout = 10

tmp_table_size = 32M

max_heap_table_size = 32M

max_allowed_packet = 32M

max_seeks_for_key = 1000

group_concat_max_len = 1024

max_length_for_sort_data = 1024

net_buffer_length = 16384

max_connect_errors = 100000

concurrent_insert = 2

read_rnd_buffer_size = 256K

bulk_insert_buffer_size = 8M

query_cache_limit = 512K

query_cache_size = 16M

query_cache_type = 1

query_cache_min_res_unit = 2K

query_prealloc_size = 262144

query_alloc_block_size = 65536

transaction_alloc_block_size = 8192

transaction_prealloc_size = 4096

default-storage-engine = InnoDB

log_warnings=1

slow_query_log=0

long_query_time=1

slow_query_log_file=/var/lib/mysql/slowq.log

log-error=/var/log/mysqld.log

innodb_large_prefix=1

innodb_purge_threads=1

innodb_doublewrite = 1

innodb_file_per_table = 1

innodb_open_files = 1000

innodb_data_file_path= ibdata1:10M:autoextend

innodb_buffer_pool_size = 48M

innodb_additional_mem_pool_size = 32M

innodb_log_files_in_group = 2

innodb_log_file_size = 64M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 2

innodb_thread_concurrency = 0

innodb_lock_wait_timeout=50

#innodb_flush_method = O_DIRECT

innodb_support_xa=1

# 200 * # DISKS

innodb_io_capacity = 100

innodb_read_io_threads = 2

innodb_write_io_threads = 2

[mysqld_safe]

log-error=/var/log/mariadb/mariadb.log

pid-file=/var/run/mariadb/mariadb.pid

[mysqldump]

quick

max_allowed_packet = 32M

[myisamchk] 

key_buffer = 32M 

sort_buffer = 16M

read_buffer = 16M

write_buffer = 16M

[mysqlhotcopy]

interactive-timeout