tencent cloud

Feedback

Automatic Killing of Idle Transactions

Last updated: 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.


Catalog

In The Article

Automatic Killing of Idle Transactions

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon