My server bogs down during peak hours (about 4pm to 8pm) and mysqld is always the first process listed in top (both by cpu and memory usage). I don't really know what I'm doing when it comest to server optimization but I took some suggestions from an old post I found on a different forum and came up with the following my.cnf. I've been running it for about a week now and haven't noticed any major improvents. Code: [mysqld] tmpdir=/backup/mysqltmp datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). #old_passwords=1 skip-locking skip-innodb query_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=500 interactive_timeout=100 wait_timeout=7200 connect_timeout=10 thread_cache_size=128 key_buffer=150M join_buffer_size=1M max_allowed_packet=16M table_cache=1500 read_buffer_size=1M sort_buffer_size=1M read_buffer_size=1M read_rnd_buffer_size=768K max_connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=64M server-id=1 [mysql.server] user=mysql basedir=/var/lib old-passwords = 1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout MySQL client version: 4.1.22 The server I'm running this on is: Kentsfield Xeon 3210 2.13GHz Quad Core 4GB DDR2 667 ECC RAM Dual 73GB 15kRPM SCSI HDD's (/var/lib/mysql is partitioned on its own drive) Info from phpMyAdmin: Anyone notice any changes I could make or major issues I might have with the settings in my.cnf?