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