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
