大数据量插入问题 insert into A select * from B

🪐 TiDB 技术问题 性能调优
4

image
image848×529 36.7 KB

1）要开启autocommit=1，才能开启tidb_batch_insert
2）开启tidb_batch_insert，才能开启tidb_dml_batch_size

image
image721×420 18 KB

https://docs.pingcap.com/zh/tidb/v2.1/transaction-overview/

2 个赞