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]
