Users Guide

MySQL Server Configuration File Examples | Database Management
OMNM 6.5.3 Installation Guide 161
# Uncomment the following if you want to log updates
#log-bin
innodb_locks_unsafe_for_binlog=1
set-variable = innodb_buffer_pool_size=2048M
#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=12M
#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=1536
thread_cache=24
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
16GB example:
# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
query_cache_type=1
#caches often used queries. 32-512M, depending on how big the commonly
cached queries need to be, limit per and overall size
query_cache_limit=12M
query_cache_size=256M
set-variable = connect_timeout=10
#This is for myISAM tables, not needed for appserver
set-variable = key_buffer=384M
set-variable = max_allowed_packet=32M