MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Ken Menzel Date:July 25 2003 1:46pm
Subject:Re: Aborted clients
View as plain text  
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" <jmckeon@stripped>
To: "MySQL LIST" <mysql@stripped>
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
> jmckeon@stripped
> (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/mysql?unsub=1
>
>

Thread
Aborted clientsJeff McKeon25 Jul
  • Re: Aborted clientsKen Menzel26 Jul
Re: Aborted clientsKen Menzel26 Jul
RE: Aborted clientsJeff McKeon26 Jul
RE: Aborted clientsJeff McKeon26 Jul