server: deprecate the batch related system variables
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
The variables:
- [`tidb_batch_insert`](https://docs.pingcap.com/tidb/stable/system-variables#tidb_batch_insert)
- [`tidb_batch_delete`](https://docs.pingcap.com/tidb/stable/system-variables#tidb_batch_delete)
- [`tidb_enable_batch_dml`](https://docs.pingcap.com/tidb/stable/system-variables#tidb_enable_batch_dml)
- [`tidb_batch_commit`](https://docs.pingcap.com/tidb/stable/system-variables#tidb_batch_commit)
are not reconmonded to be used since they could break the transaction constraints and lead to data inconsistency. They would be deprecated in the future and related code would be removed.
The [pipelined-dml](https://docs.pingcap.com/tidb/stable/system-variables#tidb_dml_type-new-in-v800) is reconmonded to be used for batch processing, the transaction size is not limited and the execution is faster.
Contributor guide
Assessment
This issue has not been assessed yet.