Understanding MySQL max_allowed_packet and Its Impact on Data Import, Binlog, and Query Results

This article explains the MySQL max_allowed_packet limit, how packets are structured and split, what operations count as a packet, and demonstrates through tests how the setting affects SQL imports, binlog replication, query results, and LOAD DATA operations.

BinlogDatabase PerformancePacket Size

0 likes · 7 min read

Understanding MySQL max_allowed_packet and Its Impact on Data Import, Binlog, and Query Results

MaGe Linux Operations

Apr 12, 2020 · Fundamentals

Why Do Root DNS Servers Return Only 13 IP Addresses? Understanding DNS Packet Limits

This article explains why a single recursive DNS query to a root server returns only 13 IP addresses by examining DNS packet structure, MTU constraints, UDP/TCP transport limits, and the 512‑byte size restriction that governs DNS responses.

DNSMTUPacket Size

0 likes · 4 min read

Why Do Root DNS Servers Return Only 13 IP Addresses? Understanding DNS Packet Limits

Liangxu Linux

Mar 17, 2020 · Fundamentals

How TCP Guarantees Reliable Data Transfer: Packets, Sequencing, and Flow Control Explained

This article provides a comprehensive overview of the TCP protocol, covering its role in the network stack, packet size limits, sequence numbering, how operating systems reassemble packets, the slow‑start mechanism, ACK handling, and strategies for detecting and recovering from lost packets.

NetworkingPacket SizeSequence Number

0 likes · 10 min read

How TCP Guarantees Reliable Data Transfer: Packets, Sequencing, and Flow Control Explained