SHOW STATUS 'Con%' 是否显示活动或总 MySQL 连接？

Understanding MySQL Connection Counts with SHOW STATUS

When running SHOW STATUS LIKE 'Con%', the output displays an ever-increasing number of connections. This raises the question: does this value represent active connections or the total number of connections established throughout the server's history?

The MySQL documentation clarifies that the number refers to the total number of connection attempts, both successful and unsuccessful, over the entire lifetime of the server:

Connections: The number of connection attempts (successful or not) to the MySQL server.

Identifying Active Connections

To view the number of active connections, use either the Threads_connected status variable or the SHOW PROCESSLIST command:

• Threads_connected:

SHOW STATUS WHERE `variable_name` = 'Threads_connected';

• SHOW PROCESSLIST:

SHOW PROCESSLIST;

These commands will provide an up-to-date count of active MySQL connections.

以上是SHOW STATUS 'Con%' 是否显示活动或总 MySQL 连接？的详细内容。更多信息请关注PHP中文网其他相关文章！