MySQL Cheat Sheet: EXPLAIN Type Column, Covering Indexes, and Performance Schema

MySQL diagnostics and the patterns you need before you're staring at a slow query in production. EXPLAIN type column — what you're looking at The type column in EXPLAIN tells you how MySQL is scanning the table: typeMeaningAction constPrimary ...