Hi, "TIME_WAIT" said to you that are still packet in the network which are unhandled after socket it's closed. The question is: ... why happend this?
IFCONFIG show you information about network interfaces which is mounted in your computer and not about entire network. Regards, Gelu _____________________________________________________ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] ----- Original Message ----- From: "David BORDAS" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Gelu Gogancea" <[EMAIL PROTECTED]> Sent: Wednesday, July 03, 2002 10:21 PM Subject: Re: TCP & TIME_WAIT strange problem ( LINUX & mysql 3.23.49 ) > > Hi, > > What is written in err.log ("/var/lib/mysql") ? > nothing :( > something like > mysql started and ready for connection > > > I think you have some problems with network (switch or hub). > Euh network hardware i don't think, perhaps a problem with software but may > be strange 'cause ifconfig says that all is ok : > > > ifconfig show me that me eth0 config is clear : > > > UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 > > > RX packets:17728939 errors:0 dropped:0 overruns:0 frame:0 > > > TX packets:10940614 errors:0 dropped:0 overruns:0 carrier:0 > > > collisions:0 lg file transmission:100 > > > RX bytes:1689574777 (1611.3 Mb) TX bytes:347460048 (331.3 Mb) > > Here's the show status : > +--------------------------+------------+ > | Variable_name | Value | > +--------------------------+------------+ > | Aborted_clients | 3467 | > | Aborted_connects | 24 | > | Bytes_received | 128250456 | > | Bytes_sent | 2317251152 | > | Com_admin_commands | 0 | > | Com_alter_table | 0 | > | Com_analyze | 0 | > | Com_backup_table | 0 | > | Com_begin | 0 | > | Com_change_db | 1 | > | Com_change_master | 0 | > | Com_check | 0 | > | Com_commit | 0 | > | Com_create_db | 0 | > | Com_create_function | 0 | > | Com_create_index | 0 | > | Com_create_table | 0 | > | Com_delete | 1107 | > | Com_drop_db | 0 | > | Com_drop_function | 0 | > | Com_drop_index | 0 | > | Com_drop_table | 0 | > | Com_flush | 0 | > | Com_grant | 0 | > | Com_insert | 28257 | > | Com_insert_select | 0 | > | Com_kill | 0 | > | Com_load | 0 | > | Com_load_master_table | 0 | > | Com_lock_tables | 0 | > | Com_optimize | 0 | > | Com_purge | 0 | > | Com_rename_table | 0 | > | Com_repair | 0 | > | Com_replace | 0 | > | Com_replace_select | 0 | > | Com_reset | 0 | > | Com_restore_table | 0 | > | Com_revoke | 0 | > | Com_rollback | 0 | > | Com_select | 614872 | > | Com_set_option | 1 | > | Com_show_binlogs | 0 | > | Com_show_create | 1 | > | Com_show_databases | 0 | > | Com_show_fields | 1 | > | Com_show_grants | 0 | > | Com_show_keys | 1 | > | Com_show_logs | 0 | > | Com_show_master_stat | 0 | > | Com_show_open_tables | 0 | > | Com_show_processlist | 11 | > | Com_show_slave_stat | 0 | > | Com_show_status | 6 | > | Com_show_tables | 2 | > | Com_show_variables | 1 | > | Com_slave_start | 0 | > | Com_slave_stop | 0 | > | Com_truncate | 0 | > | Com_unlock_tables | 0 | > | Com_update | 25456 | > | Connections | 425680 | > | Created_tmp_disk_tables | 0 | > | Created_tmp_tables | 1 | > | Created_tmp_files | 32 | > | Delayed_insert_threads | 0 | > | Delayed_writes | 0 | > | Delayed_errors | 0 | > | Flush_commands | 1 | > | Handler_delete | 2551 | > | Handler_read_first | 1 | > | Handler_read_key | 621052 | > | Handler_read_next | 2015869637 | > | Handler_read_prev | 0 | > | Handler_read_rnd | 993404 | > | Handler_read_rnd_next | 24207000 | > | Handler_update | 25408 | > | Handler_write | 28606 | > | Key_blocks_used | 48213 | > | Key_read_requests | 85661529 | > | Key_reads | 47254 | > | Key_write_requests | 145118 | > | Key_writes | 107980 | > | Max_used_connections | 180 | > | Not_flushed_key_blocks | 37 | > | Not_flushed_delayed_rows | 0 | > | Open_tables | 186 | > | Open_files | 190 | > | Open_streams | 0 | > | Opened_tables | 192 | > | Questions | 1091817 | > | Select_full_join | 0 | > | Select_full_range_join | 0 | > | Select_range | 34 | > | Select_range_check | 0 | > | Select_scan | 20273 | > | Slave_running | OFF | > | Slave_open_temp_tables | 0 | > | Slow_launch_threads | 0 | > | Slow_queries | 1052 | > | Sort_merge_passes | 16 | > | Sort_range | 33150 | > | Sort_rows | 993404 | > | Sort_scan | 8522 | > | Table_locks_immediate | 556209 | > | Table_locks_waited | 113411 | > | Threads_cached | 0 | > | Threads_created | 65680 | > | Threads_connected | 92 | > | Threads_running | 87 | > | Uptime | 132998 | > +--------------------------+------------+ > 111 rows in set (0.00 sec) > > Thanks > David > > > ----- Original Message ----- > > From: "David BORDAS" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, July 03, 2002 7:03 PM > > Subject: TCP & TIME_WAIT strange problem ( LINUX & mysql 3.23.49 ) > > > > > > > Hi list, > > > > > > I've got lots of troubles with one of my mysql dedicated server. > > > The problem occurs time to time ( during peac or idle time ). > > > In fact mysql seem not to answer all connections. > > > Netstat show several connections "TIME_WAIT" and show process_list only > > show > > > 1 ou 2 queries running ... > > > > > > But on other way, 80% of the time, mysql works and answers well. > > > At those moments netstat show lots of "ETABLISHED"; > > > > > > All connections are made through TCP/IP on a private LAN ( ip like > > > 192.168.x.xx ). > > > Server don't have access to internet. > > > > > > ifconfig show me that me eth0 config is clear : > > > UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 > > > RX packets:17728939 errors:0 dropped:0 overruns:0 frame:0 > > > TX packets:10940614 errors:0 dropped:0 overruns:0 carrier:0 > > > collisions:0 lg file transmission:100 > > > RX bytes:1689574777 (1611.3 Mb) TX bytes:347460048 (331.3 Mb) > > > > > > Here is the config : > > > > > > uname -a > > > Linux 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 2001 i686 unknown > > > Red Hat 7.2 > > > 2 * 1Ghz Intel > > > 1 Go of ram > > > 2 Go of swap > > > Raid 5 scsi hdds > > > > > > Running mysql 3.23.49 from mysql team tar.gz binary. > > > I've got only one MYISAM table like this : > > > 8922 jun 19 07:43 Forums.frm > > > 980150372 jui 3 17:24 Forums.MYD > > > 85792768 jui 3 17:24 Forums.MYI > > > > > > mysql> show table status; > > > > > > | Name | Type | Row_format | Rows | Avg_row_length | > > > Data_length | Max_data_length | Index_length | Data_free | > > > > > > +----------+--------+------------+---------+----------------+-------------+- > > > ----------------+--------------+-----------+ > > > | Forums | MyISAM | Dynamic | 3881810 | 252 | > > > 980155640 | 4294967295 | 85792768 | 0 | > > > > > > > > > | Name | Type | Row_format | Rows | Avg_row_length | > > > Data_length | Max_data_length | Index_length | Data_free | > > > > > > +----------+--------+------------+---------+----------------+-------------+- > > > ----------------+--------------+-----------+ > > > | Forums | MyISAM | Dynamic | 3881810 | 252 | > > > 980155640 | 4294967295 | 85792768 | 0 | > > > > > > > > > > > > my.cnf : > > > [mysqld] > > > port = 3306 > > > #socket = /tmp/mysql.sock > > > skip-locking > > > skip-name-resolve > > > set-variable = key_buffer=128M > > > set-variable = back_log=150 > > > set-variable = record_buffer=1M > > > set-variable = sort_buffer=2M > > > set-variable = max_allowed_packet=1M > > > set-variable = thread_stack=128K > > > set-variable = thread_cache_size=8 > > > set-variable = max_connections=700 > > > set-variable = max_connect_errors=100 > > > set-variable = table_cache=256 > > > set-variable = net_read_timeout=180 > > > set-variable = net_write_timeout=180 > > > set-variable = wait_timeout=3600 > > > > > > I don't where to search. > > > Is that an hardware problem ? > > > Why not but the server isn't old ( only 3 mounths ). > > > > > > Linux ? > > > Have a second mysq server with same hardware, same linux and same mysql > > and > > > this one don't have any problem. > > > > > > Best rgds > > > David > > > > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php