> I just got done playing with this same scenario. > > If the task finishes locally OK, but totally dogs on the network, then you > may have a network issue, NOT a MySQL issue. > > 1) Make sure that the switch and boxes are set to full duplex operation. > This will eliminate collisions. Make sure that everything is REALLY running > full duplex. Don't assume that it just is.
Agreed. It's number one on the list for Monday :-) > 2) Make sure that your switch has a high enough internal bandwidth to handle > the full duplex traffic. Many older switches do not have the internal > backplane bandwidth between ports to support a lot of 100 Mbit traffic even > though they will accept 100 Mb full duplex connections on all ports. They > may have only a backplane bandwidth of 200-300 Mb and you can fill that up > with e-mail, internaet, etc. and leave nothing left over for server to > server traffic. Good point. > 3) Put the servers on a VLAN if possible to avoid other network traffic. Hmm, that maybe a problem. We've got *lots* of vlans floating round the network and some of the boxes have a 64-vlan limit (you don't want to *see* what happens when you exceed that number :-( ). > Symptoms of these problems are slow processing with none of your boxes > loaded up. top will show them idle and the completion time for your > processing will be painfully long. It will run fine locally, but, just > crater over the network. > > Sound familiar? > > When I made the above changes, I was able to change network throughput from > 12 Mb/sec between application server box and database server box to 160 > Mb/sec of traffic. top then showed the application boxes as totally busy > with no idle time. The MySQL box was never really taxed even at that > throughput level. > > Also, you can look to optimize your SQL (i.e.: multiple records inserted per > INSERT SQL command - see web for syntax) but that may not be your issue if > it worked OK on the local box. That's done - I send 1000 at a time. > I found that stringing several Athlon XP1800+ boxes together (my test > environment) I was able to max out the boxes before I maxed out the network > @ a true 100 Mb full duplex. > > Hope this helps! Thanks Ken, it does. Paul Wilson Chime Communications --------------------------------------------------------------------- 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
