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中文網其他相關文章！