Skip to content
This repository has been archived by the owner on Aug 21, 2023. It is now read-only.

Do we need to sort _tidb_rowid when dumping TiDB data? #277

Open
lichunzhu opened this issue Apr 29, 2021 · 1 comment
Open

Do we need to sort _tidb_rowid when dumping TiDB data? #277

lichunzhu opened this issue Apr 29, 2021 · 1 comment
Labels
good first issue priority/P1 High priority issue

Comments

@lichunzhu
Copy link
Contributor

Question

TiDB-Lightning doesn't need data to keep in order of _tidb_rowid, but we still sort data in the order of _tidb_rowid. This may increase TiDB's memory usage because we'll need a global sort in TiDB.
@kennytm
Copy link
Collaborator

kennytm commented Apr 29, 2021

we don't really need ORDER BY _tidb_rowid but we must support WHERE xxx <= _tidb_rowid AND _tidb_rowid < yyy.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
good first issue priority/P1 High priority issue
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@kennytm @tisonkun @lichunzhu