Alibaba Cloud Developer

Nov 1, 2019 · Fundamentals

Why SQL Queries Are 10× Slower Over a 100M Line – TCP Send/Receive Buffer Insights

A 100 M dedicated line with 20 ms latency caused a 22 MB SQL query to take over 25 seconds, prompting an in‑depth analysis of how socket send/receive buffers, sysctl rmem/wmem settings, and TCP windows interact and affect network performance.