Someone

System specifics:

Memory:
             total       used       free     shared    buffers     cached
Mem:       4045360    3744828     300532          0     141084    2512616
-/+ buffers/cache:    1091128    2954232
Swap:      8193016        160    8192856

CPU:

64 Bit - 2 processor hypertrading, which actually means 4 processor:

model name      :                   Intel(R) Xeon(TM) CPU 3.20GHz
stepping        : 3
cpu MHz         : 3192.160
cache size      : 2048 KB


Current my.cnf is just default from my-huge.cnf, except i uncommented the skip-networking, since i dont want any port to be open:

[client]
port            = 3306
socket          = /var/lib/mysql/mysql.sock

[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8

skip-networking

log-bin=mysql-bin

server-id       = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
safe-updates

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout



added stuff

thread_cache_size = 64
skip-name-resolve
big-tables
set-variable = max_allowed_packet=8M
set-variable = myisam_sort_buffer_size=512M
set-variable = sort_buffer=512M
set-variable = max_connections=256
set-variable = key_buffer=256M
set-variable = table_cache=1G
tmp_table_size = 1G