Fri Jul 3 21:00:01 PDT 2009 top - 21:00:02 up 218 days, 13:48, 1 user, load average: 0.17, 0.30, 0.28 Tasks: 196 total, 1 running, 194 sleeping, 0 stopped, 1 zombie Cpu(s): 4.6% us, 2.3% sy, 0.5% ni, 89.9% id, 2.6% wa, 0.0% hi, 0.0% si Mem: 4154452k total, 4062424k used, 92028k free, 22016k buffers Swap: 2096472k total, 40008k used, 2056464k free, 2875380k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 7904 nobody 15 0 3984 952 672 R 0.0 0.0 0:00.00 top Http processes currently running = 110 Mysql processes currently running = 4 Netstat information summary 1 0 ESTABLISHED 1 0 FIN_WAIT2 1 1 FIN_WAIT2 1 1 TIME_WAIT 1 2 ESTABLISHED 1 2 FIN_WAIT2 1 :33894 ESTABLISHED 1 3 FIN_WAIT1 1 4 TIME_WAIT 1 5 TIME_WAIT 1 6 TIME_WAIT 1 7 FIN_WAIT2 1 8 FIN_WAIT2 1 9 ESTABLISHED 1 9 TIME_WAIT 2 1 ESTABLISHED 2 4 ESTABLISHED 2 6 ESTABLISHED 3 0 TIME_WAIT 3 2 TIME_WAIT 3 3 ESTABLISHED 3 5 ESTABLISHED 3 7 TIME_WAIT 3 8 TIME_WAIT 3 FIN_WAIT1 3 LAST_ACK 4 SYN_RECV 30 LISTEN 40 ESTABLISHED 47 FIN_WAIT2 101 TIME_WAIT +----------------------------+------------+ | Variable_name | Value | +----------------------------+------------+ | Aborted_clients | 90 | | Aborted_connects | 0 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Bytes_received | 111110692 | | Bytes_sent | 1679283291 | | Com_admin_commands | 107 | | Com_alter_db | 0 | | Com_alter_table | 0 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_change_db | 145191 | | Com_change_master | 0 | | Com_check | 0 | | Com_checksum | 0 | | Com_commit | 0 | | Com_create_db | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_dealloc_sql | 0 | | Com_delete | 1235 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_drop_user | 0 | | Com_execute_sql | 0 | | Com_flush | 0 | | Com_grant | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 6738 | | Com_insert_select | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table | 0 | | Com_lock_tables | 65 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_prepare_sql | 0 | | Com_purge | 0 | | Com_purge_before_date | 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 14812 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_restore_table | 0 | | Com_revoke | 0 | | Com_revoke_all | 0 | | Com_rollback | 0 | | Com_savepoint | 0 | | Com_select | 99280 | | Com_set_option | 130289 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_charsets | 0 | | Com_show_collations | 0 | | Com_show_column_types | 0 | | Com_show_create_db | 0 | | Com_show_create_table | 0 | | Com_show_databases | 0 | | Com_show_errors | 0 | | Com_show_fields | 0 | | Com_show_grants | 0 | | Com_show_innodb_status | 0 | | Com_show_keys | 0 | | Com_show_logs | 0 | | Com_show_master_status | 0 | | Com_show_ndb_status | 0 | | Com_show_new_master | 0 | | Com_show_open_tables | 0 | | Com_show_privileges | 0 | | Com_show_processlist | 54 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 32 | | Com_show_storage_engines | 0 | | Com_show_tables | 0 | | Com_show_variables | 3 | | Com_show_warnings | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_stmt_close | 0 | | Com_stmt_execute | 0 | | Com_stmt_prepare | 0 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Com_truncate | 0 | | Com_unlock_tables | 65 | | Com_update | 74549 | | Com_update_multi | 0 | | Connections | 145283 | | Created_tmp_disk_tables | 140 | | Created_tmp_files | 77 | | Created_tmp_tables | 19376 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 1513 | | Handler_discover | 0 | | Handler_read_first | 877 | | Handler_read_key | 7214932 | | Handler_read_next | 14760096 | | Handler_read_prev | 169403 | | Handler_read_rnd | 459810 | | Handler_read_rnd_next | 16072325 | | Handler_rollback | 0 | | Handler_update | 2248087 | | Handler_write | 1305855 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 743184 | | Key_blocks_used | 75212 | | Key_read_requests | 21312474 | | Key_reads | 75353 | | Key_write_requests | 20933 | | Key_writes | 12993 | | Max_used_connections | 282 | | Not_flushed_delayed_rows | 0 | | Open_files | 1089 | | Open_streams | 0 | | Open_tables | 1027 | 67% of table_cache in use | Opened_tables | 1033 | | Qcache_free_blocks | 1659 | | Qcache_free_memory | 59950080 | | Qcache_hits | 320022 | | Qcache_inserts | 98404 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 876 | | Qcache_queries_in_cache | 3274 | | Qcache_total_blocks | 8337 | | Questions | 937577 | | Rpl_status | NULL | | Select_full_join | 6 | | Select_full_range_join | 0 | | Select_range | 21611 | | Select_range_check | 0 | | Select_scan | 15630 | | Slave_open_temp_tables | 0 | | Slave_retried_transactions | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 9 | (execution time > 10 secs) | Sort_merge_passes | 99 | | Sort_range | 8884 | | Sort_rows | 4343226 | | Sort_scan | 15665 | | Table_locks_immediate | 258611 | | Table_locks_waited | 2527 | | Threads_cached | 277 | | Threads_connected | 5 | | Threads_created | 282 | | Threads_running | 1 | | Uptime | 7036 | 1 hr 57 mins 16 secs +----------------------------+------------+ Key Reads/Key Read Requests = 0.003536 (Cache hit = 99.996464%) Key Writes/Key Write Requests = 0.620695 Connections/second = 20.649 (/hour = 74334.679) KB received/second = 15.422 (/hour = 55517.567) KB sent/second = 233.076 (/hour = 839074.758) Temporary Tables Created/second = 2.754 (/hour = 9913.815) Opened Tables/second = 0.147 (/hour = 528.539) Slow Queries/second = 0.001 (/hour = 4.605) % of slow queries = 0.001% Queries/second = 133.254 (/hour = 479715.350) MySQL Query Cache hits = 320022/419302(76%)