my.cnf.small_wordpress

#
# for small cache based wordpress service (ex. aws ec2.micro instance)
#
# this is beta version
#

#
# estimated physical memory size for this mysql server
# 200M
#

# !!!!! MUST SET BY EACH SERVER VALUES START
# !!!!! MUST SET BY EACH SERVER VALUES START
# !!!!! MUST SET BY EACH SERVER VALUES START

[mysql]
prompt          = '\u@##SERVER_NAME_SET_MY_CNF##(##SERVICE_NAME_SET_MY_CNF##-MASTER) mysql>'

[mysqld]
#server-id       = ##SERVER_ID_SET_MY_CNF##
innodb_buffer_pool_size = 120M   # 60% of memory
# comment out if slave server
#read-only

# !!!!! MUST SET BY EACH SERVER VALUES END
# !!!!! MUST SET BY EACH SERVER VALUES END
# !!!!! MUST SET BY EACH SERVER VALUES END

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysql]
no-auto-rehash
#safe-updates

[mysqld]
port     = 3306
datadir  = /mysql/data
socket   = /var/lib/mysql/mysql.sock
pid-file = /mysql/data/mysqld.pid
skip-external-locking
key_buffer = 32M
max_allowed_packet = 8M
table_open_cache   = 256
max_connections    = 1024
max_connect_errors = 10000
sort_buffer_size   = 1M
read_buffer_size   = 1M
myisam_sort_buffer_size = 1M
thread_cache       = 256
query_cache_size   = 16M # i think need a cache?
query_cache_type   = 1
thread_concurrency = 2 # Try number of CPU's*2 for thread_concurrency
tmp_table_size     = 64M
max_heap_table_size = 64M
skip-name-resolve
character-set-server = utf8
default-storage-engine = InnoDB

log-bin         = /mysql/arclog/mysql-bin
max_binlog_size = 200M
relay-log       = /mysql/arclog/relay-mysql-bin
binlog_format   = mixed
log_slave_updates
replicate-ignore-db = mysql

slow_query_log      = 1
slow_query_log_file = /mysql/data/slow.log
log-error           = /mysql/data/error.log
long_query_time     = 3

innodb_strict_mode
innodb_file_per_table
innodb_flush_method       = O_DIRECT
innodb_data_file_path     = ibdata1:10M:autoextend
innodb_data_home_dir      = /mysql/innodb
innodb_file_format        = Barracuda
innodb_write_io_threads   = 8
innodb_read_io_threads    = 8
innodb_thread_concurrency = 16
innodb_log_file_size      = 32M
innodb_log_buffer_size    = 8M
innodb_log_files_in_group = 2
innodb_lock_wait_timeout  = 120
innodb_flush_log_at_trx_commit = 1
innodb_additional_mem_pool_size = 20M

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer       = 8M
sort_buffer_size = 8M
read_buffer      = 1M
write_buffer     = 0M

[mysqld_safe]
open-files-limit = 8192