My.cnf
i have a p4 2.4 with 1gb ram on rh9 + cpanel and i have a high mysql usage, here's the my.cnf that i am using
[mysqld]
set-variable = max_connections=500
set-variable = interactive_timeout=60
set-variable = wait_timeout=60
set-variable = connect_timeout=10
set-variable = thread_cache_size=8
set-variable = key_buffer=384M
set-variable = max_allowed_packet=32M
set-variable = table_cache=1024
set-variable = sort_buffer=4M
set-variable = record_buffer=4M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=4
set-variable = myisam_sort_buffer_size=64M
set-variable = query_cache_limit=2M
set-variable = query_cache_size=64M
set-variable = query_cache_type=1
[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
what can i optimze? or you can post a better configuration?
