Unpredictability in query runtimes can arise in a shared cluster as a result of resource contentions caused by inter-query interactions. iQCAR - inter >Query >Contention >Analyze>R is a system that formally models these interferences between concurrent queries and provides a framework to attribute blame for contentions. iQCAR leverages a multi-level directed acyclic graph called iQC-Graph to diagnose the aberrations in query schedules that lead to these resource contentions. The demonstration will enable users to perform a step-wise deep exploration of such resource contentions faced by a query at various stages of its execution. The interface will allow users to identify top-k victims and sources of contentions, diagnose high-contention nodes and resources in the cluster, and rank their impacts on the performance of a query. Users will also be able to navigate through a set of rules recommended by iQCAR to compare how application of each rule by the cluster scheduler resolves the contentions in subsequent executions.
展开▼
机译:查询运行时的不可预测性可能是由于查询之间的交互导致的资源争用而在共享群集中引起的。 iQCAR-内部> Q strong>项目> C strong>注意> A strong> nalyze > R strong>是一个系统地对并发查询和提供了一个框架来归咎于争用。 iQCAR利用称为iQC-Graph的多级有向无环图来诊断导致这些资源争用的查询计划中的异常。该演示将使用户能够在查询执行的各个阶段对这些查询所面临的资源争用进行逐步深入的研究。该界面将使用户能够确定顶级的k受害者和争用源,诊断集群中的高争用节点和资源,并排列它们对查询性能的影响。用户还将能够浏览iQCAR推荐的一组规则,以比较集群调度程序对每个规则的应用如何解决后续执行中的争用。
展开▼