[mysqld]
set-variable = max_connections=500
local-infile=0
safe-show-database
#bind-address=127.0.0.1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=100
interactive_timeout=20
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=256M #<---- for 1GB Memory, use 128M for 2GB Memory
join_buffer_size=4M #<---- increase to double for 2GB Ram, 1M->1GB Ram
max_allowed_packet=32M
table_cache=1024
sort_buffer_size=4M #<---- increase to double for 2GB Ram, 1M->1GB Ram
read_buffer_size=4M #<---- increase to double for 2GB Ram, 1M->1GB Ram
read_rnd_buffer_size=3072K #<---- increase to double for 2GB Ram, 768->1GB Ram
max_connect_errors=10
thread_concurrency=4 #<---- 2 for 1 CPU, use 4 for 2 CPU (eg. DC-4, Celeron-2)
myisam_sort_buffer_size=128M #<---- for 1GB Memory, use 64M for 2GB Memory
#skip-innodb
skip-locking
#log-bin
server-id=1
[mysql.server]
user=mysql
#basedir=/var/lib #<---- (comment out the line)
[safe_mysqld]
bind-address=127.0.0.1
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
SAFE_MYSQLD_OPTIONS="--defaults-file=/etc/my.cnf --log-slow-queries=/var/log/slow-queries.log"
#Make sure to do this in ssh command
#touch /var/log/slow-queries.log
#chmod 644 /var/log/slow-queries.log
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=256M #<---- increase to double for 2GB Ram, 64M->1GB Ram
sort_buffer=256M #<---- increase to double for 2GB Ram, 64M->1GB Ram
read_buffer=64M #<---- increase to double for 2GB Ram, 16M->1GB Ram
write_buffer=64M #<---- increase to double for 2GB Ram, 16M->1GB Ram
[myisamchk]
key_buffer=256M #<---- increase to double for 2GB Ram, 64M->1GB Ram
sort_buffer=256M #<---- increase to double for 2GB Ram, 64M->1GB Ram
read_buffer=64M #<---- increase to double for 2GB Ram, 16M->1GB Ram
write_buffer=64M #<---- increase to double for 2GB Ram, 16M->1GB Ram
[mysqlhotcopy]
interactive-timeout