tencent cloud

TDSQL Boundless

DokumentasiTDSQL BoundlessGeneral ReferenceDatabase Parameter Descriptiontdsql_bulk_commit_records

tdsql_bulk_commit_records

Unduh
Mode fokus
Ukuran font
Terakhir diperbarui: 2026-05-26 16:30:20

Feature Description

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.
When adjusting the tdsql_bulk_commit_records parameter, you need to consider the following factors:
Transaction Performance: Increasing the value of the tdsql_bulk_commit_records parameter may improve the performance of batch insert, update, and delete operations. However, an excessively large value may cause transactions to become too large, which can affect system performance and stability.
Monitoring and Tuning: Monitor server performance metrics, such as CPU utilization, memory utilization, and disk I/O, to determine whether you need to adjust the tdsql_bulk_commit_records parameter. If a performance bottleneck is identified, you can try adjusting this parameter to optimize performance.

Attribute Description

Required
Description
Parameter Type
ULONG
Default Value
3000
Value Range
1 ~ 18446744073709551615
Effective Scope
GLOBAL
SESSION
Restart Required
No
Topik sebelumnya: tdsql_auto_increment_batch_sizeTopik selanjutnya: tdsql_cache_range_max_use_cnt

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan