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 7
Brian Aker, OSDN
, Introductions
Slashdot's History of Scaling MySQL
* Brian Aker