Re: TCP TIME_WAIT strange problem ( LINUX mysql 3.23.49 )
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
Re: TCP TIME_WAIT strange problem ( LINUX mysql 3.23.49 )
Hi, What is written in err.log (/var/lib/mysql) ? I think you have some problems with network (switch or hub). Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - 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 - 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
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 | |