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]
