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
|
Parameter Type | ULONGLONG |
Default Value | 10 |
Value Range | 1 ~ 1073741824 |
Effective Scope | GLOBAL SESSION |
Restart Required | No |