On 1/8/2018 11:19 PM, Chas Honton wrote: > Don’t forget about any proxies or routers between the client and the server. > Most infrastructure components will close quiescent connections (within > minutes)
There are no proxies for the MySQL traffic. The machines involved are on the same subnet (vlan), so it's only layer 2 switches made by Cisco that provide the networking -- no routing. There is no QoS configured. The connections are gigabit and the switchports are not incrementing error counters. The inter-switch connections are trunk ports and also show no incrementing error counters. Cisco switches tend to have enough backplane bandwidth to run every port at full line rate in both directions. We don't run our infrastructure anywhere near full switching capacity, so dropped packets are unlikely, but even if that did happen, TCP is designed to handle that transparently to applications. Cisco routers and switches do not typically interfere in TCP communication. Their firewalls do get involved in TCP, but even if this traffic was passing through our firewall (which it's not), our TCP idle timeout on the firewall is set to two hours, to accommodate long-lived TCP connections over the Internet. Thanks, Shawn --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
