471,108 Members | 1,242 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

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
jm*****@telaurus.com
(973) 889-8990 ex 209=20

***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/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1447

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jeff McKeon | last post: by
2 posts views Thread by Moritz Beller | last post: by
2 posts views Thread by Alex Vinokur | last post: by
2 posts views Thread by Matthias | last post: by
2 posts views Thread by mahurshi | last post: by
1 post views Thread by Sunil Menon | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.