Add an index to a large MySQL table

-- MySQL 5.6: INPLACE skips the table copy, LOCK=NONE keeps writes running
ALTER TABLE orders
  ADD INDEX idx_status_placed_at (status, placed_at),
  ALGORITHM=INPLACE, LOCK=NONE;