Plan replayer development task

[rebelice]

Plan Replayer

Provide all the information required to reproduce the implementation plan for import/export. Provide a simple, one-stop collection and retention of the event of the scene, simplifying the inspection information extraction steps of the optimizer-related issues.

Description

PLAN REPLAYER provides three features:

• One-click Export/Import Information Reproducing Single SQL
• One-click Export/Importing Information Reproducing Slow Queries
• Load Information to Reproducing Query Plans

Dump for one SQL

tidb> plan replayer dump explain [analyze] sqlStmt

• sqlStmt parameter is the specified SQL statement
• explain [Analyze] is used to specify back explain or Explain Analyze information
• This statement will return a single-active URL for download files such as http://${tidb-server-ip}:${tidb-server-status-port}/plan_replayer/dump/xxxx

Dump for slow queries
tidb> plan recretor dump explain [analyze] slow query [filtering]

• explain [Analyze] is used to specify back explain or Explain Analyze information
• [filtering] is used to filter slow inquiry in Slow Query Table, support:
  • WHERE
  • ORDER BY
  • Limit
• This statement will return a single-active URL for download files such as http://${tidb-server-ip}:${tidb-server-status-port}/plan_replayer/dump/xxxx

Load Information

tidb> plan replayer load 'file_name'

File Format
The file plan-replayer.zip format is as follows:

|-meta.txt
|-schema.sql
|-stats
|   |-stats1.json
|   |-stats2.json
|   |-....
|-config.toml
|-variables.toml
|-bindings.sql
|-sqls.sql
|_explain
    |-explain1.txt
    |-explain2.txt

Development task

• Modify parser to add PLAN RECREATOR statement #26334
• Add plan replayer GC #26335
• rename RECREATOR to REPLAYER #28825
• refactor plan replayer #28955
• Add http api for plan replayer dump #29213
• Add a HTTP handler to download files for Plan Recreator #26336
• support plan replayer load #29246
• plan replayer http dump cannot be used in a TiDB cluster with proxy #29495
• Test Plan Recreator #26337

Enhancement

• plan replayer load failed "ERROR 1050 (42S01): Table 'test.t1' already exists" #29615

Bugfix

• The modified time of the file compressed in the plan replayer zip file is wrong #29616