/etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
old_passwords=1

low_priority_updates=1
concurrent_insert=2
max_heap_table_size=128M
tmp_table_size=128M
table_cache=1024
open_files_limit=1536
query_cache_size=8M
query_cache_limit=8MB
thread_cache_size=8
join_buffer_size=1MB
max_connections = 512
max_allowed_packet=6MB


[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid