TiDB：ERROR 8004 (HY000): Transaction is too large, size: 104857600

数据库 数据库-TiDB

4.0 前面的版本无法调整参数 只能 调整事务的大小 分批进行

-- 4.0 之后的可以修改事务参数

txn-total-size-limit 

使用tiup调整该事务参数

修改配置参数
$ tiup cluster edit-config tidb-dc
...
tidb_servers:
- host: 10.50.136.147
  ssh_port: xxx
  port: 4000
  status_port: 10080
  deploy_dir: /home/service/var/data/tidb-4000
  config:
    performance.txn-total-size-limit: 10737418240
  arch: amd64
  os: linux
- host: 10.50.136.165
  ssh_port: xxx
  port: 4000
  status_port: 10080
  deploy_dir: /home/service/var/data/tidb-4000
  config:
    performance.txn-total-size-limit: 10737418240
  arch: amd64
  os: linux
- host: 10.50.138.17
  ssh_port:xxx
  port: 4000
  status_port: 10080
  deploy_dir: /home/service/var/data/tidb-4000
  config:
    performance.txn-total-size-limit: 10737418240
  arch: amd64
  os: linux
  ...
滚动更新
$ tiup cluster reload tidb-dc -R tidb   
查看配置文件已经生成
$ vim /home/service/var/data/tidb-4000/conf/tidb.toml 
max-index-length = 12288
[log]
slow-threshold = 300
[performance]
txn-total-size-limit = 10737418240