pingcap / pingcap/tidb

Ability to monitor progress of ADMIN CHECK INDEX | TABLE

Open
#40,921 2 comments 1 reaction 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:**
When checking index consistency on large tables (several TB), ADMIN CHECK INDEX takes many hours or even days. It is hard to estimate how long it will take to finish or even if it is working at all.

**Describe the feature you'd like:**
A metric with % of work complete when running ADMIN CHECK INDEX and/or TABLE.

Suggestion from @dveeden:

> Yes would be nice to have a progress column in information_schema.processlist and/or have some progress information in the logs (e.g. every 10m). Something that knows the total number of rows from stats and the number of rows checked etc. So yes, please create an issue on GitHub.

**Describe alternatives you've considered:**
Haven't found any way to get this information.

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.