Using the above table, except that I set max_connections to 500, here's my results:
Aborted_clients 51113 (<- is this bad?)
Aborted_connects 4
Bytes_received 3376166447
Bytes_sent 3405372917
Com_admin_commands 0
Com_alter_table 30
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 2021507
Com_change_master 0
Com_check 0
Com_commit 0
Com_create_db 4
Com_create_function 0
Com_create_index 0
Com_create_table 39
Com_delete 200047
Com_drop_db 9
Com_drop_function 0
Com_drop_index 0
Com_drop_table 12
Com_flush 0
Com_grant 0
Com_insert 237163
Com_insert_select 45
Com_kill 0
Com_load 0
Com_load_master_table 0
Com_lock_tables 22
Com_optimize 3
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 332505
Com_replace_select 11
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_select 21723894
Com_set_option 1885
Com_show_binlogs 0
Com_show_create 645
Com_show_databases 175
Com_show_fields 726
Com_show_grants 0
Com_show_keys 142
Com_show_logs 0
Com_show_master_status 0
Com_show_open_tables 0
Com_show_processlist 0
Com_show_slave_status 0
Com_show_status 231111
Com_show_innodb_status 0
Com_show_tables 3092
Com_show_variables 132
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 0
Com_update 1163994
Connections 1821203
Created_tmp_disk_tables 78593
Created_tmp_tables 1292305
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 238813
Handler_read_first 407784
Handler_read_key 1284799277
Handler_read_next 866748024
Handler_read_prev 30484
Handler_read_rnd 227865353
Handler_read_rnd_next 2412233576
Handler_update 1248649039
Handler_write 124971966
Key_blocks_used 62341
Key_read_requests 158577939
Key_reads 8497
Key_write_requests 1673918
Key_writes 728877
Max_used_connections 202
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 501
Open_files 916
Open_streams 0
Opened_tables 838
Questions 27460721
Select_full_join 3070
Select_full_range_join 1
Select_range 1895690
Select_range_check 0
Select_scan 2913644
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 0
Variable_name Value
Slow_queries 17
Sort_merge_passes 0
Sort_range 2490289
Sort_rows 321864749
Sort_scan 1759843
Table_locks_immediate 25094330
Table_locks_waited 5539
Threads_cached 119
Threads_created 203
Threads_connected 84
Threads_running 1
Uptime 983392
Per your suggestions, I set:
[mysqld]
datadir = /home/mySQL
socket = /home/mySQL/mysql.sock
skip-locking
skip-innodb
set-variable = max_connections=500
set-variable = key_buffer=64M
set-variable = join_buffer=4M
set-variable = record_buffer=1M
set-variable = sort_buffer=8M
set-variable = table_cache=600
set-variable = wait_timeout=1000
set-variable = connect_timeout=3
set-variable = max_allowed_packet=4M
set-variable = max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=2
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open-files-limit=4096
[mysqlhotcopy]
interactive-timeout
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=16M
set-variable = sort_buffer=16M
set-variable = read_buffer=4M
set-variable = write_buffer=4M
