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
DocumentaçãoTDSQL BoundlessGeneral ReferenceDatabase Parameter Descriptiontdsql_lock_wait_timeout

tdsql_lock_wait_timeout

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2026-03-27 18:13:45

Feature Description

tdsql_lock_wait_timeout indicates the lock timeout period of the TDStore engine, in milliseconds.
In a database system, to ensure data consistency and integrity, the system needs to coordinate and manage data. A lock is a mechanism used to ensure data consistency. It can prevent multiple transactions from simultaneously accessing and modifying the same piece of data, thereby avoiding data inconsistency.
For example, if the value is set to 10,000 milliseconds (10 seconds), the system will wait for at most 10 seconds when a transaction attempts to obtain the lock and the lock is already held by another transaction. If the lock is not released within this period, the system will throw a timeout exception, indicating a lock wait timeout. This ensures data consistency and integrity, avoiding errors and performance degradation caused by lock wait timeouts.
Additionally, this parameter is constrained by the parameter tdsql_tdstore_rpc_timeout. By default, it will limit tdsql_lock_wait_timeout to a value less than that of this parameter. For example, if tdsql_tdstore_rpc_timeout is 100000ms (100s) and tdsql_lock_wait_timeout is 200s, then, by default, it will reduce the value of tdsql_lock_wait_timeout to less than tdsql_tdstore_rpc_timeout.

Attribute Description

Required
Description
Parameter Type
ULONGLONG
Default Value
10
Value Range
1 ~ 1073741824
Effective Scope
GLOBAL
SESSION
Restart Required
No
Anterior: tdsql_get_index_stats_from_tdstorePróximo: tdsql_max_collect_ranges

Ajuda e Suporte

Esta página foi útil?

comentários