如何查看MySQL连接有多少是开放的? [英] How can I see how many MySQL connections are open?
问题描述
我怎么能看到多少个连接在当前请求期间通过 mysql_connect
在PHP中打开在Apache上运行?
How can I see how many connections have been opened during the current request via mysql_connect
in PHP running on Apache?
我知道,如果我叫 mysql_connect
函数100次使用相同的参数,它总是返回相同的连接链路。一旦连接已经存在,它不会启动新的连接。
I know that if I call mysql_connect
function 100 times with the same parameters, it will always return the same connection link. It will not start new connection once the connection already exists.
但我只是想确认 mysql_connect
不是开始一个新的。
But I just want to make sure mysql_connect
is not starting a new one.
我与其中包含许多 mysql_connect
函数调用遗留系统的工作。
I am working with a legacy system which contains many mysql_connect
function calls.
是否有任何的Apache设置或有什么办法我可以登录这个数字在Apache或MySQL的日志文件的连接?
Is there any setting in Apache or is there any way I can log this number of connections in Apache or MySQL log file?
推荐答案
我认为有几个方面:
SHOW STATUS WHERE `variable_name` = 'Threads_connected'
或者你可以做一个 SHOW PROCESSLIST
并找出在编号
列的唯一值。在旧的PHP API 的mysql
,有<一个href=\"http://php.net/manual/en/function.mysql-list-processes.php\"><$c$c>mysql_list_processes$c$c>函数,它同 SHOW PROCESSLIST
了。
or you can do a SHOW PROCESSLIST
and find out unique values in the Id
column. In old PHP API mysql
, there is mysql_list_processes
function that does the same as SHOW PROCESSLIST
, too.
但第一个应该为你工作。也许你可能想检查其他状态变量
But first one should work for you. And perhaps you might like to check on other STATUS variables
这篇关于如何查看MySQL连接有多少是开放的?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!