Data and storage4NF
Why does a table of 3 tags and 40 PIN codes need 120 rows?
0%
Page 36
More questions.
Data and storageHot rows
Why does one popular dish’s counter cap out near 500 updates a second?
0%
Data and storageLive tables
How do you add a rule to a 100 GB table without stopping writes?
0%
Data and storageParent locks
Why can adding a line item block an update to its order?
0%
Data and storageDurability
Turn off synchronous_commit. What exactly can a crash take from you?
0%
Data and storageLost update
Why can MySQL’s REPEATABLE READ silently lose a ₹200 top-up?
0%
Data and storageNOLOCK
Why can NOLOCK count one order twice, even when nothing rolls back?
0%
Data and storageFlash sale
Why doesn’t a transaction stop two buyers getting the last phone?
0%
Data and storageSlot rows
How do 81,000 pre-made rows stop double bookings?
0%
Data and storagePostgreSQL
Why did a DELETE skip a row that matched, with no error?
0%
Data and storageCost
Same guarantee, same benchmark. Why did locking manage under half the throughput?
0%
Data and storageWrite amplification
Change one column in PostgreSQL. Why does every index get a write?
0%
Data and storageLock window
Hold a row lock through a 400 ms payment call. Why does throughput collapse?
0%
Data and storageCheckpoints
Checkpoint every 30 minutes, not 5. How long does crash recovery take?
0%
Data and storageWraparound
Mandrill’s vacuum estimate ran to 40 days. How did it finish in an hour?
0%
Data and storageClustered index
Why does MySQL walk two trees to find one user by email?
0%
Data and storageEquality, sort, range
Why does swapping two index columns cost 15 times the table reads?
0%
Data and storageLIMIT trap
Why did the latest 20 bookings on one train take 8.7 seconds?
0%
Data and storageGeneric plans
Why is your query fast in psql but slow from the app?
0%
Data and storageConnection pool
Your pool of 20 connections looked generous. Why is it empty?
0%
Data and storageShards
Why does Elasticsearch refuse to show you hit 10,001?
0%
Data and storagePgBouncer
How do 4,000 app connections fit through 40 database ones?
0%
Data and storageUnique keys
Why won’t your partitioned table accept a primary key on txn_id alone?
0%
Data and storageScatter-gather
100 shards, each slow 1% of the time. Why are 63% of queries slow?
0%
Data and storageAsync commits
At 2,000 writes a second, how many “successful” writes can one crash erase?
0%
Data and storageLatency
One replica takes 40 ms. Why does your write return in 3?
0%