How does this my.cnf look?

[Prince]

Server: Pentium 4 - 2.4gig
RAM: 512meg
Drive: 36gig SCSI drive
OS: Linux


[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
tmpdir=/home/tmp
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=450
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=7200
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10

[safe_mysqld]
open_files_limit=8192

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
safe-updates

[isamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

[eva2000]

looks fine to me if you're using mysql 3.23.x series, if you're using mysql 4.0.x you should enable query caching

[Prince]

okay, thanks :)