MySQL production basics

MySQL · 4 scenarios

Prototype — data is mocked and actions are not connected yet.

← Goals

MySQL L1–L2

Get on-call ready on MySQL: read EXPLAIN, fix indexing, survive connection pressure and the first replication failures.

1 / 4 scenarios passedScore avg 91%
Due Jul 20, 2026 · 6 weeks left

Scenarios to pass

MySQL Query & indexing · L1 Missing composite index 91% Passed
MySQL Connections & threads · L1 Too many connections — In progress
MySQL Query & indexing · L2 Covering index missing — Not started
MySQL Replication & binlog · L2 Replica lag from a write burst — Not started

How this goal was set

  • SystemsMySQL
  • LevelJunior → Mid
  • Focus areasIndexing · Connections · Replication
  • IntensityQuick · 4 scenarios

The scenario set is assembled from your answers. Re-answer to regenerate it.

Prototype — scenario scores are mocked.