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
