Docs

RDS for MySQL

Stability

Idle transaction cleanup

Idle transaction cleanup

RDS for MySQL provides the ability to automatically clean up long-idle transactions. This topic describes how to use this feature.

Supported version

MySQL 5.7 version, and the kernel minor version is MySQL 5.7.32_20241215 and above.

MySQL 8.0 version, and the kernel minor version is MySQL 8.0.32_20230615 and above.

MySQL 8.4 version, and the kernel minor version is MySQL 8.4.7_20260415 and above.

tip

You can view the kernel minor version of an instance by Viewing instance information. If the kernel minor version of your instance is not within the supported kernel minor version range, you can Manually upgrading the instance kernel minor version.

Limitation

Instances in the RDS for MySQL 8.0.26 version series do not currently support this feature.

Instructions

Users can use the following parameter to configure the time threshold for clearing idle transactions.

Parameter name	Type	Need to restart	Description
kill_idle_transaction	integer	No	Controls the timeout for idle transactions in seconds. The default is 0 (disabled).

Examples

Set kill_idle_transaction to 5.

Start a transaction and write a record.

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 values (1,1,1);
Query OK, 1 row affected (0.00 sec)

mysql> select * from t1;
+---+---+------+
| a | b | c |
+---+---+------+
| 1 | 1 | 1 |
+---+---+------+
1 row in set (0.00 sec)

Wait for more than 5 seconds. When you query again, you will find that the transaction has been rolled back.

mysql> select * from t1;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 11
Current database: test

Empty set (0.01 sec)

Last updated: 2026.05.28 15:17:48