Core concept

SET MEM_LIMIT=8G. Exceeding = spill or fail.

Advertisement

How it works

Estimation via EXPLAIN.

Advertisement

Trade-offs + gotchas

Every query in prod.