pingcap / pingcap/tidb

Add paramater to avoid Full Table Scan

Open
#33,743 0 comments 0 reactions 0 assignees View on GitHub
type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Feature Request

**Is your feature request related to a problem? Please describe:**
Per TiDB architecture, the database is distributed in different TiKV.
If a client runs a table scan by mistake it can affect the entire database performance and increase disk activity on all tikv.

**Describe the feature you'd like:**
Add an option on tidb like 'notablescan' that would fail a query that use full table scan on non default databases (mysql, information_schema)

**Describe alternatives you've considered:**
No workaround available for this feature

**Teachability, Documentation, Adoption, Migration Strategy:**
If accepted, documentation should be updated and the option should be disabled by default.

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.