Users Guide

MySQL Server Configuration File Examples | Database Management
162 OMNM 6.5.3 Installation Guide
set-variable = table_cache=1024
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
server-id = 1
transaction-isolation = READ-COMMITTED
# Uncomment the following if you want to log updates
#log-bin
innodb_locks_unsafe_for_binlog=1
set-variable = innodb_buffer_pool_size=3072M
#larger sizes help with write intensive workloads and large data sets, but
usually not needed above 512M
set-variable = innodb_log_file_size=256M
#set high enough for 1 second worth of operations; maybe 1% of total (8M
for 8G, 16 for 16, etc)
set-variable = innodb_log_buffer_size=16M
#default of 1 is slow. 2 uses the OS cache so only lose data on OS crash
(power outage, etc). MUCH FASTER.
innodb_flush_log_at_trx_commit=2
innodb_thread_concurrency=8
#Increase based on number of concurrent users; assume each user hits about
100 tables and uses 1 thread (plus app overhead; 6 for overhead plus 1
per user)
table_cache=2048
thread_cache=64
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
innodb_log_archive=0
# set a smidge high each step; doesn't make a huge difference
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=30
32GB example:
# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking