pingcap / pingcap/docs

Plan replayer requires additional option on connection string when using MySQL

Open
#16,497 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Python
Stars
617
Forks
724
Avg merge
2d 10h
Merged PRs (30d)
223

Description

Change Request

Please answer the following questions before submitting your issue. Thanks!

  1. Describe what you find is inappropriate or missing in the existing docs.

https://docs.pingcap.com/tidb/dev/sql-plan-replayer

When using plan replayer, import can fail when connecting as MySQL. There is no documented solution or visibility to this issue on the plan replayer page.

  1. Describe your suggestion or addition.

When using plan replayer, it you are using MySQL - you will want to include the recommendation that can be found on this documentation page:
https://docs.pingcap.com/tidbcloud/tidb-cloud-import-local-files

The recommendation from that page is:
If you use mysql and encounter ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access., you can add --local-infile=true in the connection string.

  1. Provide some reference materials (such as documents and websites) if you could.

Reference provided is from an existing PingCAP documentation page.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Open the SQL Plan Replayer page at https://docs.pingcap.com/tidb/dev/sql-plan-replayer and review the import instructions. Compare them with the guidance in https://docs.pingcap.com/tidbcloud/tidb-cloud-import-local-files, then add the MySQL --local-infile=true recommendation and error context. Done means the Plan Replayer page visibly explains how to avoid this import failure when connecting with MySQL.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql
Domain
databases, documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.