pingcap/tidb

Show ANALYZE TABLE result

Open

#29,712 opened on Nov 12, 2021

View on GitHub
 (0 comments) (0 reactions) (0 assignees)Go (6,186 forks)batch import
help wantedtype/feature-request

Repository metrics

Stars
 (40,090 stars)
PR merge metrics
 (Avg merge 14d 4h) (346 merged PRs in 30d)

Description

Feature Request

When I run the query ANALYZE TABLE t1; in TiDB, it shows nothing.

TiDB> ANALYZE TABLE t1;
Query OK, 0 rows affected (0.05 sec)

My expectation is to give a similar result as in MySQL.

mysql> ANALYZE TABLE t1;
+----------------------+---------+----------+----------+
| Table                | Op      | Msg_type | Msg_text |
+----------------------+---------+----------+----------+
| invisible_indexes.t1 | analyze | status   | OK       |
+----------------------+---------+----------+----------+
1 row in set (0.05 sec)

Contributor guide

Research direction
Examine the MySQL behavior for ANALYZE TABLE and implement it in TiDB's SQL execution layer, ensuring a result set is returned with appropriate columns (Table, Op, Msg type, Msg text).
Tech stack
go
Domain
database
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
Go
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70