resource-isolation
Installation
SKILL.md
Resource Isolation, Query Queue, and Query Governance
Investigation guide for resource groups, query queues, big-query circuit breakers, and SQL blacklisting.
Five root causes account for most resource isolation issues:
- Cause A — Unclassified queries monopolize resources (fall into
default_wg) - Cause B — Memory limit too tight causing disk spill and IO contention
- Cause C — Queue full causing immediate rejection (misleading error to client)
- Cause D — Big query unbounded for a specific user (no
big_query_*limits set) - Cause E — Statistics collection saturating BRPC worker threads
Metric Taxonomy — Read This First
Before diagnosing, understand the observable signals for resource isolation issues.