' . "\n" . ' ' . $strInnodbStat . "\n" . '' . "\n"; $sql_query = 'SHOW INNODB STATUS;'; $res = PMA_mysql_query($sql_query, $userlink) or PMA_mysqlDie(PMA_mysql_error($userlink), $sql_query); $row = PMA_mysql_fetch_row($res); echo '

' . "\n"
       . htmlspecialchars($row[0]) . "\n"
       . '

' . "\n"; mysql_free_result($res); require_once('./footer.inc.php'); } /** * Displays the sub-page heading */ echo '

' . "\n" . ' ' . $strServerStatus . "\n" . '

' . "\n"; /** * Checks if the user is allowed to do what he tries to... */ if (!$is_superuser && !$cfg['ShowMysqlInfo']) { echo $strNoPrivileges; require_once('./footer.inc.php'); } /** * Sends the query and buffers the result */ $res = @PMA_mysql_query('SHOW STATUS;', $userlink) or PMA_mysqlDie(PMA_mysql_error($userlink), 'SHOW STATUS;'); while ($row = PMA_mysql_fetch_row($res)) { $serverStatus[$row[0]] = $row[1]; } @mysql_free_result($res); unset($res); unset($row); /** * Displays the page */ //Uptime calculation $res = @PMA_mysql_query('SELECT UNIX_TIMESTAMP() - ' . $serverStatus['Uptime'] . ';'); $row = PMA_mysql_fetch_row($res); echo sprintf($strServerStatusUptime, PMA_timespanFormat($serverStatus['Uptime']), PMA_localisedDate($row[0])) . "\n"; mysql_free_result($res); unset($res); unset($row); //Get query statistics $queryStats = array(); $tmp_array = $serverStatus; foreach($tmp_array AS $name => $value) { if (substr($name, 0, 4) == 'Com_') { $queryStats[str_replace('_', ' ', substr($name, 4))] = $value; unset($serverStatus[$name]); } } unset($tmp_array); ?>

		ø

		ø	%
			0 ) ? number_format(($serverStatus['Aborted_connects'] * 100 / $serverStatus['Connections']), 2, $number_decimal_separator, $number_thousands_separator) . ' %' : '---'; ?>
			0 ) ? number_format(($serverStatus['Aborted_clients'] * 100 / $serverStatus['Connections']), 2 , $number_decimal_separator, $number_thousands_separator) . ' %' : '---'; ?>
			%

	ø	ø	ø

$value) { // For the percentage column, use Questions - Connections, because // the number of connections is not an item of the Query types // but is included in Questions. Then the total of the percentages is 100. ?>

		ø	%
			%

		ø	%

$value) { ?>