Php/docs/mysqlnduhconnection.getserverstatistics

• PHP Manual
• MysqlndUhConnection
• Gets the current system status

MysqlndUhConnection::getServerStatistics

(PECL mysqlnd-uh >= 1.0.0-alpha)

MysqlndUhConnection::getServerStatistics — Gets the current system status

説明

public MysqlndUhConnection::getServerStatistics ( mysqlnd_connection $connection ) : string

Gets the current system status.

パラメータ

connection

Mysqlnd connection handle. Do not modify!

返り値

The system status message.

例

例1 MysqlndUhConnection::getServerStatistics() example

<?phpclass proxy extends MysqlndUhConnection { public function getServerStatistics($res) {  printf("%s(%s)\n", __METHOD__, var_export(func_get_args(), true));  $ret = parent::getServerStatistics($res);  printf("%s returns %s\n", __METHOD__, var_export($ret, true));  return $ret; }}mysqlnd_uh_set_connection_proxy(new proxy());$mysqli = new mysqli("localhost", "root", "", "test");var_dump(mysqli_stat($mysqli));?>

上の例の出力は以下となります。

proxy::getServerStatistics(array (
  0 => NULL,
))
proxy::getServerStatistics returns 'Uptime: 2059995  Threads: 1  Questions: 126157  Slow queries: 0  Opens: 6377  Flush tables: 1  Open tables: 18  Queries per second avg: 0.61'
string(140) "Uptime: 2059995  Threads: 1  Questions: 126157  Slow queries: 0  Opens: 6377  Flush tables: 1  Open tables: 18  Queries per second avg: 0.61"

参考

• mysqlnd_uh_set_connection_proxy() - Installs a proxy for mysqlnd connections
• mysqli_stat() - 現在のシステム状態を取得する
• mysql_stat() - 現在のシステムの状態を取得する