[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-locking
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
log-slow-queries = /var/log/mysql_slow_query_log
key_buffer = 384M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 2M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 7200
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 1000
read_rnd_buffer_size = 8M
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 264M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072


tail mysql_slow_query_log 
/usr/sbin/mysqld, Version: 4.1.21-standard-log. started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
/usr/sbin/mysqld, Version: 4.1.21-standard-log. started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument


top - 17:38:43 up 3 days, 12:50,  4 users,  load average: 6.00, 4.15, 3.75
Tasks: 260 total,   8 running, 249 sleeping,   0 stopped,   3 zombie
Cpu(s): 33.2% us, 26.8% sy,  0.5% ni, 36.2% id,  3.3% wa,  0.0% hi,  0.0% si
Mem:   8310548k total,  7044460k used,  1266088k free,   287520k buffers
Swap:  2040212k total,      144k used,  2040068k free,  5004260k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                        
14022 mysql     15   0  755m  78m 3068 S   83  1.0   3:25.36 mysqld                                                                                          
26033 nobody    15   0 28408  15m 3996 R   71  0.2   2:21.99 httpd