tdsql_auto_increment_batch_size specifies the number of auto-increment values that SQLEngine obtains in a single operation. The auto-increment 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, you need to consider the following factors:tdsql_auto_increment_batch_size parameter may improve insertion performance, especially during batch data insertion. However, an excessively large value may increase the risk of auto-increment value exhaustion.tdsql_auto_increment_batch_size parameter should not be set too high 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/ the number of insert operations.tdsql_auto_increment_batch_size parameter. If a performance bottleneck is identified, you can try adjusting this parameter to optimize performance.Required | Description |
Parameter Type | UINT |
Default Value | 100 |
Value Range | 1 ~ 10000 |
Effective Scope | GLOBAL |
Restart Required | No |
피드백