Crack the Backend
Home
About
Privacy
Terms
Contact
Search
⌘ K
Database (MySQL)
7 article(s)
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