Exporting 5 Million Rows Without Killing the Database: Keyset Seek, JDBC Buffers & net_write_timeout
Physical engine mechanics of large-scale database exports: why LIMIT OFFSET degrades linearly, keyset pagination pitfalls, Go streaming vs Java JDBC OutOfMemoryError, and an anatomy of the net_write_timeout socket failure.