pingcap / pingcap/tidb

SQL语句优先级实现方式

Open
#33,889 3 comments 0 reactions 0 assignees View on GitHub
type/question
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

TiDB 支持改变 [per-session](https://docs.pingcap.com/zh/tidb/stable/system-variables#tidb_force_priority)、[全局](https://docs.pingcap.com/zh/tidb/stable/tidb-configuration-file#force-priority)或单个语句的优先级。优先级包括:

HIGH_PRIORITY:该语句为高优先级语句,TiDB 在执行阶段会优先处理这条语句
LOW_PRIORITY:该语句为低优先级语句,TiDB 在执行阶段会降低这条语句的优先级

上述描述的SQL语句的优先级是如何实现的、比如是降低线程数还是减少CPU时间片、暂停IO等方式?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.