Crack The Backend
Search documentation
/
Home
Core Backend
Algorithms
System Design
Data Structures
Database (MySQL)
menu_book
7 articles
Index Fundamentals - B-Tree, Covering Index
B-Tree indexes and covering indexes in MySQL.
Locks - Row Lock vs Gap Lock
Row locks and gap locks in InnoDB.
MVCC Explained
Multi-version concurrency control in MySQL.
Pagination - Limit/Offset vs Seek Method
Efficient pagination patterns.
Schema Design - Practical Rules of Thumb
Practical rules for database schema design.
Slow Query Diagnosis Workflow
How to diagnose slow queries.
Transactions - Isolation & Common Anomalies
Isolation levels and read phenomena.
Back to home