MySQL Configuration for Small Servers

my.cnf

# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# MySQL programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket      = /var/run/mysqld/mysqld.sock
nice        = 0

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
user            = mysql
port            = 3306
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql

skip-external-locking
key_buffer_size         = 8M
max_allowed_packet      = 1M
table_open_cache        = 64
sort_buffer_size        = 512K
net_buffer_length       = 8K
read_buffer_size        = 256K
read_rnd_buffer_size    = 512K
myisam_sort_buffer_size = 8M

#bind-address           = 127.0.0.1

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir      = /var/lib/mysql
innodb_data_file_path     = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size        = 8M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size           = 2M
innodb_log_buffer_size         = 4M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout       = 50

default-storage-engine = InnoDB

max-connections   = 15
query-cache-size  = 4M
query-cache-limit = 512K

thread-stack      = 128K
thread-cache-size = 1

slow-query-log
long_query_time   = 5

[mysqldump]
quick
max_allowed_packet = 8M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size  = 8M
sort_buffer_size = 8M
read_buffer      = 2M
write_buffer     = 2M

[mysqlhotcopy]
interactive-timeout