Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 各位大佬对线上业务大事务限制是多少？
|
username: GreenGuan
I would like to ask everyone what the limit is for large transactions in online business? For TiDB, what size of transaction is considered a large transaction?
Known issues with large transactions include memory, locks, TiCDC, and network.
I think there is no specific definition of what constitutes a large transaction. Any transaction that your business cannot accept in terms of execution time or that your online environment cannot handle in terms of performance is considered a large transaction.
Set it to the default value. If there are errors due to exceptionally large transactions, increase the value temporarily, and then revert it back after execution.
This topic will be automatically closed 60 days after the last reply. No new replies are allowed.
|
username: 
|
username: 
|
username: 
|
username: 
We set it directly to the maximum value, 10G.
|
username: