tencent cloud

Automatic Killing of Idle Transactions
Terakhir diperbarui:2023-11-01 16:50:53
Automatic Killing of Idle Transactions
Terakhir diperbarui: 2023-11-01 16:50:53

Overview

This feature kills transactions that have been idle for the specified time period to release resources in time.

Supported Versions

TDSQL-C for MySQL 5.7 (kernel version 2.0.23/2.1.9) or later.
‌TDSQL-C for MySQL on kernel version 3.1.10 or later.

Use Cases

If a connection starts a transaction (explicitly using begin/start transaction or implicitly) but no new statement has been executed for the specified threshold period, the connection will be killed.

Use Limit

Use the cdb_kill_idle_trans_timeout parameter to enable or disable the feature. If it is 0, the feature is disabled; otherwise, a connection idle for cdb_kill_idle_trans_timeout or wait_timeout seconds, whichever is smaller, will be killed. wait_timeout is a session parameter.
Parameter
Effective Immediately
Type
Default Value
Value Range
Description
‌cdb_kill_idle_trans_timeout
YES
ulong
0
[0,31536000]
If it is 0, the feature is disabled; otherwise, a transaction idle for cdb_kill_idle_trans_timeout seconds will be killed.

Apakah halaman ini membantu?
Anda juga dapat Menghubungi Penjualan atau Mengirimkan Tiket untuk meminta bantuan.
Ya
Tidak

masukan