[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

table_cache = 512
sort_buffer_size = 1M
max_allowed_packet = 1M
thread_concurrency = 16
thread_cache_size = 128
query_cache_type = 1
query_cache_limit = 32M
query_cache_size = 256M
bind-address=my.server's.ip.address
wait_timeout = 60
slow_query_log = 1
slow_query_log_file = site-slow.log
long_query_time = 10
max_connections = 200
tmpdir = /var/tmpfs
tmp_table_size = 2K
innodb_buffer_pool_size = 400M
innodb_buffer_pool_instances = 4
innodb_file_per_table
join_buffer_size = 4M
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid