<?php[email protected] _connect("localhost","root","");
if (!$handle)
{
die("No connection to database");
}
echo 'Total number of all-time mysql-queries: '.getTotalNumberOfMySQLQuerys();
//Returns integer-value of the total number of alltime mysql-calls that have been made
function getTotalNumberOfMySQLQuerys()
{
//global mysql-status containing the number of querys has been renamed in newer versions of mysql
$mysqlVersion=getMysqlVersion();
//contact helper-function to receive the mysql-version
if ($mysqlVersion()>=50002)
{
$sql="SHOW GLOBAL STATUS LIKE 'Questions'";
}
else
{
$sql="SHOW STATUS LIKE 'Questions'";
}
[email protected] _query( $sql );
[email protected] _fetch_array( $result );
return $row['Value'];
}
//helper function is needed to detect the exact mysql-version
function getMysqlVersion()
{
$sql = 'SELECT VERSION() AS versionsinfo';
$result = @mysql_query('SELECT VERSION() AS versionsinfo');
$version = @mysql_result( $result, 0, "versionsinfo" );
$match = explode('.',$version);
return sprintf('%d%02d%02d',$match[0],$match[1],intval($match[2]));
}
?>
由于全局mysql-status-variable的名称包含在更高版本的mysql中更改的查询数,因此需要一个辅助函数来检测您正在运行的mysql的确切版本。
翻译自: https://css-tricks.com/snippets/php/get-all-time-number-of-mysql-queries/