【php开源代码栏目提醒】:网学会员--在 php开源代码编辑为广大网友搜集整理了:innodb.lib.php绩等信息,祝愿广大网友取得需要的信息,参考学习。
<?php
/* $Id: innodb.lib.php,v 2.8 2005/12/07 11:24:38 cybot_tm Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:
class PMA_StorageEngine_innodb extends PMA_StorageEngine
{
/**
* @uses $GLOBALS['strInnoDBDataHomeDir']
* @uses $GLOBALS['strInnoDBDataHomeDirDesc']
* @uses $GLOBALS['strInnoDBDataFilePath']
* @uses $GLOBALS['strInnoDBAutoextendIncrement']
* @uses $GLOBALS['strInnoDBAutoextendIncrementDesc']
* @uses $GLOBALS['strInnoDBBufferPoolSize']
* @uses $GLOBALS['strInnoDBBufferPoolSizeDesc']
* @uses PMA_ENGINE_DETAILS_TYPE_NUMERIC
* @uses PMA_ENGINE_DETAILS_TYPE_SIZE
* @return array
*/
function getVariables()
{
return array(
'innodb_data_home_dir' => array(
'title' => $GLOBALS['strInnoDBDataHomeDir'],
'desc' => $GLOBALS['strInnoDBDataHomeDirDesc'],
),
'innodb_data_file_path' => array(
'title' => $GLOBALS['strInnoDBDataFilePath'],
),
'innodb_autoextend_increment' => array(
'title' => $GLOBALS['strInnoDBAutoextendIncrement'],
'desc' => $GLOBALS['strInnoDBAutoextendIncrementDesc'],
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
'innodb_buffer_pool_size' => array(
'title' => $GLOBALS['strInnoDBBufferPoolSize'],
'desc' => $GLOBALS['strInnoDBBufferPoolSizeDesc'],
'type' => PMA_ENGINE_DETAILS_TYPE_SIZE,
),
'innodb_additional_mem_pool_size' => array(
'title' => 'innodb_additional_mem_pool_size',
'type' => PMA_ENGINE_DETAILS_TYPE_SIZE,
),
'innodb_buffer_pool_awe_mem_mb' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_SIZE,
),
'innodb_checksums' => array(
),
'innodb_commit_concurrency' => array(
),
'innodb_concurrency_tickets' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
'innodb_doublewrite' => array(
),
'innodb_fast_shutdown' => array(
),
'innodb_file_io_threads' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
'innodb_file_per_table' => array(
),
'innodb_flush_log_at_trx_commit' => array(
),
'innodb_flush_method' => array(
),
'innodb_force_recovery' => array(
),
'innodb_lock_wait_timeout' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
'innodb_locks_unsafe_for_binlog' => array(
),
'innodb_log_arch_dir' => array(
),
'innodb_log_archive' => array(
),
'innodb_log_buffer_size' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_SIZE,
),
'innodb_log_file_size' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_SIZE,
),
'innodb_log_files_in_group' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
'innodb_log_group_home_dir' => array(
),
'innodb_max_dirty_pages_pct' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
'innodb_max_purge_lag' => array(
),
'innodb_mirrored_log_groups' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
'innodb_open_files' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
'innodb_support_xa' => array(
),
'innodb_sync_spin_loops' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
'innodb_table_locks' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
'innodb_thread_concurrency' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
'innodb_thread_sleep_delay' => array(
'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC,
),
);
}
/**
* @return string SQL query LIKE pattern
*/
function getVariablesLikePattern()
{
return 'innodb\\_%';
}
/**
* @uses $this->support
* @uses PMA_ENGINE_SUPPORT_YES
* @uses PMA_MYSQL_INT_VERSION
* @uses $GLOBALS['strBufferPool']
* @uses $GLOBALS['strInnodbStat']
* @return array detail pages
*/
function getInfoPages()
{
if ($this->support < PMA_ENGINE_SUPPORT_YES) {
return array();
}
$pages = array();
if (PMA_MYSQL_INT_VERSION >= 50002) {
$pages['Bufferpool'] = $GLOBALS['strBufferPool'];
}
$pages['Status'] = $GLOBALS['strInnodbStat'];
return $pages;
}
/**
* returns html tables with stats over inno db buffer pool
*
* @uses PMA_MYSQL_INT_VERSION
* @uses PMA_DBI_fetch_result()
* @uses PMA_formatNumber()
* @uses PMA_formatByteDown()
* @uses $GLOBALS['number_decimal_separator']
* @uses $GLOBALS['number_thousands_separator']
* @uses $GLOBALS['strBufferPoolUsage']
* @uses $GLOBALS['strTotalUC']
* @uses $GLOBALS['strInnoDBPages']
* @uses $GLOBALS['strFreePages']
* @uses $GLOBALS['strDirtyPages']
* @uses $GLOBALS['strDataPages']
* @uses $GLOBALS['strPagesToBeFlushed']
* @uses $GLOBALS['strBusyPages']
* @uses $GLOBALS['strLatchedPages']
* @uses $GLOBALS['strBufferPoolActivity']
* @us