Mysql不关闭连接

Question

我有一个用连接池配置的Java应用程序。我已经确保应用程序正确地终止了连接。

但是，当我在mysql命令行上运行这个命令时-

show status like '%onn%';

+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Aborted_connects         | 2     |
| Connections              | 72    |
| Max_used_connections     | 10    |
| Ssl_client_connects      | 0     |
| Ssl_connect_renegotiates | 0     |
| Ssl_finished_connects    | 0     |
| Threads_connected        | 2     |
+--------------------------+-------+

为什么mysql在从客户端终止连接时保持打开？

my.cnf文件的内容是(注释和不重要的部分省略)-

[client]
port        = 3306
socket      = /var/run/mysqld/mysqld.sock

[mysqld]
user        = mysql
pid-file            = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
lc-messages-dir = /usr/share/mysql
lower_case_table_names = 1
skip-external-locking

key_buffer      = 16M
max_allowed_packet  = 16M
thread_stack    = 192K
thread_cache_size   = 8

myisam-recover      = BACKUP

query_cache_limit   = 1M
query_cache_size    = 16M

expire_logs_days    = 10
max_binlog_size     = 100M

Answer 1

根据MySQL文档，Connections状态变量显示“连接尝试(成功与否)到MySQL服务器的次数”。这意味着它不代表当前打开的连接，但是自服务器启动以来所有的连接尝试。

显示当前打开连接数的变量(同样根据MySQ文档 )是Threads_connected。