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
