Thanks for the help John, I really don't know all the specifics of the hardware setup as it is all out at our ISP, I know its a rack mounted P4 and its going into a Cisco switch but that's about it.
We have made some progress though and as strange as it sounds its really looking like its something with RH 8, in short we downgraded perl 5.8 to 5.6.1 with no results, we then went from Apache 2 down to 1.3 with no results, then that night backup exec came through and the machine spiked to 100% - noticed it by luck of being on the machine at the same time, this pretty much took Apache, Perl and my code out of the question. Did up a new machine (same specs), put RH 7.3 on it, copied everything over and made it live.. Right before we switched over to the new machine we stopped throttling the server (it was the only way to stop those errors) and instantly those connection failures started happening like crazy. As soon as we made the switch, they all went away, load was cut in half and CPU idle went up around 30 to 40% and things were just screaming, 110% improvement in all areas. So you'd think everything was wonderful now, wouldn't you?.. Well check this out.. As soon as the new web server was brought up I started getting (and still get) tons of "Aborted connection ... (Got an error reading communication packets)" - and mySql has run without a flaw since day one, also the scripts and DBI and everything was exactly the same on the new web server from the old web server (mysql would have no knowledge of the switch). I can say I'm about 98% sure that everything mySql shows for this problem at: http://www.mysql.com/doc/en/Communication_errors.html Isn't a issue. As RH 8 is also running on the dedicated mySql machine, I'm starting to believe its the root of all my problems. Its been a wild week!! Thanks -Chris >> -----Original Message----- >> From: John P [mailto:[EMAIL PROTECTED]] >> Sent: Saturday, December 28, 2002 1:45 PM >> To: Chris Faust; [EMAIL PROTECTED] >> Subject: Re: Desperate - failed: Lost connection to MySQL server during >> query >> >> >> > If you are running close to the same setup with no problems >> then I feel a >> > little better about it not being a issue of pure traffic. >> >> Yes, we operate in a very similar way to you. (BTW, we have had very good >> results with a PHP based cache facility that simply stores the db driven >> pages over a selectable time period; good if your pages don't change that >> much! Capacity increased 4000% or so; would imagine something >> similar exists >> for perl) >> >> > I don't think the link between the machines is a issue, both >> machines are >> > dedicated and at the same location, I've tried using both the >> external and >> > internal (10.0.x.x) IP to connect to the DB with the same >> results and in >> all >> > cases both machines have had entries in their hosts file for >> one another. >> > >> > As for simultaneous connections, that is something that I >> still need to go >> > through the logs and come up with a real number for those time >> frames.. I >> > don't know anyway to see a real number of actual users using Apache via >> the >> > command line (is there such a thing?). >> >> I've always done ps -ef | grep httpd | wc -l a few times which shows the >> processes, you can get a good idea of whether the site is busy or not. I >> don't know how to actually find the exact number of users, I >> suppose netstat >> ? >> >> > One thing I wonder that I forgot to ask - does using IP address as the >> host >> > for a user in mySql matter? Meaning before DNS switched over I >> wanted to >> get >> > everything up and running so I created all the mysql user >> accounts based >> on >> > the IP address of the web server (and not name). >> > I would think if this were a issue at all I would be getting "denied" >> > messages and it wouldn't work 100% of the time, but I thought I would >> throw >> > it out there. >> >> I'd do everything by IP, especially for the "internal" stuff. >> >> It might be worth trying a dedicated cable+two separate network cards in >> each server to handle MySQL traffic. Just a thought, but could packets be >> getting lost between the two servers (network overloaded or out >> of ports on >> eth0 or ..?) >> >> Post your exact network setup (machines, switches/hubs etc) and >> that might >> give some more clues? >> >> Good luck >> John >> --------------------------------------------------------------------- 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
