| ' . "\n" . ' ' . $GLOBALS['strTotalUC'] . "\n" . ' : ' . PMA_formatNumber( $status['Innodb_buffer_pool_pages_total'], 0) . ' ' . $GLOBALS['strInnoDBPages'] . ' / ' . join(' ', PMA_formatByteDown($status['Innodb_buffer_pool_pages_total'] * $status['Innodb_page_size'])) . "\n" . ' | ' . "\n" . '|
|---|---|
| ' . $GLOBALS['strFreePages'] . ' | ' . "\n" . '' . PMA_formatNumber($status['Innodb_buffer_pool_pages_free'], 0) . ' | ' . "\n" . '
| ' . $GLOBALS['strDirtyPages'] . ' | ' . "\n" . '' . PMA_formatNumber($status['Innodb_buffer_pool_pages_dirty'], 0) . ' | ' . "\n" . '
| ' . $GLOBALS['strDataPages'] . ' | ' . "\n" . '' . PMA_formatNumber($status['Innodb_buffer_pool_pages_data'], 0) . "\n" . ' | ' . "\n" . '
| ' . $GLOBALS['strPagesToBeFlushed'] . ' | ' . "\n" . '' . PMA_formatNumber($status['Innodb_buffer_pool_pages_flushed'], 0) . "\n" . ' | ' . "\n" . '
| ' . $GLOBALS['strBusyPages'] . ' | ' . "\n" . '' . PMA_formatNumber($status['Innodb_buffer_pool_pages_misc'], 0) . "\n" . ' | ' . "\n" . '
| ' . $GLOBALS['strLatchedPages'] . ' | ' . '' . PMA_formatNumber($status['Innodb_buffer_pool_pages_latched'], 0) . ' | ' . '
| ' . $GLOBALS['strReadRequests'] . ' | ' . "\n" . '' . PMA_formatNumber($status['Innodb_buffer_pool_read_requests'], 0) . "\n" . ' | ' . "\n" . '
|---|---|
| ' . $GLOBALS['strWriteRequests'] . ' | ' . "\n" . '' . PMA_formatNumber($status['Innodb_buffer_pool_write_requests'], 0) . "\n" . ' | ' . "\n" . '
| ' . $GLOBALS['strBufferReadMisses'] . ' | ' . "\n" . '' . PMA_formatNumber($status['Innodb_buffer_pool_reads'], 0) . "\n" . ' | ' . "\n" . '
| ' . $GLOBALS['strBufferWriteWaits'] . ' | ' . "\n" . '' . PMA_formatNumber($status['Innodb_buffer_pool_wait_free'], 0) . "\n" . ' | ' . "\n" . '
| ' . $GLOBALS['strBufferReadMissesInPercent'] . ' | ' . "\n" . '' . ($status['Innodb_buffer_pool_read_requests'] == 0 ? '---' : htmlspecialchars(PMA_formatNumber($status['Innodb_buffer_pool_reads'] * 100 / $status['Innodb_buffer_pool_read_requests'], 3, 2)) . ' %') . "\n" . ' | ' . "\n" . '
| ' . $GLOBALS['strBufferWriteWaitsInPercent'] . ' | ' . "\n" . '' . ($status['Innodb_buffer_pool_write_requests'] == 0 ? '---' : htmlspecialchars(PMA_formatNumber($status['Innodb_buffer_pool_wait_free'] * 100 / $status['Innodb_buffer_pool_write_requests'], 3, 2)) . ' %') . "\n" . ' | ' . "\n" . '
' . "\n"
. htmlspecialchars(PMA_DBI_fetch_value('SHOW INNODB STATUS;', 0, 'Status')) . "\n"
. '' . "\n";
}
/**
* returns content for page $id
*
* @uses $this->getInfoPages()
* @uses array_key_exists()
* @param string $id page id
* @return string html output
*/
function getPage($id)
{
if (! array_key_exists($id, $this->getInfoPages())) {
return false;
}
$id = 'getPage' . $id;
return $this->$id();
}
/**
* returns string with filename for the MySQL helppage
* about this storage engne
*
* @return string mysql helppage filename
*/
function getMysqlHelpPage()
{
return 'innodb';
}
/**
*
* Gets the InnoDB plugin version number
* http://www.innodb.com/products/innodb_plugin
* (do not confuse this with phpMyAdmin's storage engine plugins!)
*
* @return string the version number, or empty if not running as a plugin
*/
function getInnodbPluginVersion()
{
return PMA_DBI_fetch_value('SELECT @@innodb_version;');
}
/**
*
* Gets the InnoDB file format
* (works only for the InnoDB plugin)
* http://www.innodb.com/products/innodb_plugin
* (do not confuse this with phpMyAdmin's storage engine plugins!)
*
* @return string the InnoDB file format
*/
function getInnodbFileFormat()
{
return PMA_DBI_fetch_value("SHOW GLOBAL VARIABLES LIKE 'innodb_file_format';", 0, 1);
}
/**
*
* Verifies if this server supports the innodb_file_per_table feature
* (works only for the InnoDB plugin)
* http://www.innodb.com/products/innodb_plugin
* (do not confuse this with phpMyAdmin's storage engine plugins!)
*
* @return boolean whether this feature is supported or not
*/
function supportsFilePerTable()
{
$innodb_file_per_table = PMA_DBI_fetch_value("SHOW GLOBAL VARIABLES LIKE 'innodb_file_per_table';", 0, 1);
if ($innodb_file_per_table == 'ON') {
return true;
} else {
return false;
}
}
}
?>