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.
    
    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