here is the data from 9 days of runtime:
| Aborted_clients | 1 |
| Aborted_connects | 0 |
| Bytes_received | 456633659 |
| Bytes_sent | 2910679325 |
| Connections | 753674 |
| Created_tmp_disk_tables | 13091 |
| Created_tmp_tables | 674493 |
| Created_tmp_files | 24 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 219916 |
| Handler_read_first | 14286 |
| Handler_read_key | 37732812 |
| Handler_read_next | 3996857474 |
| Handler_read_prev | 11 |
| Handler_read_rnd | 68586690 |
| Handler_read_rnd_next | 139301674 |
| Handler_update | 17083638 |
| Handler_write | 8468109 |
| Key_blocks_used | 7793 |
| Key_read_requests | 477691831 |
| Key_reads | 203820 |
| Key_write_requests | 2618089 |
| Key_writes | 1778777 |
| Max_used_connections | 110 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 256 |
| Open_files | 272 |
| Open_streams | 0 |
| Opened_tables | 266 |
| Questions | 11062801 |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 41775 |
| Select_range_check | 0 |
| Select_scan | 1379287 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 1 |
| Slow_queries | 1667 |
| Sort_merge_passes | 12 |
| Sort_range | 2836750 |
| Sort_rows | 119875080 |
| Sort_scan | 1326145 |
| Table_locks_immediate | 9726194 |
| Table_locks_waited | 484283 |
| Threads_cached | 62 |
| Threads_created | 199 |
| Threads_connected | 2 |
| Threads_running | 1 |
| Uptime | 775778 |
and the my.cnf that is running:
[mysqld]
socket=/var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=128
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=2M
set-variable = record_buffer=2M
set-variable = sort_buffer=4M
set-variable = table_cache=256
set-variable = thread_cache_size=64
set-variable = wait_timeout=9600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=4M
set-variable = write_buffer=4M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=4M
set-variable = write_buffer=4M
any thoughts/ideas/laughs?
