LOAD DATA statement doesn't respect tidb_dml_batch_size variable

[alex-lx]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do?

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.

2. What did you expect to see?

All the data loaded to tidb with batch size 100

3. What did you see instead?

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.

4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

Release Version: v2.1.2-1-gb4cc58c8c
Git Commit Hash: b4cc58c8c8c03ee2c9a462c31c7ee4f0df81b9bf
Git Branch: v2.1.2-xm
UTC Build Time: 2019-01-14 09:06:14
GoVersion: go version go1.11.1 darwin/amd64
Race Enabled: false
TiKV Min Version: 2.1.0-alpha.1-ff3dd160846b7d1aed9079c389fc188f7f5ea13e
Check Table Before Drop: false

[alex-lx]

tidb/server/conn.go

Lines 1079 to 1080 in 3177328

	// TODO: Make the loadDataRowCnt settable.
	loadDataInfo.SetMaxRowsInBatch(defaultLoadDataBatchCnt)

It looks like your guys need to complete the TODO

[youjiali1995]

Fixed by #11533

[ti-srebot]

Please edit this comment or add a new comment to complete the following information

Not a bug

It's a TODO item, not a bug.