How to view and set the parameter txn-total-size-limit in TiDB V6.1.0, and whether the cluster needs to be restarted after setting

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidbV6.1.0 参数txn-total-size-limit 如何查看,并设置,设置后是否需要重启集群

| username: xiaoxiaozuofang

[TiDB Usage Environment] Production Environment
[TiDB Version] v6.1.0

[Encountered Problem: This is the transaction size limit of TiDB. The image is too large, causing a single KV to exceed 6MB.
[Resource Configuration]
[Attachment: Screenshot/Log/Monitoring]

| username: h5n1 | Original post link

SQL> show config where name like ‘%txn-total-size-limit’
txn-total-size-limit is the limit for transactions
image

| username: 胡杨树旁 | Original post link

After modifying this parameter, it needs to be restarted to take effect, right? I see it’s a tidb-server parameter, so can I just reload tidb_server?

| username: Kongdom | Original post link

Yes, use the -R parameter.

| username: 胡杨树旁 | Original post link

Okay, okay.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.