tidb-dashboard icon indicating copy to clipboard operation
tidb-dashboard copied to clipboard
verified publisher icon pingcap

Support One-Click SQL Binding

Open breezewish opened this issue 5 years ago • 1 comments

Feature Request

Is your feature request related to a problem? Please describe:

Now it is not easy to bind plans for a statement.

Describe the feature you'd like:

After https://github.com/pingcap/tidb/issues/18811 is implemented, the UI can be implemented in TiDB Dashboard that user can simply click a button to finish the plan binding.

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy:

breezewish avatar Oct 29 '20 08:10 breezewish

There are two proposals coming out of my head:

  1. We could just add a single checkbox named Stick on this plan to Execution Detail/Execution Plan: image. Users could just click this checkbox to bind to plan shown in the page.

  2. Or we could show a checkbox list that contains the plan history including execution hints(execution time, etc) of the SQL. Users could select a plan that seems fast instead of try to find out which plan is the 'fast' one and try to rebind that plan.

iosmanthus avatar Nov 09 '20 09:11 iosmanthus

Plan to release on v6.6.0.

SabaPing avatar Jan 29 '23 10:01 SabaPing

Done by https://github.com/pingcap/tidb-dashboard/pull/1473.

SabaPing avatar Feb 09 '23 04:02 SabaPing