[mysqld] interactive_timeout=20
交互式连接
会话1
[root@localhost ~]# mysql -umysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 Server version: 5.6.28-debug-log Source distribution Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
会话2
mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 8 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 9 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 9 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 10 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 10 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 11 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.01 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 12 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 12 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 13 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 14 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 14 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.01 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 15 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 16 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 16 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 17 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 18 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 18 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 19 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | | 10 | mysql | localhost | NULL | Sleep | 20 | | NULL | +----+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) mysql> show full processlist; +----+------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+------+---------+------+-------+-----------------------+ | 8 | root | localhost | NULL | Query | 0 | init | show full processlist | +----+------+-----------+------+---------+------+-------+-----------------------+ 1 row in set (0.00 sec)
20秒钟后,会话1,退去