She SSH’d into the production database server and ran the usual triage:
It was 2:13 AM on a Tuesday. Maya, the only on-call database engineer, jolted awake by a relentless buzz from her phone. mysql kill a query
KILL QUERY 19283; A second later, MySQL responded: She SSH’d into the production database server and
She typed:
KILL <connection_id>; -- kills the entire connection, not just the query She never forgot that 2 AM wakeup. And from then on, every SELECT on large tables had to justify its indexes in the design review. “With great SELECT comes great responsibility — and the ability to KILL QUERY when responsibility fails.” the only on-call database engineer