Dedicated server with one forum only:
# 2x Intel Xeon Quad 5405
# 8192 MB FB DDR2 RAM
# 500 GB 7.200 RPM - Sata2
# 1.000 Mb speed

# Latest Centos 64bit and mysql.

my.cnf:



Also if you have any other recommendations for system tuning let me know :)

Thank you

[mysqld]

port            = 3306

socket          = /var/lib/mysql/mysql.sock

skip-locking

skip-innodb

skip-bdb

key_buffer = 896M

max_allowed_packet = 1M

table_cache = 1024

sort_buffer_size = 8M

read_buffer_size = 8M

read_rnd_buffer_size = 8M

net_buffer_length = 2K

thread_stack = 64K

thread_cache_size = 4

table_cache = 64

query_cache_size = 256M

thread_concurrency = 4

log-slow-queries       = /var/log/mysql/mysql-slow.log

server-id = 1

skip-networking


[mysqldump]

quick

max_allowed_packet = 1M


[mysql]

no-auto-rehash

safe-updates


[isamchk]

key_buffer = 10M

sort_buffer_size = 2M


[myisamchk]

key_buffer = 10M

sort_buffer_size = 2M

hi, why you don't use the Tuning Primer Script?
after running this, you can diable log-slow-queries, wich use also a lot perfomance

The most adjusments are related to Tuning primer script and Sql tuner.