-
Notifications
You must be signed in to change notification settings - Fork 5.8k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
LOAD DATA statement doesn't respect tidb_dml_batch_size variable #10524
Labels
sig/transaction
SIG:Transaction
Comments
Lines 1079 to 1080 in 3177328
It looks like your guys need to complete the TODO |
Closed
Fixed by #11533 |
Please edit this comment or add a new comment to complete the following informationNot a bugIt's a TODO item, not a bug. |
youjiali1995
removed
severity/moderate
type/bug
The issue is confirmed as a bug.
labels
Jan 21, 2021
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Bug Report
Please answer these questions before submitting your issue. Thanks!
We use
LOAD DATA
statement to load csv to tidb.Because the size of each row is quite large, the tidb-server complains about too large transaction, then we tried using
set @@tidb_dml_batch_size=100
to make the batch smaller.All the data loaded to tidb with batch size 100
the batch size is still 20000.
We use another session console to monitor the count of the target table, it increases by 20000 for every step.
tidb-server -V
or runselect tidb_version();
on TiDB)?The text was updated successfully, but these errors were encountered: