Re: Too Many Aborted Connects
I know I'm not the only one experiencing this problem. The solutions recommended in the documentation haven't helped resolve it. I've heard of people using flush-hosts as a solution, but that's just a band-aid. Any ideas? - Original Message - From: Andy Etemadi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 12:37 PM Subject: Too Many Aborted Connects Redhat Linux 2.4.5-beta4va3.17smp-piii Dual Intel PIII/1GHz 2GB of memory 4x36GB SCSI HDDs in RAID5 mysql-3.23.52-pc-linux-gnu-i686 Experiencing 50% aborted connections (not aborted clients) over a small private network consisting of only 2 machines: the above mentioned machine and a web server running Apache 1.3.20 and PHP 4.1.2. This problem of too many aborted connections requires a flush-hosts every 2 minutes, during peak traffic. All traffic to the database comes from the web server. All connections are made by 4 users; 1 of those 4 is the most prominent. NICs on both servers are in full duplex mode. Can anyone shed some light on this problem? Thanks, -- Andy Etemadi - 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
Too Many Aborted Connects
Redhat Linux 2.4.5-beta4va3.17smp-piii Dual Intel PIII/1GHz 2GB of memory 4x36GB SCSI HDDs in RAID5 mysql-3.23.52-pc-linux-gnu-i686 Experiencing 50% aborted connections (not aborted clients) over a small private network consisting of only 2 machines: the above mentioned machine and a web server running Apache 1.3.20 and PHP 4.1.2. This problem of too many aborted connections requires a flush-hosts every 2 minutes, during peak traffic. All traffic to the database comes from the web server. All connections are made by 4 users; 1 of those 4 is the most prominent. NICs on both servers are in full duplex mode. Can anyone shed some light on this problem? Thanks, -- Andy Etemadi - 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
Too many Aborted Connects
Hi, We are getting too many Aborted_connects using mySQL version 3.22.32 on SunOS 5.8. Users connect to our site via an Apache/1.3.12 server to a PHP Verion 4.0.4pl1 website which connects to the mySQL database (which is on the same machine) via the PHP mysql_pconnect() command. Aborted_connects are currently 669514 grow by about 100 a second. Also some of the other variables seem to be rather large. Can any one suggest how I can stop this problem ? Thanks, Chris Parker Results from 'show status' Variable_name Value Aborted_clients 0 Aborted_connects 669514 Created_tmp_tables 141 Delayed_insert_threads 0 Delayed_writes 0 Delayed_errors 0 Flush_commands 1 Handler_delete 1683 Handler_read_first 54 Handler_read_key 720335 Handler_read_next 13528528 Handler_read_rnd 1269249023 Handler_update 8853 Handler_write 16416 Key_blocks_used 9567 Key_read_requests 5735748 Key_reads 9487 Key_write_requests 27404 Key_writes 19706 Max_used_connections 116 Not_flushed_key_blocks 0 Not_flushed_delayed_rows 0 Open_tables 341 Open_files 92 Open_streams 1 Opened_tables 347 Questions 244772 Running_threads 87 Slow_queries 5282 Uptime 7822