DEV Community

Binary Dose Deep Dives Series' Articles

Back to Binary Dose's Series
Why Do Database Indexes Slow Down INSERTs? (The B+ Tree Page Split Dilemma)

Why Do Database Indexes Slow Down INSERTs? (The B+ Tree Page Split Dilemma)

1
Comments
2 min read
Error Detection: Parity, Checksum & Cyclic Redundancy Check (CRC)
Cover image for Error Detection: Parity, Checksum & Cyclic Redundancy Check (CRC)

Error Detection: Parity, Checksum & Cyclic Redundancy Check (CRC)

Comments
2 min read
Why Systems Freeze Forever: The 4 Deadlock Conditions Explained with Code
Cover image for Why Systems Freeze Forever: The 4 Deadlock Conditions Explained with Code

Why Systems Freeze Forever: The 4 Deadlock Conditions Explained with Code

Comments
2 min read
Why Servers Crash Under High Traffic: The TCP TIME_WAIT Trap
Cover image for Why Servers Crash Under High Traffic: The TCP TIME_WAIT Trap

Why Servers Crash Under High Traffic: The TCP TIME_WAIT Trap

Comments
2 min read
How Relational Databases Prevent Data Corruption: Two-Phase Locking (2PL)
Cover image for How Relational Databases Prevent Data Corruption: Two-Phase Locking (2PL)

How Relational Databases Prevent Data Corruption: Two-Phase Locking (2PL)

Comments
2 min read
The Hidden Hardware Cost of Multi-Tasking: Context Switching & TLB Flushes
Cover image for The Hidden Hardware Cost of Multi-Tasking: Context Switching & TLB Flushes

The Hidden Hardware Cost of Multi-Tasking: Context Switching & TLB Flushes

Comments
2 min read
The Count-to-Infinity Bug in Network Routing: Split Horizon & Poison Reverse
Cover image for The Count-to-Infinity Bug in Network Routing: Split Horizon & Poison Reverse

The Count-to-Infinity Bug in Network Routing: Split Horizon & Poison Reverse

Comments
2 min read
How Databases Safely Ignore Obsolete Writes: Thomas Write Rule Explained
Cover image for How Databases Safely Ignore Obsolete Writes: Thomas Write Rule Explained

How Databases Safely Ignore Obsolete Writes: Thomas Write Rule Explained

Comments
2 min read
How Operating Systems Avoid Deadlocks: Dijkstra's Banker's Algorithm
Cover image for How Operating Systems Avoid Deadlocks: Dijkstra's Banker's Algorithm

How Operating Systems Avoid Deadlocks: Dijkstra's Banker's Algorithm

Comments
2 min read
Why Ethernet Mandates a 64-Byte Minimum Packet: CSMA/CD Explained
Cover image for Why Ethernet Mandates a 64-Byte Minimum Packet: CSMA/CD Explained

Why Ethernet Mandates a 64-Byte Minimum Packet: CSMA/CD Explained

Comments
2 min read
Atomic Hardware Instructions: Test-and-Set (TSL) vs Compare-and-Swap (CAS)
Cover image for Atomic Hardware Instructions: Test-and-Set (TSL) vs Compare-and-Swap (CAS)

Atomic Hardware Instructions: Test-and-Set (TSL) vs Compare-and-Swap (CAS)

Comments
2 min read
Why Do Page Faults Happen? The Demand Paging Lifecycle
Cover image for Why Do Page Faults Happen? The Demand Paging Lifecycle

Why Do Page Faults Happen? The Demand Paging Lifecycle

1
Comments
2 min read
Why 10Gbps Links Feel Slow: Stop-and-Wait ARQ Efficiency Formula Explained
Cover image for Why 10Gbps Links Feel Slow: Stop-and-Wait ARQ Efficiency Formula Explained

Why 10Gbps Links Feel Slow: Stop-and-Wait ARQ Efficiency Formula Explained

Comments
2 min read
Behind ACID: How Databases Actually Implement the 4 Guarantees
Cover image for Behind ACID: How Databases Actually Implement the 4 Guarantees

Behind ACID: How Databases Actually Implement the 4 Guarantees

Comments
2 min read
Sliding Window Sizing: Why Go-Back-N and Selective Repeat Limit Window Sizes
Cover image for Sliding Window Sizing: Why Go-Back-N and Selective Repeat Limit Window Sizes

Sliding Window Sizing: Why Go-Back-N and Selective Repeat Limit Window Sizes

Comments
2 min read
Graphing Database Conflicts: How Precedence Graphs Prove Serializability
Cover image for Graphing Database Conflicts: How Precedence Graphs Prove Serializability

Graphing Database Conflicts: How Precedence Graphs Prove Serializability

Comments
2 min read
Mutex vs Spinlock: When Should a Thread Sleep or Spin?
Cover image for Mutex vs Spinlock: When Should a Thread Sleep or Spin?

Mutex vs Spinlock: When Should a Thread Sleep or Spin?

Comments
2 min read
The Math of Collisions: Pure ALOHA vs Slotted ALOHA Efficiency
Cover image for The Math of Collisions: Pure ALOHA vs Slotted ALOHA Efficiency

The Math of Collisions: Pure ALOHA vs Slotted ALOHA Efficiency

Comments
2 min read
Why MySQL and Postgres Use B+ Trees Instead of B-Trees for Indexing
Cover image for Why MySQL and Postgres Use B+ Trees Instead of B-Trees for Indexing

Why MySQL and Postgres Use B+ Trees Instead of B-Trees for Indexing

Comments
2 min read
Why OS Virtual Memory Paging Saved LLM Inference: The vLLM Breakthrough
Cover image for Why OS Virtual Memory Paging Saved LLM Inference: The vLLM Breakthrough

Why OS Virtual Memory Paging Saved LLM Inference: The vLLM Breakthrough

Comments
2 min read
The Cost of Virtual Memory: TLBs and Effective Memory Access Time
Cover image for The Cost of Virtual Memory: TLBs and Effective Memory Access Time

The Cost of Virtual Memory: TLBs and Effective Memory Access Time

Comments
2 min read
Behind Routing Tables: CIDR and the Longest Prefix Match Rule
Cover image for Behind Routing Tables: CIDR and the Longest Prefix Match Rule

Behind Routing Tables: CIDR and the Longest Prefix Match Rule

Comments
2 min read