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

Reply via email to