<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Library for extracting information about the available storage engines * * @package PhpMyAdmin */ namespace PMA\libraries; /** * defines */ use PMA\libraries\engines\Bdb; use PMA\libraries\engines\Berkeleydb; use PMA\libraries\engines\Binlog; use PMA\libraries\engines\Innobase; use PMA\libraries\engines\Innodb; use PMA\libraries\engines\Memory; use PMA\libraries\engines\Merge; use PMA\libraries\engines\Mrg_Myisam; use PMA\libraries\engines\Myisam; use PMA\libraries\engines\Ndbcluster; use PMA\libraries\engines\Pbxt; use PMA\libraries\engines\Performance_Schema; define('PMA_ENGINE_SUPPORT_NO', 0); define('PMA_ENGINE_SUPPORT_DISABLED', 1); define('PMA_ENGINE_SUPPORT_YES', 2); define('PMA_ENGINE_SUPPORT_DEFAULT', 3); define('PMA_ENGINE_DETAILS_TYPE_PLAINTEXT', 0); define('PMA_ENGINE_DETAILS_TYPE_SIZE', 1); define('PMA_ENGINE_DETAILS_TYPE_NUMERIC', 2); //Has no effect yet... define('PMA_ENGINE_DETAILS_TYPE_BOOLEAN', 3); // 'ON' or 'OFF' /** * Base Storage Engine Class * * @package PhpMyAdmin */ class StorageEngine { /** * @var string engine name */ var $engine = 'dummy'; /** * @var string engine title/description */ var $title = 'PMA Dummy Engine Class'; /** * @var string engine lang description */ var $comment = 'If you read this text inside phpMyAdmin, something went wrong...'; /** * @var integer engine supported by current server */ var $support = PMA_ENGINE_SUPPORT_NO; /** * Constructor * * @param string $engine The engine ID */ public function __construct($engine) { $storage_engines = StorageEngine::getStorageEngines(); if (! empty($storage_engines[$engine])) { $this->engine = $engine; $this->title = $storage_engines[$engine]['Engine']; $this->comment = (isset($storage_engines[$engine]['Comment']) ? $storage_engines[$engine]['Comment'] : ''); switch ($storage_engines[$engine]['Support']) { case 'DEFAULT': $this->support = PMA_ENGINE_SUPPORT_DEFAULT; break; case 'YES': $this->support = PMA_ENGINE_SUPPORT_YES; break; case 'DISABLED': $this->support = PMA_ENGINE_SUPPORT_DISABLED; break; case 'NO': default: $this->support = PMA_ENGINE_SUPPORT_NO; } } } /** * Returns array of storage engines * * @static * @staticvar array $storage_engines storage engines * @access public * @return string[] array of storage engines */ static public function getStorageEngines() { static $storage_engines = null; if (null == $storage_engines) { $storage_engines = $GLOBALS['dbi']->fetchResult('SHOW STORAGE ENGINES', 'Engine'); if (PMA_MYSQL_INT_VERSION >= 50708) { $disabled = Util::cacheGet( 'disabled_storage_engines', function () { return $GLOBALS['dbi']->fetchValue( 'SELECT @@disabled_storage_engines' ); } ); foreach (explode(",", $disabled) as $engine) { if (isset($storage_engines[$engine])) { $storage_engines[$engine]['Support'] = 'DISABLED'; } } } } return $storage_engines; } /** * Returns HTML code for storage engine select box * * @param string $name The name of the select form element * @param string $id The ID of the form field * @param string $selected The selected engine * @param boolean $offerUnavailableEngines Should unavailable storage * engines be offered? * @param boolean $addEmpty Whether to provide empty option * * @static * @return string html selectbox */ static public function getHtmlSelect( $name = 'engine', $id = null, $selected = null, $offerUnavailableEngines = false, $addEmpty = false ) { $selected = mb_strtolower($selected); $output = '<select name="' . $name . '"' . (empty($id) ? '' : ' id="' . $id . '"') . '>' . "\n"; if ($addEmpty) { $output .= '<option value=""></option>'; } foreach (StorageEngine::getStorageEngines() as $key => $details) { // Don't show PERFORMANCE_SCHEMA engine (MySQL 5.5) if (! $offerUnavailableEngines && ($details['Support'] == 'NO' || $details['Support'] == 'DISABLED' || $details['Engine'] == 'PERFORMANCE_SCHEMA') ) { continue; } $output .= ' <option value="' . htmlspecialchars($key) . '"' . (empty($details['Comment']) ? '' : ' title="' . htmlspecialchars($details['Comment']) . '"') . (mb_strtolower($key) == $selected || (empty($selected) && $details['Support'] == 'DEFAULT' && ! $addEmpty) ? ' selected="selected"' : '') . '>' . "\n" . ' ' . htmlspecialchars($details['Engine']) . "\n" . ' </option>' . "\n"; } $output .= '</select>' . "\n"; return $output; } /** * Loads the corresponding engine plugin, if available. * * @param string $engine The engine ID * * @return StorageEngine The engine plugin * @static */ static public function getEngine($engine) { switch(strtolower($engine)) { case 'bdb': return new Bdb($engine); case 'berkeleydb': return new Berkeleydb($engine); case 'binlog': return new Binlog($engine); case 'innobase': return new Innobase($engine); case 'innodb': return new Innodb($engine); case 'memory': return new Memory($engine); case 'merge': return new Merge($engine); case 'mrg_myisam': return new Mrg_Myisam($engine); case 'myisam': return new Myisam($engine); case 'ndbcluster': return new Ndbcluster($engine); case 'pbxt': return new Pbxt($engine); case 'performance_schema': return new Performance_Schema($engine); default: return new StorageEngine($engine); } } /** * Returns true if given engine name is supported/valid, otherwise false * * @param string $engine name of engine * * @static * @return boolean whether $engine is valid or not */ static public function isValid($engine) { if ($engine == "PBMS") { return true; } $storage_engines = StorageEngine::getStorageEngines(); return isset($storage_engines[$engine]); } /** * Returns as HTML table of the engine's server variables * * @return string The table that was generated based on the retrieved * information */ public function getHtmlVariables() { $odd_row = false; $ret = ''; foreach ($this->getVariablesStatus() as $details) { $ret .= '<tr class="' . ($odd_row ? 'odd' : 'even') . '">' . "\n" . ' <td>' . "\n"; if (! empty($details['desc'])) { $ret .= ' ' . Util::showHint($details['desc']) . "\n"; } $ret .= ' </td>' . "\n" . ' <th>' . htmlspecialchars($details['title']) . '</th>' . "\n" . ' <td class="value">'; switch ($details['type']) { case PMA_ENGINE_DETAILS_TYPE_SIZE: $parsed_size = $this->resolveTypeSize($details['value']); $ret .= $parsed_size[0] . ' ' . $parsed_size[1]; unset($parsed_size); break; case PMA_ENGINE_DETAILS_TYPE_NUMERIC: $ret .= Util::formatNumber($details['value']) . ' '; break; default: $ret .= htmlspecialchars($details['value']) . ' '; } $ret .= '</td>' . "\n" . '</tr>' . "\n"; $odd_row = ! $odd_row; } if (! $ret) { $ret = '<p>' . "\n" . ' ' . __( 'There is no detailed status information available for this ' . 'storage engine.' ) . "\n" . '</p>' . "\n"; } else { $ret = '<table class="data">' . "\n" . $ret . '</table>' . "\n"; } return $ret; } /** * Returns the engine specific handling for * PMA_ENGINE_DETAILS_TYPE_SIZE type variables. * * This function should be overridden when * PMA_ENGINE_DETAILS_TYPE_SIZE type needs to be * handled differently for a particular engine. * * @param integer $value Value to format * * @return string the formatted value and its unit */ public function resolveTypeSize($value) { return Util::formatByteDown($value); } /** * Returns array with detailed info about engine specific server variables * * @return array array with detailed info about specific engine server variables */ public function getVariablesStatus() { $variables = $this->getVariables(); $like = $this->getVariablesLikePattern(); if ($like) { $like = " LIKE '" . $like . "' "; } else { $like = ''; } $mysql_vars = array(); $sql_query = 'SHOW GLOBAL VARIABLES ' . $like . ';'; $res = $GLOBALS['dbi']->query($sql_query); while ($row = $GLOBALS['dbi']->fetchAssoc($res)) { if (isset($variables[$row['Variable_name']])) { $mysql_vars[$row['Variable_name']] = $variables[$row['Variable_name']]; } elseif (! $like && mb_strpos(mb_strtolower($row['Variable_name']), mb_strtolower($this->engine)) !== 0 ) { continue; } $mysql_vars[$row['Variable_name']]['value'] = $row['Value']; if (empty($mysql_vars[$row['Variable_name']]['title'])) { $mysql_vars[$row['Variable_name']]['title'] = $row['Variable_name']; } if (! isset($mysql_vars[$row['Variable_name']]['type'])) { $mysql_vars[$row['Variable_name']]['type'] = PMA_ENGINE_DETAILS_TYPE_PLAINTEXT; } } $GLOBALS['dbi']->freeResult($res); return $mysql_vars; } /** * Reveals the engine's title * * @return string The title */ public function getTitle() { return $this->title; } /** * Fetches the server's comment about this engine * * @return string The comment */ public function getComment() { return $this->comment; } /** * Information message on whether this storage engine is supported * * @return string The localized message. */ public function getSupportInformationMessage() { switch ($this->support) { case PMA_ENGINE_SUPPORT_DEFAULT: $message = __('%s is the default storage engine on this MySQL server.'); break; case PMA_ENGINE_SUPPORT_YES: $message = __('%s is available on this MySQL server.'); break; case PMA_ENGINE_SUPPORT_DISABLED: $message = __('%s has been disabled for this MySQL server.'); break; case PMA_ENGINE_SUPPORT_NO: default: $message = __( 'This MySQL server does not support the %s storage engine.' ); } return sprintf($message, htmlspecialchars($this->title)); } /** * Generates a list of MySQL variables that provide information about this * engine. This function should be overridden when extending this class * for a particular engine. * * @return array The list of variables. */ public function getVariables() { return array(); } /** * Returns string with filename for the MySQL helppage * about this storage engine * * @return string MySQL help page filename */ public function getMysqlHelpPage() { return $this->engine . '-storage-engine'; } /** * Returns the pattern to be used in the query for SQL variables * related to the storage engine * * @return string SQL query LIKE pattern */ public function getVariablesLikePattern() { return ''; } /** * Returns a list of available information pages with labels * * @return string[] The list */ public function getInfoPages() { return array(); } /** * Generates the requested information page * * @param string $id page id * * @return string html output */ public function getPage($id) { if (! array_key_exists($id, $this->getInfoPages())) { return ''; } $id = 'getPage' . $id; return $this->$id(); } }
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
bfShapeFiles | Folder | 0755 |
|
|
config | Folder | 0755 |
|
|
controllers | Folder | 0755 |
|
|
dbi | Folder | 0755 |
|
|
di | Folder | 0755 |
|
|
engines | Folder | 0755 |
|
|
gis | Folder | 0755 |
|
|
navigation | Folder | 0755 |
|
|
plugins | Folder | 0755 |
|
|
properties | Folder | 0755 |
|
|
rte | Folder | 0755 |
|
|
sql-parser | Folder | 0755 |
|
|
Advisor.php | File | 15.13 KB | 0644 |
|
Config.php | File | 54.7 KB | 0644 |
|
Console.php | File | 14.82 KB | 0644 |
|
DatabaseInterface.php | File | 95.6 KB | 0644 |
|
DbList.php | File | 1.9 KB | 0644 |
|
DbQbe.php | File | 68.87 KB | 0644 |
|
DbSearch.php | File | 17.21 KB | 0644 |
|
DisplayResults.php | File | 206 KB | 0644 |
|
Error.php | File | 12.7 KB | 0644 |
|
ErrorHandler.php | File | 16.48 KB | 0644 |
|
File.php | File | 18.82 KB | 0644 |
|
Font.php | File | 4.24 KB | 0644 |
|
Footer.php | File | 10.52 KB | 0644 |
|
Header.php | File | 25.34 KB | 0644 |
|
Index.php | File | 23.79 KB | 0644 |
|
IndexColumn.php | File | 4.46 KB | 0644 |
|
Language.php | File | 4.27 KB | 0644 |
|
LanguageManager.php | File | 20.75 KB | 0644 |
|
Linter.php | File | 5.02 KB | 0644 |
|
ListAbstract.php | File | 3.15 KB | 0644 |
|
ListDatabase.php | File | 4.62 KB | 0644 |
|
Menu.php | File | 21.14 KB | 0644 |
|
Message.php | File | 18.67 KB | 0644 |
|
OutputBuffering.php | File | 3.59 KB | 0644 |
|
PDF.php | File | 3.94 KB | 0644 |
|
Partition.php | File | 7.26 KB | 0644 |
|
Psr4Autoloader.php | File | 4.85 KB | 0644 |
|
RecentFavoriteTable.php | File | 11.78 KB | 0644 |
|
Response.php | File | 12.61 KB | 0644 |
|
SavedSearches.php | File | 11.67 KB | 0644 |
|
Scripts.php | File | 7.38 KB | 0644 |
|
ServerStatusData.php | File | 15.72 KB | 0644 |
|
StorageEngine.php | File | 13.61 KB | 0644 |
|
SubPartition.php | File | 3.52 KB | 0644 |
|
SysInfo.php | File | 799 B | 0644 |
|
SysInfoLinux.php | File | 1.92 KB | 0644 |
|
SysInfoSunOS.php | File | 1.86 KB | 0644 |
|
SysInfoWINNT.php | File | 3.08 KB | 0644 |
|
SystemDatabase.php | File | 3.66 KB | 0644 |
|
Table.php | File | 88.12 KB | 0644 |
|
Template.php | File | 4.45 KB | 0644 |
|
Theme.php | File | 11.34 KB | 0644 |
|
ThemeManager.php | File | 12.91 KB | 0644 |
|
Tracker.php | File | 30.35 KB | 0644 |
|
Types.php | File | 6.08 KB | 0644 |
|
TypesMySQL.php | File | 17.26 KB | 0644 |
|
Util.php | File | 172.46 KB | 0644 |
|
VersionInformation.php | File | 7.87 KB | 0644 |
|
ZipFile.php | File | 6.63 KB | 0644 |
|
advisor.lib.php | File | 1.6 KB | 0644 |
|
advisory_rules.txt | File | 25.94 KB | 0644 |
|
autoloader.php | File | 450 B | 0644 |
|
bookmark.lib.php | File | 8.5 KB | 0644 |
|
browse_foreigners.lib.php | File | 9.83 KB | 0644 |
|
central_columns.lib.php | File | 49.38 KB | 0644 |
|
charset_conversion.lib.php | File | 3.54 KB | 0644 |
|
check_user_privileges.lib.php | File | 10.65 KB | 0644 |
|
cleanup.lib.php | File | 1.29 KB | 0644 |
|
common.inc.php | File | 34.38 KB | 0644 |
|
config.default.php | File | 66.5 KB | 0644 |
|
config.values.php | File | 10.17 KB | 0644 |
|
core.lib.php | File | 29.94 KB | 0644 |
|
create_addfield.lib.php | File | 15.68 KB | 0644 |
|
database_interface.inc.php | File | 2.63 KB | 0644 |
|
db_common.inc.php | File | 3.12 KB | 0644 |
|
db_designer.lib.php | File | 10.4 KB | 0644 |
|
db_table_exists.lib.php | File | 3.21 KB | 0644 |
|
display_change_password.lib.php | File | 5.45 KB | 0644 |
|
display_create_table.lib.php | File | 1.53 KB | 0644 |
|
display_export.lib.php | File | 38.11 KB | 0644 |
|
display_git_revision.lib.php | File | 3.04 KB | 0644 |
|
display_import.lib.php | File | 24.34 KB | 0644 |
|
display_import_ajax.lib.php | File | 3.13 KB | 0644 |
|
display_select_lang.lib.php | File | 2.36 KB | 0644 |
|
error.inc.php | File | 1.21 KB | 0644 |
|
error_report.lib.php | File | 10.25 KB | 0644 |
|
export.lib.php | File | 35.16 KB | 0644 |
|
file_listing.lib.php | File | 2.37 KB | 0644 |
|
iconv_wrapper.lib.php | File | 3.88 KB | 0644 |
|
import.lib.php | File | 50.64 KB | 0644 |
|
index.lib.php | File | 1.37 KB | 0644 |
|
information_schema_relations.lib.php | File | 10.95 KB | 0644 |
|
insert_edit.lib.php | File | 112.79 KB | 0644 |
|
ip_allow_deny.lib.php | File | 9.35 KB | 0644 |
|
js_escape.lib.php | File | 4.43 KB | 0644 |
|
kanji-encoding.lib.php | File | 4.46 KB | 0644 |
|
language_stats.inc.php | File | 1.45 KB | 0644 |
|
logging.lib.php | File | 521 B | 0644 |
|
mime.lib.php | File | 704 B | 0644 |
|
mult_submits.inc.php | File | 10.64 KB | 0644 |
|
mult_submits.lib.php | File | 20.44 KB | 0644 |
|
mysql_charsets.inc.php | File | 4.09 KB | 0644 |
|
mysql_charsets.lib.php | File | 10.47 KB | 0644 |
|
mysql_relations.lib.php | File | 5.12 KB | 0644 |
|
normalization.lib.php | File | 33.98 KB | 0644 |
|
opendocument.lib.php | File | 7.94 KB | 0644 |
|
operations.lib.php | File | 73.64 KB | 0644 |
|
parse_analyze.lib.php | File | 2.12 KB | 0644 |
|
plugin_interface.lib.php | File | 19.69 KB | 0644 |
|
plugin_interface.lib.php.bak | File | 19.69 KB | 0644 |
|
pmd_common.php | File | 24.2 KB | 0644 |
|
relation.lib.php | File | 68.41 KB | 0644 |
|
relation_cleanup.lib.php | File | 13.84 KB | 0644 |
|
replication.inc.php | File | 8.82 KB | 0644 |
|
replication_gui.lib.php | File | 37.45 KB | 0644 |
|
sanitizing.lib.php | File | 6.3 KB | 0644 |
|
select_server.lib.php | File | 3.4 KB | 0644 |
|
server_common.inc.php | File | 1.22 KB | 0644 |
|
server_common.lib.php | File | 1.92 KB | 0644 |
|
server_privileges.lib.php | File | 179.22 KB | 0644 |
|
server_status.lib.php | File | 9.92 KB | 0644 |
|
server_status_advisor.lib.php | File | 1.89 KB | 0644 |
|
server_status_monitor.lib.php | File | 26.22 KB | 0644 |
|
server_status_processes.lib.php | File | 9.57 KB | 0644 |
|
server_status_queries.lib.php | File | 4.86 KB | 0644 |
|
server_status_variables.lib.php | File | 28.95 KB | 0644 |
|
server_user_groups.lib.php | File | 12.8 KB | 0644 |
|
server_users.lib.php | File | 1.35 KB | 0644 |
|
session.inc.php | File | 5.22 KB | 0644 |
|
session.lib.php | File | 735 B | 0644 |
|
special_schema_links.lib.php | File | 17.51 KB | 0644 |
|
sql.lib.php | File | 77.51 KB | 0644 |
|
sql.lib.php.bak | File | 77.51 KB | 0644 |
|
sql_query_form.lib.php | File | 15.71 KB | 0644 |
|
string.lib.php | File | 800 B | 0644 |
|
stringMb.lib.php | File | 1.86 KB | 0644 |
|
stringNative.lib.php | File | 6.82 KB | 0644 |
|
sysinfo.lib.php | File | 1.34 KB | 0644 |
|
tbl_columns_definition_form.inc.php | File | 13.55 KB | 0644 |
|
tbl_common.inc.php | File | 1.3 KB | 0644 |
|
tbl_info.inc.php | File | 3.54 KB | 0644 |
|
tbl_partition_definition.inc.php | File | 5.55 KB | 0644 |
|
tracking.lib.php | File | 54.93 KB | 0644 |
|
transformations.lib.php | File | 14.63 KB | 0644 |
|
url_generating.lib.php | File | 6.77 KB | 0644 |
|
user_preferences.inc.php | File | 2.38 KB | 0644 |
|
user_preferences.lib.php | File | 8.17 KB | 0644 |
|
util.lib.php | File | 749 B | 0644 |
|
vendor_config.php | File | 2.49 KB | 0644 |
|
zip_extension.lib.php | File | 5.38 KB | 0644 |
|