6GB example (default):

# The MySQL server

[mysqld]

port=3306

#socket=MySQL

skip-locking

set-variable = connect_timeout=10

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_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