Hey guys...first off Happy New Years!I have been trying to tweak / optimize my sites my.cnf based on suggestions from this site and via google searches. I just wanted to post what I currently have to get some second opinions. The site is currently running on a dedicated pentium dual core with 4GB RAM. The current my.cnf are as follows:[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
server-id=1
port=3306
socket=/var/lib/mysql/mysql.sock
key_buffer=64M
max_allowed_packet=16M
join_buffer_size=1M
sort_buffer_size=2M
read_buffer_size=1M
myisam_sort_buffer_size=64M
thread_cache=1024
thread_cache_size=80
interactive_timeout=30
wait_timeout=40
connect_timeout=10
query_cache_limit=1M
query_cache_size=64M
query_cache_type=1
tmp_table_size=512M
thread_concurrency=2
pid-file=/var/run/mysqld/mysqld.pid
# memory=key_buffer+(sort_buffer_size+read_buffer_size)*max_connections
max_connections=600
max_user_connections=400
max_connect_errors=10
table_cache=2400
old_passwords=1
key_buffer_size=256M
log-slow-queries = /var/log/mysql-slow.log
long_query_time = 1
low_priority_updates=1concurrent_insert=2skip-bdb
skip-name-resolve
skip-locking#skip-locking
#skip-innodb[mysqld_safe]
err-log=/var/log/mysqld.log
open_files_limit = 8192[mysqldump]
quick
max_allowed_packet = 16M[mysql]
no-auto-rehash[isamchk]read more

Adaugat in