Data Capacity — 2 Technical Articles

Jul 9, 2024 · Fundamentals

Will QR Codes Ever Run Out? The Astronomical Numbers Behind Their Longevity

QR codes are everywhere, with over 100 billion scans daily, yet calculations using combinatorics and AI show that exhausting all possible codes would take far longer than the age of the universe, making depletion practically impossible.

Artificial IntelligenceData CapacityQR code

0 likes · 6 min read

Will QR Codes Ever Run Out? The Astronomical Numbers Behind Their Longevity

ITPUB

Jan 27, 2024 · Databases

How Many Rows Can a Single MySQL Table Really Hold? Detailed B+‑Tree Calculations

This article consolidates theory and real‑world examples to show how MySQL’s B+‑tree structure, page layout, and row format determine the maximum number of records a single table can store, providing step‑by‑step calculations for both int and bigint primary keys.

B+TreeData CapacityInnoDB

0 likes · 12 min read

How Many Rows Can a Single MySQL Table Really Hold? Detailed B+‑Tree Calculations