Ver 3.23 on RH Linux. We came in this morning and were greeted by our DB server rejecting connections to the db from our application. There seems to be a high number of Aborted_clients. How can we tell what clients/connections are causing this?
mysql> show status; +--------------------------+------------+ | Variable_name | Value | +--------------------------+------------+ | Aborted_clients | 149 | | Aborted_connects | 122 | | Bytes_received | 422801700 | | Bytes_sent | 3604618252 | | Connections | 7375 | | Created_tmp_disk_tables | 885 | | Created_tmp_tables | 20331 | | Created_tmp_files | 509 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 2 | | Handler_delete | 5252 | | Handler_read_first | 35028 | | Handler_read_key | 95425837 | | Handler_read_next | 2978256304 | | Handler_read_prev | 0 | | Handler_read_rnd | 7727972 | | Handler_read_rnd_next | 3143081074 | | Handler_update | 45487 | | Handler_write | 2010283 | | Key_blocks_used | 7793 | | Key_read_requests | 585802473 | | Key_reads | 18261 | | Key_write_requests | 3740894 | | Key_writes | 254091 | | Max_used_connections | 100 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 64 | | Open_files | 109 | | Open_streams | 0 | | Opened_tables | 252 | | Questions | 5171955 | | Select_full_join | 881 | | Select_full_range_join | 0 | | Select_range | 22 | | Select_range_check | 0 | | Select_scan | 280668 | | Slave_running | ON | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 138 | | Sort_merge_passes | 254 | | Sort_range | 474 | | Sort_rows | 40227394 | | Sort_scan | 22550 | | Table_locks_immediate | 5695456 | | Table_locks_waited | 8278 | | Threads_cached | 0 | | Threads_created | 7373 | | Threads_connected | 97 | | Threads_running | 2 | | Uptime | 317854 | +--------------------------+------------+ Jeff McKeon IT Manager Telaurus Communications LLC [EMAIL PROTECTED] (973) 889-8990 ex 209 ***The information contained in this communication is confidential. It is intended only for the sole use of the recipient named above and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication, or any of its contents or attachments, is expressly prohibited. If you have received this communication in error, please re-send it to the sender and delete the original message, and any copy of it, from your computer system. Thank You.*** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
