Hi Jeff, Just a quick guess did you change the max_connections variable up from the default of 100? You did not provide a show variables so I can only guess.
>From the [mysqld] section of /etc/my.cnf set-variable = max_connections=500 Ken ----- Original Message ----- From: "Jeff McKeon" <[EMAIL PROTECTED]> To: "MySQL LIST" <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 7:45 AM Subject: Aborted clients > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
