First page Back Continue Last page Overview Graphics
Conclusions
Random access I/O is a performance killer for high-trafic bigger-than-mem OLTP (or cold start).
InnoDB clusters on the primary key -> USE it, don't blindly add an AUTO_INCREMENT key.
Order-of-magnitude speedups.
Not a magic silver bullet.