Tuning MySQL

[Eric Gunnett]

	I have a quad processor server, with 4 gigs of memory. It is only running MySQL right now
and seems really slow. Can someone give me a few suggestions on optimizing My.cnf file for
this system.  We are running mysql-standard-4.0.23-pc-linux-i68, on it. Here is the my.cnf
file

# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 2M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

user=mysql
basedir=/usr/local/mysql
datadir=/usr2/mysql/data
max_connections=400
max_connect_errors=300
interactive_timeout=2400
wait_timeout=60
back_log=100
#skip-networking
server-id       = 2

[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