tdsql_auto_increment_batch_size is used to set the number of auto-increment values fetched by SQLEngine in a single operation. The auto-increment value generation sequence is stored on storage nodes. In certain scenarios, to improve insertion performance, the system can allocate consecutive auto-increment values for multiple insert operations at once, thereby reducing the overhead of the auto-increment generator. By adjusting the tdsql_auto_increment_batch_size parameter, you can control the size of this batch allocation.tdsql_auto_increment_batch_size parameter is adjusted, the following factors need to be considered:tdsql_auto_increment_batch_size parameter may improve insertion performance, especially during batch data insertion. However, excessively large values may increase the risk of auto-increment value exhaustion.tdsql_auto_increment_batch_size parameter should not be set too large to avoid the risk of auto-increment value exhaustion. For example, if the data type of the auto-increment column is INT, with a maximum value of 231-1, then the maximum value of the tdsql_auto_increment_batch_size parameter should be less than 231 / number of insert operations.tdsql_auto_increment_batch_size parameter is needed. If performance bottlenecks are detected, you can try adjusting this parameter to improve performance.Required | Description |
Parameter Type | UINT |
Default Value | 100 |
Value Range | 1 ~ 10000 |
Effective Scope | GLOBAL |
Restart Required | No |
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback