pingcap / dumpling

Dumpling is a fast, easy-to-use tool written by Go for dumping data from the database(MySQL, TiDB...) to local/cloud(S3, GCP...) in multifarious formats(SQL, CSV...).
Apache License 2.0
281 stars 85 forks source link

Support LOW_PRIORITY in dumpling #289

Closed niezefeng closed 3 years ago

niezefeng commented 3 years ago

Feature Request

Is your feature request related to a problem? Please describe: When using the mydumper, the SQL will add the LOW_PRIORITY hint automatically. e.g.

SELECT /*!40001 LOW_PRIORITY SQL_NO_CACHE */ * FROM `test`.`sbtest1`;

But dumpling doesn't support this.

Describe the feature you'd like: Add an option to add hint LOW_PRIORITY for all the SQLs. This could help to reduce the impact on online txns in tidb v3 or lower version.

kennytm commented 3 years ago

Duplicate of https://github.com/pingcap/dumpling/issues/115#issuecomment-714355349.