Users Guide

MySQL Server Configuration File Examples | Database Management
OMNM 6.5.3 Installation Guide 159
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=256M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=512M
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=30
8GB 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=128M
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
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=1024M
#larger sizes help with write intensive workloads and large data sets, but
usually not needed above 512M
set-variable = innodb_log_file_size=256M