tdsql_bulk_commit_records is used to set the threshold number of data entries that meet the commit conditions for sub-transactions split during the DDL process. When this limit is reached, the system automatically commits transactions to free up space for new records.tdsql_bulk_commit_records parameter is adjusted, consider the following factors:tdsql_bulk_commit_records parameter may enhance the performance of batch insert, update, and delete operations. However, excessively large values may lead to oversized transactions, thereby affecting system performance and stability.tdsql_bulk_commit_records parameter needs adjustment. If performance bottlenecks are detected, try adjusting this parameter to optimize performance.Required | Description |
Parameter Type | ULONG |
Default Value | 3000 |
Value Range | 1 ~ 18446744073709551615 |
Effective Scope | GLOBAL SESSION |
Restart Required | No |
피드백