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