Aikesheng Open Source Community

Apr 23, 2024 · Databases

Root Cause Analysis of MySQL Aborted Connections Caused by TCP Buffer Exhaustion and Net Write Timeout

The article investigates why MySQL batch jobs experience aborted connections, tracing the issue to TCP buffer overflow on the client side, excessive ACK traffic, and the default net_write_timeout of 60 seconds, and proposes kernel tweaks and query optimizations to resolve the problem.