Arpit Bhayani
Projects
Blogs
Notes
Videos
Papershelf
Bookshelf
Courses
Talks
Home
Topics
Mysql
#mysql
(22)
22 videos
All
22
Distributed Systems
10
Databases
9
Systems Internals
3
2026
(2)
Jan 17
VIDEO
Optimizing Database Memory Usage: When `malloc` Becomes a Bottleneck
Systems Internals
#memory-management
#malloc
#tcmalloc
Jan 03
VIDEO
How MySQL's Midpoint Insertion Strategy Prevents Cache Pollution
Databases
#mysql
#innodb
#caching
2025
(1)
Jul 18
VIDEO
How GitHub Sharded Their Databases Without Downtime and Broke Their Monolith
Distributed Systems
#github
#database-sharding
#mysql
2024
(2)
Jul 15
VIDEO
When Your Database ID Hits MAX_INT: Understanding and Solving Auto-Increment Limits
Databases
#database-ids
#max-int
#auto-increment
Jan 30
VIDEO
Choosing the Right String Column Data Type: CHAR vs VARCHAR vs TEXT
Databases
#databases
#postgresql
#mysql
2023
(6)
Nov 10
VIDEO
Understanding the Read Uncommitted Isolation Level: Mechanics, Anomalies, and Trade-offs
Systems Internals
#databases
#acid-transactions
#isolation-levels
Mar 19
VIDEO
DATETIME vs TIMESTAMP in Databases: Storage Internals, Timezones, and Trade-Offs
Databases
#databases
#mysql
#sql
Mar 19
VIDEO
Demystifying Phantom Reads: Anatomy of a Database Concurrency Bug
Databases
#databases
#acid-transactions
#isolation-levels
Mar 19
VIDEO
Why Databases Store Data in B+ Trees: From Naive Disk Storage to Indexed Pages
Systems Internals
#databases
#b-plus-tree
#storage-engines
Jan 08
VIDEO
Zero-Downtime Data Migration: How Shopify Solves Hot Shards
Distributed Systems
#database-sharding
#mysql
#zero-downtime
Jan 01
VIDEO
Designing a High-Throughput Order Data Layer: Grab's Architecture for Millions of Daily Transactions
Distributed Systems
#dynamodb
#mysql
#kafka
2022
(10)
Nov 21
VIDEO
Scaling Booking.com's Highly Available User Review System
Distributed Systems
#consistent-hashing
#database-sharding
#high-availability
Jun 29
VIDEO
Database Management at Scale: Dissecting the GitHub MySQL Outage
Distributed Systems
#mysql
#proxysql
#orchestrator
Jun 22
VIDEO
Dissecting the GitHub MySQL Master Failover Outage
Databases
#mysql
#failover
#data-divergence
Jun 06
VIDEO
Post-Mortem: How a Single MySQL Index Broke GitHub
Databases
#mysql
#indexing
#databases
May 25
VIDEO
Implementing Vertical Sharding: A Practical Guide to Live Table Migrations
Distributed Systems
#database-sharding
#vertical-sharding
#zookeeper
May 23
VIDEO
How an Edge Case and Retry Storms Can Take Down a Database: Lessons from GitHub's Outage
Distributed Systems
#distributed-systems
#mysql
#database-internals
May 09
VIDEO
How an ALTER TABLE Caused a Massive GitHub Outage
Distributed Systems
#mysql
#database-internals
#github-outage
Mar 30
VIDEO
Implementing Distributed Transactions Using the Two-Phase Commit Protocol
Distributed Systems
#distributed-transactions
#two-phase-commit
#microservices
Mar 23
VIDEO
What Happens When an Auto-Increment ID Hits Its Max Value: Dissecting the GitHub Outage
Databases
#mysql
#databases
#system-design
Mar 14
VIDEO
How to Handle Database Outages: Anatomy, Incident Triage, and Architectural Fixes
Distributed Systems
#databases
#incident-response
#mysql
2021
(1)
Apr 10
VIDEO
Generating 5 Million Hierarchical Rows in Under 100 Seconds Using Pure SQL
Databases
#sql
#mysql
#database-performance