> 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
