tencent cloud

TDSQL Boundless

Release Notes
Product Introduction
Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Usage specification recommendations
Kernel Features
Kernel Overview
Kernel Version Release Notes
Functionality Features
Performance Features
Billing
Billing Overview
Purchase Method
Pricing Details
Renewal
Overdue Payments
Refund
Getting Started
Creating an Instance
Connect to Instances
User Guide
Data Migration
Data Subscription
Instance Management
Parameter Configuration
Account Management
Security Group
Backup and Restoration
Database Auditing
Tag Management
Use Cases
Technical Evolution and Usage Practices of Online DDL
Lock Mechanism Analysis and Troubleshooting Practices
Data Intelligent Scheduling and Related Practices for Performance Optimization
TDSQL Boundless Selection Guide and Practical Tutorial
Developer Guide
Developer Guide (MySQL Compatibility Mode)
Developer Guide (HBase Compatibility Mode)
Performance Tuning
Performance Tuning Overview
SQL Tuning
DDL Tuning
Performance White Paper
Performance Overview
TPC-C Test
Sysbench Test
API Documentation
History
Introduction
API Category
Making API Requests
Instance APIs
Security Group APIs
Task APIs
Backup APIs
Rollback APIs
Parameter APIs
Database APIs
Data Types
Error Codes
General Reference
System Architecture
SQL Reference
Database Parameter Description
TPC-H benchmark data model reference
Error Code Information
Security and Compliance
FAQs
Agreements
Service Level Agreement
Terms of Service
Privacy Policy
Data Processing And Security Agreement
Contact Us
Glossary
ドキュメントTDSQL BoundlessGeneral ReferenceDatabase Parameter Descriptiontdsql_skip_trans_write_lock

tdsql_skip_trans_write_lock

PDF
フォーカスモード
フォントサイズ
最終更新日: 2026-03-27 18:23:00

Feature Description

tdsql_skip_trans_write_lock indicates whether to skip obtaining the write lock during a write operation.
To ensure data consistency and integrity, write operations usually need to be locked. This ensures that when multiple transactions access the same data at the same time, write operations will not interfere with each other, thus avoiding data inconsistency problems. However, in some scenarios, to improve performance, you can choose to skip obtaining transactional write locks to reduce the overhead of lock contention and lock waiting.
Skipping obtaining transaction write locks may result in data inconsistency. Therefore, when using the tdsql_skip_trans_write_lock parameter, you need to carefully evaluate system requirements and scenarios to ensure that data consistency and integrity are maintained even when locks are skipped.

Attribute Description

Required
Description
Parameter Type
BOOL
Default Value
OFF
Value Range
OFF
ON
Effective Scope
GLOBAL
Restart Required
No
前の記事へ: tdsql_retry_interval_msec_min次の記事へ: tdsql_split_trans_during_alter_copy

ヘルプとサポート

この記事はお役に立ちましたか？

フィードバック