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: [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 Code (markup): Also if you have any other recommendations for system tuning let me know Thank you
Ur server looks pretty good but what type of sites are u using this for ? high traffic ? more cpu consuming ?