[
'title' => __('Data home directory'),
'desc' => __('The common part of the directory path for all InnoDB data files.'),
],
'innodb_data_file_path' => [
'title' => __('Data files'),
],
'innodb_autoextend_increment' => [
'title' => __('Autoextend increment'),
'desc' => __(
'The increment size for extending the size of an autoextending tablespace when it becomes full.'
),
'type' => StorageEngine::DETAILS_TYPE_NUMERIC,
],
'innodb_buffer_pool_size' => [
'title' => __('Buffer pool size'),
'desc' => __('The size of the memory buffer InnoDB uses to cache data and indexes of its tables.'),
'type' => StorageEngine::DETAILS_TYPE_SIZE,
],
'innodb_additional_mem_pool_size' => [
'title' => 'innodb_additional_mem_pool_size',
'type' => StorageEngine::DETAILS_TYPE_SIZE,
],
'innodb_buffer_pool_awe_mem_mb' => ['type' => StorageEngine::DETAILS_TYPE_SIZE],
'innodb_checksums' => [],
'innodb_commit_concurrency' => [],
'innodb_concurrency_tickets' => ['type' => StorageEngine::DETAILS_TYPE_NUMERIC],
'innodb_doublewrite' => [],
'innodb_fast_shutdown' => [],
'innodb_file_io_threads' => ['type' => StorageEngine::DETAILS_TYPE_NUMERIC],
'innodb_file_per_table' => [],
'innodb_flush_log_at_trx_commit' => [],
'innodb_flush_method' => [],
'innodb_force_recovery' => [],
'innodb_lock_wait_timeout' => ['type' => StorageEngine::DETAILS_TYPE_NUMERIC],
'innodb_locks_unsafe_for_binlog' => [],
'innodb_log_arch_dir' => [],
'innodb_log_archive' => [],
'innodb_log_buffer_size' => ['type' => StorageEngine::DETAILS_TYPE_SIZE],
'innodb_log_file_size' => ['type' => StorageEngine::DETAILS_TYPE_SIZE],
'innodb_log_files_in_group' => ['type' => StorageEngine::DETAILS_TYPE_NUMERIC],
'innodb_log_group_home_dir' => [],
'innodb_max_dirty_pages_pct' => ['type' => StorageEngine::DETAILS_TYPE_NUMERIC],
'innodb_max_purge_lag' => [],
'innodb_mirrored_log_groups' => ['type' => StorageEngine::DETAILS_TYPE_NUMERIC],
'innodb_open_files' => ['type' => StorageEngine::DETAILS_TYPE_NUMERIC],
'innodb_support_xa' => [],
'innodb_sync_spin_loops' => ['type' => StorageEngine::DETAILS_TYPE_NUMERIC],
'innodb_table_locks' => ['type' => StorageEngine::DETAILS_TYPE_BOOLEAN],
'innodb_thread_concurrency' => ['type' => StorageEngine::DETAILS_TYPE_NUMERIC],
'innodb_thread_sleep_delay' => ['type' => StorageEngine::DETAILS_TYPE_NUMERIC],
];
}
/**
* Returns the pattern to be used in the query for SQL variables
* related to InnoDb storage engine
*
* @return string SQL query LIKE pattern
*/
public function getVariablesLikePattern()
{
return 'innodb\\_%';
}
/**
* Get information pages
*
* @return array detail pages
*/
public function getInfoPages()
{
if ($this->support < StorageEngine::SUPPORT_YES) {
return [];
}
$pages = [];
$pages['Bufferpool'] = __('Buffer Pool');
$pages['Status'] = __('InnoDB Status');
return $pages;
}
/**
* returns html tables with stats over inno db buffer pool
*
* @return string html table with stats
*/
public function getPageBufferpool()
{
// The following query is only possible because we know
// that we are on MySQL 5 here (checked above)!
// side note: I love MySQL 5 for this. :-)
$sql = 'SHOW STATUS'
. ' WHERE Variable_name LIKE \'Innodb\\_buffer\\_pool\\_%\''
. ' OR Variable_name = \'Innodb_page_size\';';
$status = $GLOBALS['dbi']->fetchResult($sql, 0, 1);
/** @var string[] $bytes */
$bytes = Util::formatByteDown($status['Innodb_buffer_pool_pages_total'] * $status['Innodb_page_size']);
$output = '
' . "\n"
. ' ' . "\n"
. ' ' . __('Buffer Pool Usage') . "\n"
. ' ' . "\n"
. ' ' . "\n"
. ' ' . "\n"
. ' ' . "\n"
. ' ' . __('Total:') . ' '
. Util::formatNumber($status['Innodb_buffer_pool_pages_total'], 0)
. ' ' . __('pages')
. ' / '
. implode(' ', $bytes) . "\n"
. ' | ' . "\n"
. '
' . "\n"
. ' ' . "\n"
. ' ' . "\n"
. ' ' . "\n"
. ' ' . __('Free pages') . ' | ' . "\n"
. ' '
. Util::formatNumber($status['Innodb_buffer_pool_pages_free'], 0)
. ' | ' . "\n"
. '
' . "\n"
. ' ' . "\n"
. ' ' . __('Dirty pages') . ' | ' . "\n"
. ' '
. Util::formatNumber($status['Innodb_buffer_pool_pages_dirty'], 0)
. ' | ' . "\n"
. '
' . "\n"
. ' ' . "\n"
. ' ' . __('Pages containing data') . ' | ' . "\n"
. ' '
. Util::formatNumber($status['Innodb_buffer_pool_pages_data'], 0) . "\n"
. ' | ' . "\n"
. '
' . "\n"
. ' ' . "\n"
. ' ' . __('Pages to be flushed') . ' | ' . "\n"
. ' '
. Util::formatNumber($status['Innodb_buffer_pool_pages_flushed'], 0) . "\n"
. ' | ' . "\n"
. '
' . "\n"
. ' ' . "\n"
. ' ' . __('Busy pages') . ' | ' . "\n"
. ' '
. Util::formatNumber($status['Innodb_buffer_pool_pages_misc'], 0) . "\n"
. ' | ' . "\n"
. '
';
// not present at least since MySQL 5.1.40
if (isset($status['Innodb_buffer_pool_pages_latched'])) {
$output .= ' '
. ' ' . __('Latched pages') . ' | '
. ' '
. Util::formatNumber($status['Innodb_buffer_pool_pages_latched'], 0)
. ' | '
. '
';
}
$output .= ' ' . "\n"
. '
' . "\n\n"
. '' . "\n"
. ' ' . "\n"
. ' ' . __('Buffer Pool Activity') . "\n"
. ' ' . "\n"
. ' ' . "\n"
. ' ' . "\n"
. ' ' . __('Read requests') . ' | ' . "\n"
. ' '
. Util::formatNumber($status['Innodb_buffer_pool_read_requests'], 0) . "\n"
. ' | ' . "\n"
. '
' . "\n"
. ' ' . "\n"
. ' ' . __('Write requests') . ' | ' . "\n"
. ' '
. Util::formatNumber($status['Innodb_buffer_pool_write_requests'], 0) . "\n"
. ' | ' . "\n"
. '
' . "\n"
. ' ' . "\n"
. ' ' . __('Read misses') . ' | ' . "\n"
. ' '
. Util::formatNumber($status['Innodb_buffer_pool_reads'], 0) . "\n"
. ' | ' . "\n"
. '
' . "\n"
. ' ' . "\n"
. ' ' . __('Write waits') . ' | ' . "\n"
. ' '
. Util::formatNumber($status['Innodb_buffer_pool_wait_free'], 0) . "\n"
. ' | ' . "\n"
. '
' . "\n"
. ' ' . "\n"
. ' ' . __('Read misses in %') . ' | ' . "\n"
. ' '
. ($status['Innodb_buffer_pool_read_requests'] == 0
? '---'
: htmlspecialchars(
Util::formatNumber(
$status['Innodb_buffer_pool_reads'] * 100
/ $status['Innodb_buffer_pool_read_requests'],
3,
2
)
) . ' %') . "\n"
. ' | ' . "\n"
. '
' . "\n"
. ' ' . "\n"
. ' ' . __('Write waits in %') . ' | ' . "\n"
. ' '
. ($status['Innodb_buffer_pool_write_requests'] == 0
? '---'
: htmlspecialchars(
Util::formatNumber(
$status['Innodb_buffer_pool_wait_free'] * 100
/ $status['Innodb_buffer_pool_write_requests'],
3,
2
)
) . ' %') . "\n"
. ' | ' . "\n"
. '
' . "\n"
. ' ' . "\n"
. '
' . "\n";
return $output;
}
/**
* returns InnoDB status
*
* @return string result of SHOW ENGINE INNODB STATUS inside pre tags
*/
public function getPageStatus()
{
return '' . "\n"
. htmlspecialchars((string) $GLOBALS['dbi']->fetchValue(
'SHOW ENGINE INNODB STATUS;',
'Status'
)) . "\n" . '
' . "\n";
}
/**
* returns string with filename for the MySQL helppage
* about this storage engine
*
* @return string mysql helppage filename
*/
public function getMysqlHelpPage()
{
return 'innodb-storage-engine';
}
/**
* Gets the InnoDB plugin version number
*
* @return string the version number, or empty if not running as a plugin
*/
public function getInnodbPluginVersion()
{
return $GLOBALS['dbi']->fetchValue('SELECT @@innodb_version;') ?: '';
}
/**
* Gets the InnoDB file format
*
* (do not confuse this with phpMyAdmin's storage engine plugins!)
*
* @return string|null the InnoDB file format
*/
public function getInnodbFileFormat(): ?string
{
$value = $GLOBALS['dbi']->fetchValue("SHOW GLOBAL VARIABLES LIKE 'innodb_file_format';", 1);
if ($value === false) {
// This variable does not exist anymore on MariaDB >= 10.6.0
// This variable does not exist anymore on MySQL >= 8.0.0
return null;
}
return (string) $value;
}
/**
* Verifies if this server supports the innodb_file_per_table feature
*
* (do not confuse this with phpMyAdmin's storage engine plugins!)
*/
public function supportsFilePerTable(): bool
{
return $GLOBALS['dbi']->fetchValue("SHOW GLOBAL VARIABLES LIKE 'innodb_file_per_table';", 1) === 'ON';
}
}