Release Notes
Product Introduction
- Overview
- Scenarios
- Product Architecture
- Instance Types
- Compatibility Notes
- Usage Recommendations
Kernel Features
- Kernel Overview
- Kernel Version Release Notes
- Functionality Features
- Performance Features
- Security Features
- Columnar Read-Only Analysis Engine Features
Billing
Getting Started
- Creating Instances
- Connect to Instances
User Guide
- Use Limits
- Operation Overview
- Data Migration
- Data Subscription
- Instance Management
- Configuration Change
- Multi-AZ Deployment
- Disaster Recovery Instance
- Monitoring and Alarms
- Parameter Configuration
- Account Management
- Network and Security
- Cold Data Archiving
- Backup and Restoration
- Log Center
- Enabling the Audit Service
- Tag Management
- Serverless Service
- Read-Only Analysis Instance
Use Cases
Developer Guide
- Developer Guide (MySQL Compatibility Mode)
- Developer Guide (HBase Compatibility Mode)
Performance Tuning
- Performance Tuning Overview
- SQL Tuning
- DDL Tuning
Performance White Paper
Troubleshooting
- Performance
- Transaction
API Reference
- History
- Introduction
- API Category
- Making API Requests
- Instance APIs
- Security Group APIs
- Task APIs
- Data Security Encryption APIs
- Account APIs
- Backup APIs
- Restore APIs
- Parameter APIs
- Database APIs
- Log APIs
- Other 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
- Selection Related
- Features
- Connecting and Logging In
- Backup
- Restoration
- Account Permission
- Performance Memory
- Cold Data Archiving
Agreements
Contact Us
Glossary

tdsql_skip_trans_write_lock

Download

Focus Mode

Font Size

Last updated: 2026-05-26 17:00:07

AI-Translated

Feature Description
tdsql_skip_trans_write_lock specifies whether to skip obtaining the write lock during write operations.
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 the acquisition of transactional write locks may lead to data inconsistency. Therefore, when using the tdsql_skip_trans_write_lock parameter, carefully evaluate the system's requirements and scenarios to ensure that data consistency and integrity are still maintained even when locking is skipped.
Attribute Description
Required
Description
Parameter Type
BOOL
Default Value
OFF
Value Range
OFF
ON
Effective Scope
GLOBAL
Restart Required
No

Help and Support

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

tencent cloud

TDSQL Boundless

tdsql_skip_trans_write_lock

Feature Description

Attribute Description

Help and Support

Required	Description
Parameter Type	BOOL
Default Value	OFF
Value Range	OFF ON
Effective Scope	GLOBAL
Restart Required	No