[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
max_connections = 100
max_allowed_packet = 16M
### Query cache settings ###
query_cache_type=1
query_cache_limit=4M
query_cache_size=64M
### tmp table cache settings ###
tmp_table_size = 64M
max_heap_table_size = 64M
### Buffer Size Settings ###
sort_buffer_size = 256K
read_buffer_size = 256K
join_buffer_size = 256K
### Key Buffer Settings ###
key_buffer_size = 1224M
thread_cache_size = 16
### Table cache ###
table_cache = 8192
### Log slow queries ###
slow-query-log = 1
slow-query-log-file = /var/log/mysql-slow-queries.log #Make sure this file exists and is owned by mysql.
long_query_time = 2
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M