Heap tables
Select on heap tables
Inserts occur to on disk table then heap table
Story selection goes from 1.37 seconds to .37 seconds.
MD5 signatures (synthetic key)
Cache comment text blobs
< Next round of solutions: Stories & Comments
Next round of solutions: Searches >
Table of Contents
|
Page 8
OSCON Scaling (3 years of history in five minutes or before they take me away)
, Brian Aker, OSDN
Slashdot's History of Scaling MySQL