Ken, Thanks for that info, the SHOW PROCESSLIST command was exactly what I needed. It shows we're running about 50 some odd connections which is just about right.
mysql> show processlist; +-----+----------+-------------+----------+-------------+-------+------- --------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+----------+-------------+----------+-------------+-------+------- --------------------------------------+------------------+ | 14 | telaurus | 10.32.1.5 | telaurus | Sleep | 11 | | NULL | | 15 | telaurus | 10.32.1.5 | telaurus | Sleep | 8850 | | NULL | | 16 | telaurus | 10.32.1.5 | telaurus | Sleep | 10479 | | NULL | | 17 | telaurus | 10.32.1.5 | telaurus | Sleep | 432 | | NULL | | 18 | telaurus | 10.32.1.5 | telaurus | Sleep | 10478 | | NULL | | 20 | telaurus | 10.32.1.5 | telaurus | Sleep | 10455 | | NULL | | 21 | telaurus | 10.32.1.5 | telaurus | Sleep | 0 | | NULL | | 22 | telaurus | 10.32.1.5 | telaurus | Sleep | 931 | | NULL | | 23 | telaurus | 10.32.1.5 | telaurus | Sleep | 10477 | | NULL | | 30 | telaurus | 10.32.1.2 | telaurus | Sleep | 1489 | | NULL | | 31 | telaurus | 10.32.1.2 | telaurus | Sleep | 288 | | NULL | | 32 | telaurus | 10.32.1.2 | telaurus | Sleep | 4987 | | NULL | | 33 | repli | 10.32.1.12 | NULL | Binlog Dump | 10345 | Slave connection: waiting for binlog update | NULL | | 34 | telaurus | 10.32.1.2 | telaurus | Sleep | 501 | | NULL | | 35 | telaurus | 10.32.1.2 | telaurus | Sleep | 46 | | NULL | | 36 | telaurus | 10.32.1.2 | telaurus | Sleep | 5 | | NULL | | 37 | telaurus | 10.32.1.102 | telaurus | Sleep | 10254 | | NULL | | 38 | telaurus | 10.32.1.102 | telaurus | Sleep | 10253 | | NULL | | 39 | telaurus | 10.32.1.102 | telaurus | Sleep | 10252 | | NULL | | 40 | telaurus | 10.32.1.102 | telaurus | Sleep | 10247 | | NULL | | 41 | telaurus | 10.32.1.102 | telaurus | Sleep | 10247 | | NULL | | 42 | telaurus | 10.32.1.102 | telaurus | Sleep | 10244 | | NULL | | 43 | telaurus | 10.32.1.102 | telaurus | Sleep | 10244 | | NULL | | 44 | telaurus | 10.32.1.102 | telaurus | Sleep | 10244 | | NULL | | 45 | telaurus | 10.32.1.102 | telaurus | Sleep | 10242 | | NULL | | 46 | telaurus | 10.32.1.102 | telaurus | Sleep | 10242 | | NULL | | 47 | telaurus | 10.32.1.102 | telaurus | Sleep | 10241 | | NULL | | 48 | telaurus | 10.32.1.102 | telaurus | Sleep | 10185 | | NULL | | 49 | telaurus | 10.32.1.102 | telaurus | Sleep | 10241 | | NULL | | 50 | telaurus | 10.32.1.102 | telaurus | Sleep | 10241 | | NULL | | 51 | telaurus | 10.32.1.102 | telaurus | Sleep | 10241 | | NULL | | 52 | telaurus | 10.32.1.102 | telaurus | Sleep | 10241 | | NULL | | 53 | telaurus | 10.32.1.102 | telaurus | Sleep | 10241 | | NULL | | 54 | telaurus | 10.32.1.102 | telaurus | Sleep | 10241 | | NULL | | 55 | telaurus | 10.32.1.102 | telaurus | Sleep | 10241 | | NULL | | 56 | telaurus | 10.32.1.102 | telaurus | Sleep | 10241 | | NULL | | 57 | telaurus | 10.32.1.102 | telaurus | Sleep | 10220 | | NULL | | 58 | telaurus | 10.32.1.102 | telaurus | Sleep | 10181 | | NULL | | 59 | telaurus | 10.32.1.102 | telaurus | Sleep | 10241 | | NULL | | 60 | telaurus | 10.32.1.102 | telaurus | Sleep | 10218 | | NULL | | 61 | telaurus | 10.32.1.102 | telaurus | Sleep | 10182 | | NULL | | 62 | telaurus | 10.32.1.102 | telaurus | Sleep | 10220 | | NULL | | 63 | telaurus | 10.32.1.102 | telaurus | Sleep | 10238 | | NULL | | 64 | telaurus | 10.32.1.102 | telaurus | Sleep | 10181 | | NULL | | 65 | telaurus | 10.32.1.102 | telaurus | Sleep | 10218 | | NULL | | 66 | telaurus | 10.32.1.102 | telaurus | Sleep | 10181 | | NULL | | 67 | telaurus | 10.32.1.102 | telaurus | Sleep | 10238 | | NULL | | 68 | telaurus | 10.32.1.102 | telaurus | Sleep | 10216 | | NULL | | 69 | telaurus | 10.32.1.102 | telaurus | Sleep | 10237 | | NULL | | 258 | telaurus | 10.32.1.2 | telaurus | Sleep | 89 | | NULL | | 309 | root | localhost | NULL | Query | 0 | NULL | show processlist | +-----+----------+-------------+----------+-------------+-------+------- --------------------------------------+------------------+ 51 rows in set (0.00 sec) Jeff McKeon > -----Original Message----- > From: Ken Menzel [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2003 10:16 AM > To: Jeff McKeon > Cc: [EMAIL PROTECTED] > Subject: Re: Aborted clients > > > Hi Jeff, > > The two telling line for your aborted clients are > > *************************** 39. row *************************** > > Variable_name: max_connections > > Value: 100 > and > > > > | Max_used_connections | 100 | > > This means that you hit the limit. > Are saying you don't believe you should have 100 connections? > If you do SHOW PROCESSLIST are they all valid connections? > Do you need more than 100? Did you perhaps copy an example > config file or are you not using any config file? > > Have to run to a meeting now. Hope this bring some ideas to > the table. Ken > ----- Original Message ----- > From: "Jeff McKeon" <[EMAIL PROTECTED]> > To: "Ken Menzel" <[EMAIL PROTECTED]> > Sent: Friday, July 25, 2003 9:54 AM > Subject: RE: Aborted clients > > > > No, no changes to the max_connections. What we did > discover is that > > although this is a master db and not a slave of any, it was trying > to > > replicate to an unknown server (nothing in the master.info file) > with > > user "test". Nobody here recalls doing anything to set this up... > > > > FYI Variables.... > > > > mysql> show variables \G; > > *************************** 1. row *************************** > > Variable_name: back_log > > Value: 50 > > *************************** 2. row *************************** > > Variable_name: basedir > > Value: /usr/local/mysql/ > > *************************** 3. row *************************** > > Variable_name: binlog_cache_size > > Value: 32768 > > *************************** 4. row *************************** > > Variable_name: character_set > > Value: latin1 > > *************************** 5. row *************************** > > Variable_name: character_sets > > Value: latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 > > cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr > greek > > win1250 croat cp1257 latin5 > > *************************** 6. row *************************** > > Variable_name: concurrent_insert > > Value: ON > > *************************** 7. row *************************** > > Variable_name: connect_timeout > > Value: 5 > > *************************** 8. row *************************** > > Variable_name: datadir > > Value: /home/data/mysql/data/ > > *************************** 9. row *************************** > > Variable_name: delay_key_write > > Value: ON > > *************************** 10. row *************************** > > Variable_name: delayed_insert_limit > > Value: 100 > > *************************** 11. row *************************** > > Variable_name: delayed_insert_timeout > > Value: 300 > > *************************** 12. row *************************** > > Variable_name: delayed_queue_size > > Value: 1000 > > *************************** 13. row *************************** > > Variable_name: flush > > Value: OFF > > *************************** 14. row *************************** > > Variable_name: flush_time > > Value: 0 > > *************************** 15. row *************************** > > Variable_name: have_bdb > > Value: NO > > *************************** 16. row *************************** > > Variable_name: have_gemini > > Value: NO > > *************************** 17. row *************************** > > Variable_name: have_innodb > > Value: NO > > *************************** 18. row *************************** > > Variable_name: have_isam > > Value: YES > > *************************** 19. row *************************** > > Variable_name: have_raid > > Value: NO > > *************************** 20. row *************************** > > Variable_name: have_ssl > > Value: NO > > *************************** 21. row *************************** > > Variable_name: init_file > > Value: > > *************************** 22. row *************************** > > Variable_name: interactive_timeout > > Value: 28800 > > *************************** 23. row *************************** > > Variable_name: join_buffer_size > > Value: 131072 > > *************************** 24. row *************************** > > Variable_name: key_buffer_size > > Value: 8388600 > > *************************** 25. row *************************** > > Variable_name: language > > Value: /usr/local/mysql/share/mysql/english/ > > *************************** 26. row *************************** > > Variable_name: large_files_support > > Value: ON > > *************************** 27. row *************************** > > Variable_name: locked_in_memory > > Value: OFF > > *************************** 28. row *************************** > > Variable_name: log > > Value: OFF > > *************************** 29. row *************************** > > Variable_name: log_update > > Value: OFF > > *************************** 30. row *************************** > > Variable_name: log_bin > > Value: ON > > *************************** 31. row *************************** > > Variable_name: log_slave_updates > > Value: OFF > > *************************** 32. row *************************** > > Variable_name: log_long_queries > > Value: OFF > > *************************** 33. row *************************** > > Variable_name: long_query_time > > Value: 10 > > *************************** 34. row *************************** > > Variable_name: low_priority_updates > > Value: OFF > > *************************** 35. row *************************** > > Variable_name: lower_case_table_names > > Value: 0 > > *************************** 36. row *************************** > > Variable_name: max_allowed_packet > > Value: 1048576 > > *************************** 37. row *************************** > > Variable_name: max_binlog_cache_size > > Value: 4294967295 > > *************************** 38. row *************************** > > Variable_name: max_binlog_size > > Value: 1073741824 > > *************************** 39. row *************************** > > Variable_name: max_connections > > Value: 100 > > *************************** 40. row *************************** > > Variable_name: max_connect_errors > > Value: 10 > > *************************** 41. row *************************** > > Variable_name: max_delayed_threads > > Value: 20 > > *************************** 42. row *************************** > > Variable_name: max_heap_table_size > > Value: 16777216 > > *************************** 43. row *************************** > > Variable_name: max_join_size > > Value: 4294967295 > > *************************** 44. row *************************** > > Variable_name: max_sort_length > > Value: 1024 > > *************************** 45. row *************************** > > Variable_name: max_user_connections > > Value: 0 > > *************************** 46. row *************************** > > Variable_name: max_tmp_tables > > Value: 32 > > *************************** 47. row *************************** > > Variable_name: max_write_lock_count > > Value: 4294967295 > > *************************** 48. row *************************** > > Variable_name: myisam_recover_options > > Value: 0 > > *************************** 49. row *************************** > > Variable_name: myisam_max_extra_sort_file_size > > Value: 256 > > *************************** 50. row *************************** > > Variable_name: myisam_max_sort_file_size > > Value: 2047 > > *************************** 51. row *************************** > > Variable_name: myisam_sort_buffer_size > > Value: 8388608 > > *************************** 52. row *************************** > > Variable_name: net_buffer_length > > Value: 16384 > > *************************** 53. row *************************** > > Variable_name: net_read_timeout > > Value: 30 > > *************************** 54. row *************************** > > Variable_name: net_retry_count > > Value: 10 > > *************************** 55. row *************************** > > Variable_name: net_write_timeout > > Value: 60 > > *************************** 56. row *************************** > > Variable_name: open_files_limit > > Value: 0 > > *************************** 57. row *************************** > > Variable_name: pid_file > > Value: /home/data/mysql/data/db01tc0927.pid > > *************************** 58. row *************************** > > Variable_name: port > > Value: 3306 > > *************************** 59. row *************************** > > Variable_name: protocol_version > > Value: 10 > > *************************** 60. row *************************** > > Variable_name: record_buffer > > Value: 131072 > > *************************** 61. row *************************** > > Variable_name: record_rnd_buffer > > Value: 131072 > > *************************** 62. row *************************** > > Variable_name: query_buffer_size > > Value: 0 > > *************************** 63. row *************************** > > Variable_name: safe_show_database > > Value: OFF > > *************************** 64. row *************************** > > Variable_name: server_id > > Value: 1 > > *************************** 65. row *************************** > > Variable_name: slave_net_timeout > > Value: 3600 > > *************************** 66. row *************************** > > Variable_name: skip_locking > > Value: ON > > *************************** 67. row *************************** > > Variable_name: skip_networking > > Value: OFF > > *************************** 68. row *************************** > > Variable_name: skip_show_database > > Value: OFF > > *************************** 69. row *************************** > > Variable_name: slow_launch_time > > Value: 2 > > *************************** 70. row *************************** > > Variable_name: socket > > Value: /var/local/mysql/mysql.sock > > *************************** 71. row *************************** > > Variable_name: sort_buffer > > Value: 2097144 > > *************************** 72. row *************************** > > Variable_name: sql_mode > > Value: 0 > > *************************** 73. row *************************** > > Variable_name: table_cache > > Value: 64 > > *************************** 74. row *************************** > > Variable_name: table_type > > Value: MYISAM > > *************************** 75. row *************************** > > Variable_name: thread_cache_size > > Value: 0 > > *************************** 76. row *************************** > > Variable_name: thread_stack > > Value: 65536 > > *************************** 77. row *************************** > > Variable_name: transaction_isolation > > Value: READ-COMMITTED > > *************************** 78. row *************************** > > Variable_name: timezone > > Value: UTC > > *************************** 79. row *************************** > > Variable_name: tmp_table_size > > Value: 33554432 > > *************************** 80. row *************************** > > Variable_name: tmpdir > > Value: /tmp/ > > *************************** 81. row *************************** > > Variable_name: version > > Value: 3.23.41-log > > *************************** 82. row *************************** > > Variable_name: wait_timeout > > Value: 28800 > > > > 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.*** > > > > > > > > > -----Original Message----- > > > From: Ken Menzel [mailto:[EMAIL PROTECTED] > > > Sent: Friday, July 25, 2003 9:47 AM > > > To: Jeff McKeon; MySQL LIST > > > Subject: Re: Aborted clients > > > > > > > > > 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]
