ex ) /usr/local/mysql/shared/mysql/*.cnf
|
[mysqld]
skip-locking
set-variable = key_buffer=1024M
set-variable = max_allowed_packet=4M
set-variable = table_cache=1024M
set-variable = sort_buffer=128M
set-variable = record_buffer=128M
set-variable = thread_cache=32
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=16
set-variable = myisam_sort_buffer_size=256M
set-variable = max_connections=4096
set-variable = query_cache_size=4096M
set-variable = wait_timeout=30
set-variable = sort_buffer_size=32M
set-variable = read_buffer_size=32M
set-variable = thread_cache_size=256M