参数介绍

mysql> show variables like '%idle%';
+------------------------------------+------+
| Variable_name                     | Value |
+-----------------------------------+-------+
| idle_readonly_transaction_timeout | 0     |
| idle_transaction_timeout         | 0     |
| idle_write_transaction_timeout   | 0     |
+-----------------------------------+-------+
​

上述三个变量的关系：idle_readonly_transaction_timeout和idle_write_transaction_timeout的优先级高于idle_transaction_timeout。

图1 只读事务

图2 读写事务