diff options
Diffstat (limited to 'srcs/phpmyadmin/libraries/classes/Engines')
12 files changed, 992 insertions, 0 deletions
diff --git a/srcs/phpmyadmin/libraries/classes/Engines/Bdb.php b/srcs/phpmyadmin/libraries/classes/Engines/Bdb.php new file mode 100644 index 0000000..70919e3 --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/Bdb.php @@ -0,0 +1,76 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The BDB storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +use PhpMyAdmin\StorageEngine; + +/** + * The BDB storage engine + * + * @package PhpMyAdmin-Engines + */ +class Bdb extends StorageEngine +{ + /** + * Returns array with variable names related to this storage engine + * + * @return array variable names + */ + public function getVariables() + { + return [ + 'version_bdb' => [ + 'title' => __('Version information'), + ], + 'bdb_cache_size' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'bdb_home' => [], + 'bdb_log_buffer_size' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'bdb_logdir' => [], + 'bdb_max_lock' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'bdb_shared_data' => [], + 'bdb_tmpdir' => [], + 'bdb_data_direct' => [], + 'bdb_lock_detect' => [], + 'bdb_log_direct' => [], + 'bdb_no_recover' => [], + 'bdb_no_sync' => [], + 'skip_sync_bdb_logs' => [], + 'sync_bdb_logs' => [], + ]; + } + + /** + * Returns the pattern to be used in the query for SQL variables + * related to this storage engine + * + * @return string LIKE pattern + */ + public function getVariablesLikePattern() + { + return '%bdb%'; + } + + /** + * returns string with filename for the MySQL helppage + * about this storage engine + * + * @return string mysql helppage filename + */ + public function getMysqlHelpPage() + { + return 'bdb'; + } +} diff --git a/srcs/phpmyadmin/libraries/classes/Engines/Berkeleydb.php b/srcs/phpmyadmin/libraries/classes/Engines/Berkeleydb.php new file mode 100644 index 0000000..0c69d5f --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/Berkeleydb.php @@ -0,0 +1,19 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The BerkeleyDB storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +/** + * This is same as BDB + * + * @package PhpMyAdmin-Engines + */ +class Berkeleydb extends Bdb +{ +} diff --git a/srcs/phpmyadmin/libraries/classes/Engines/Binlog.php b/srcs/phpmyadmin/libraries/classes/Engines/Binlog.php new file mode 100644 index 0000000..33d2eb1 --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/Binlog.php @@ -0,0 +1,31 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The binary log storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +use PhpMyAdmin\StorageEngine; + +/** + * The binary log storage engine + * + * @package PhpMyAdmin-Engines + */ +class Binlog extends StorageEngine +{ + /** + * Returns string with filename for the MySQL helppage + * about this storage engine + * + * @return string mysql helppage filename + */ + public function getMysqlHelpPage() + { + return 'binary-log'; + } +} diff --git a/srcs/phpmyadmin/libraries/classes/Engines/Innobase.php b/srcs/phpmyadmin/libraries/classes/Engines/Innobase.php new file mode 100644 index 0000000..f806359 --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/Innobase.php @@ -0,0 +1,19 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The Innobase storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +/** + * The Innobase storage engine + * + * @package PhpMyAdmin-Engines + */ +class Innobase extends Innodb +{ +} diff --git a/srcs/phpmyadmin/libraries/classes/Engines/Innodb.php b/srcs/phpmyadmin/libraries/classes/Engines/Innodb.php new file mode 100644 index 0000000..e7e7a1f --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/Innodb.php @@ -0,0 +1,395 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The InnoDB storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +use PhpMyAdmin\StorageEngine; +use PhpMyAdmin\Util; + +/** + * The InnoDB storage engine + * + * @package PhpMyAdmin-Engines + */ +class Innodb extends StorageEngine +{ + /** + * Returns array with variable names related to InnoDB storage engine + * + * @return array variable names + */ + public function getVariables() + { + return [ + 'innodb_data_home_dir' => [ + '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' => PMA_ENGINE_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' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'innodb_additional_mem_pool_size' => [ + 'title' => 'innodb_additional_mem_pool_size', + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'innodb_buffer_pool_awe_mem_mb' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'innodb_checksums' => [], + 'innodb_commit_concurrency' => [], + 'innodb_concurrency_tickets' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'innodb_doublewrite' => [], + 'innodb_fast_shutdown' => [], + 'innodb_file_io_threads' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'innodb_file_per_table' => [], + 'innodb_flush_log_at_trx_commit' => [], + 'innodb_flush_method' => [], + 'innodb_force_recovery' => [], + 'innodb_lock_wait_timeout' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'innodb_locks_unsafe_for_binlog' => [], + 'innodb_log_arch_dir' => [], + 'innodb_log_archive' => [], + 'innodb_log_buffer_size' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'innodb_log_file_size' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'innodb_log_files_in_group' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'innodb_log_group_home_dir' => [], + 'innodb_max_dirty_pages_pct' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'innodb_max_purge_lag' => [], + 'innodb_mirrored_log_groups' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'innodb_open_files' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'innodb_support_xa' => [], + 'innodb_sync_spin_loops' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'innodb_table_locks' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_BOOLEAN, + ], + 'innodb_thread_concurrency' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'innodb_thread_sleep_delay' => [ + 'type' => PMA_ENGINE_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 < PMA_ENGINE_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); + + $output = '<table class="data" id="table_innodb_bufferpool_usage">' . "\n" + . ' <caption class="tblHeaders">' . "\n" + . ' ' . __('Buffer Pool Usage') . "\n" + . ' </caption>' . "\n" + . ' <tfoot>' . "\n" + . ' <tr>' . "\n" + . ' <th colspan="2">' . "\n" + . ' ' . __('Total') . "\n" + . ' : ' + . Util::formatNumber( + $status['Innodb_buffer_pool_pages_total'], + 0 + ) + . ' ' . __('pages') + . ' / ' + . implode( + ' ', + Util::formatByteDown( + $status['Innodb_buffer_pool_pages_total'] + * $status['Innodb_page_size'] + ) + ) . "\n" + . ' </th>' . "\n" + . ' </tr>' . "\n" + . ' </tfoot>' . "\n" + . ' <tbody>' . "\n" + . ' <tr>' . "\n" + . ' <th>' . __('Free pages') . '</th>' . "\n" + . ' <td class="value">' + . Util::formatNumber( + $status['Innodb_buffer_pool_pages_free'], + 0 + ) + . '</td>' . "\n" + . ' </tr>' . "\n" + . ' <tr>' . "\n" + . ' <th>' . __('Dirty pages') . '</th>' . "\n" + . ' <td class="value">' + . Util::formatNumber( + $status['Innodb_buffer_pool_pages_dirty'], + 0 + ) + . '</td>' . "\n" + . ' </tr>' . "\n" + . ' <tr>' . "\n" + . ' <th>' . __('Pages containing data') . '</th>' . "\n" + . ' <td class="value">' + . Util::formatNumber( + $status['Innodb_buffer_pool_pages_data'], + 0 + ) . "\n" + . '</td>' . "\n" + . ' </tr>' . "\n" + . ' <tr>' . "\n" + . ' <th>' . __('Pages to be flushed') . '</th>' . "\n" + . ' <td class="value">' + . Util::formatNumber( + $status['Innodb_buffer_pool_pages_flushed'], + 0 + ) . "\n" + . '</td>' . "\n" + . ' </tr>' . "\n" + . ' <tr>' . "\n" + . ' <th>' . __('Busy pages') . '</th>' . "\n" + . ' <td class="value">' + . Util::formatNumber( + $status['Innodb_buffer_pool_pages_misc'], + 0 + ) . "\n" + . '</td>' . "\n" + . ' </tr>'; + + // not present at least since MySQL 5.1.40 + if (isset($status['Innodb_buffer_pool_pages_latched'])) { + $output .= ' <tr>' + . ' <th>' . __('Latched pages') . '</th>' + . ' <td class="value">' + . Util::formatNumber( + $status['Innodb_buffer_pool_pages_latched'], + 0 + ) + . '</td>' + . ' </tr>'; + } + + $output .= ' </tbody>' . "\n" + . '</table>' . "\n\n" + . '<table class="data" id="table_innodb_bufferpool_activity">' . "\n" + . ' <caption class="tblHeaders">' . "\n" + . ' ' . __('Buffer Pool Activity') . "\n" + . ' </caption>' . "\n" + . ' <tbody>' . "\n" + . ' <tr>' . "\n" + . ' <th>' . __('Read requests') . '</th>' . "\n" + . ' <td class="value">' + . Util::formatNumber( + $status['Innodb_buffer_pool_read_requests'], + 0 + ) . "\n" + . '</td>' . "\n" + . ' </tr>' . "\n" + . ' <tr>' . "\n" + . ' <th>' . __('Write requests') . '</th>' . "\n" + . ' <td class="value">' + . Util::formatNumber( + $status['Innodb_buffer_pool_write_requests'], + 0 + ) . "\n" + . '</td>' . "\n" + . ' </tr>' . "\n" + . ' <tr>' . "\n" + . ' <th>' . __('Read misses') . '</th>' . "\n" + . ' <td class="value">' + . Util::formatNumber( + $status['Innodb_buffer_pool_reads'], + 0 + ) . "\n" + . '</td>' . "\n" + . ' </tr>' . "\n" + . ' <tr>' . "\n" + . ' <th>' . __('Write waits') . '</th>' . "\n" + . ' <td class="value">' + . Util::formatNumber( + $status['Innodb_buffer_pool_wait_free'], + 0 + ) . "\n" + . '</td>' . "\n" + . ' </tr>' . "\n" + . ' <tr>' . "\n" + . ' <th>' . __('Read misses in %') . '</th>' . "\n" + . ' <td class="value">' + . ($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" + . '</td>' . "\n" + . ' </tr>' . "\n" + . ' <tr>' . "\n" + . ' <th>' . __('Write waits in %') . '</th>' . "\n" + . ' <td class="value">' + . ($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" + . '</td>' . "\n" + . ' </tr>' . "\n" + . ' </tbody>' . "\n" + . '</table>' . "\n"; + + return $output; + } + + /** + * returns InnoDB status + * + * @return string result of SHOW ENGINE INNODB STATUS inside pre tags + */ + public function getPageStatus() + { + return '<pre id="pre_innodb_status">' . "\n" + . htmlspecialchars((string) $GLOBALS['dbi']->fetchValue( + 'SHOW ENGINE INNODB STATUS;', + 0, + 'Status' + )) . "\n" . '</pre>' . "\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 the InnoDB file format + */ + public function getInnodbFileFormat() + { + return $GLOBALS['dbi']->fetchValue( + "SHOW GLOBAL VARIABLES LIKE 'innodb_file_format';", + 0, + 1 + ); + } + + /** + * Verifies if this server supports the innodb_file_per_table feature + * + * (do not confuse this with phpMyAdmin's storage engine plugins!) + * + * @return boolean whether this feature is supported or not + */ + public function supportsFilePerTable() + { + return ( + $GLOBALS['dbi']->fetchValue( + "SHOW GLOBAL VARIABLES LIKE 'innodb_file_per_table';", + 0, + 1 + ) == 'ON' + ); + } +} diff --git a/srcs/phpmyadmin/libraries/classes/Engines/Memory.php b/srcs/phpmyadmin/libraries/classes/Engines/Memory.php new file mode 100644 index 0000000..d01a63e --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/Memory.php @@ -0,0 +1,34 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The MEMORY (HEAP) storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +use PhpMyAdmin\StorageEngine; + +/** + * The MEMORY (HEAP) storage engine + * + * @package PhpMyAdmin-Engines + */ +class Memory extends StorageEngine +{ + /** + * Returns array with variable names dedicated to MEMORY storage engine + * + * @return array variable names + */ + public function getVariables() + { + return [ + 'max_heap_table_size' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + ]; + } +} diff --git a/srcs/phpmyadmin/libraries/classes/Engines/Merge.php b/srcs/phpmyadmin/libraries/classes/Engines/Merge.php new file mode 100644 index 0000000..c4bee94 --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/Merge.php @@ -0,0 +1,21 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The MERGE storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +use PhpMyAdmin\StorageEngine; + +/** + * The MERGE storage engine + * + * @package PhpMyAdmin-Engines + */ +class Merge extends StorageEngine +{ +} diff --git a/srcs/phpmyadmin/libraries/classes/Engines/MrgMyisam.php b/srcs/phpmyadmin/libraries/classes/Engines/MrgMyisam.php new file mode 100644 index 0000000..cebc40f --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/MrgMyisam.php @@ -0,0 +1,29 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The MERGE storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +/** + * The MERGE storage engine + * + * @package PhpMyAdmin-Engines + */ +class MrgMyisam extends Merge +{ + /** + * returns string with filename for the MySQL helppage + * about this storage engine + * + * @return string mysql helppage filename + */ + public function getMysqlHelpPage() + { + return 'merge-storage-engine'; + } +} diff --git a/srcs/phpmyadmin/libraries/classes/Engines/Myisam.php b/srcs/phpmyadmin/libraries/classes/Engines/Myisam.php new file mode 100644 index 0000000..c37646b --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/Myisam.php @@ -0,0 +1,88 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The MyISAM storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +use PhpMyAdmin\StorageEngine; + +/** + * The MyISAM storage engine + * + * @package PhpMyAdmin-Engines + */ +class Myisam extends StorageEngine +{ + /** + * Returns array with variable names dedicated to MyISAM storage engine + * + * @return array variable names + */ + public function getVariables() + { + return [ + 'myisam_data_pointer_size' => [ + 'title' => __('Data pointer size'), + 'desc' => __( + 'The default pointer size in bytes, to be used by CREATE TABLE ' + . 'for MyISAM tables when no MAX_ROWS option is specified.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'myisam_recover_options' => [ + 'title' => __('Automatic recovery mode'), + 'desc' => __( + 'The mode for automatic recovery of crashed MyISAM tables, as ' + . 'set via the --myisam-recover server startup option.' + ), + ], + 'myisam_max_sort_file_size' => [ + 'title' => __('Maximum size for temporary sort files'), + 'desc' => __( + 'The maximum size of the temporary file MySQL is allowed to use ' + . 'while re-creating a MyISAM index (during REPAIR TABLE, ALTER ' + . 'TABLE, or LOAD DATA INFILE).' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'myisam_max_extra_sort_file_size' => [ + 'title' => __('Maximum size for temporary files on index creation'), + 'desc' => __( + 'If the temporary file used for fast MyISAM index creation ' + . 'would be larger than using the key cache by the amount ' + . 'specified here, prefer the key cache method.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'myisam_repair_threads' => [ + 'title' => __('Repair threads'), + 'desc' => __( + 'If this value is greater than 1, MyISAM table indexes are ' + . 'created in parallel (each index in its own thread) during ' + . 'the repair by sorting process.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'myisam_sort_buffer_size' => [ + 'title' => __('Sort buffer size'), + 'desc' => __( + 'The buffer that is allocated when sorting MyISAM indexes ' + . 'during a REPAIR TABLE or when creating indexes with CREATE ' + . 'INDEX or ALTER TABLE.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'myisam_stats_method' => [], + 'delay_key_write' => [], + 'bulk_insert_buffer_size' => [ + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'skip_external_locking' => [], + ]; + } +} diff --git a/srcs/phpmyadmin/libraries/classes/Engines/Ndbcluster.php b/srcs/phpmyadmin/libraries/classes/Engines/Ndbcluster.php new file mode 100644 index 0000000..bd331bf --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/Ndbcluster.php @@ -0,0 +1,54 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The NDBCLUSTER storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +use PhpMyAdmin\StorageEngine; + +/** + * The NDBCLUSTER storage engine + * + * @package PhpMyAdmin-Engines + */ +class Ndbcluster extends StorageEngine +{ + /** + * Returns array with variable names related to NDBCLUSTER storage engine + * + * @return array variable names + */ + public function getVariables() + { + return [ + 'ndb_connectstring' => [], + ]; + } + + /** + * Returns the pattern to be used in the query for SQL variables + * related to NDBCLUSTER storage engine + * + * @return string SQL query LIKE pattern + */ + public function getVariablesLikePattern() + { + return 'ndb\\_%'; + } + + /** + * Returns string with filename for the MySQL help page + * about this storage engine + * + * @return string mysql helppage filename + */ + public function getMysqlHelpPage() + { + return 'ndbcluster'; + } +} diff --git a/srcs/phpmyadmin/libraries/classes/Engines/Pbxt.php b/srcs/phpmyadmin/libraries/classes/Engines/Pbxt.php new file mode 100644 index 0000000..9aa101a --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/Pbxt.php @@ -0,0 +1,195 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The PBXT storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +use PhpMyAdmin\Core; +use PhpMyAdmin\StorageEngine; +use PhpMyAdmin\Util; + +/** + * The PBXT storage engine + * + * @package PhpMyAdmin-Engines + */ +class Pbxt extends StorageEngine +{ + /** + * Returns array with variable names dedicated to PBXT storage engine + * + * @return array variable names + */ + public function getVariables() + { + return [ + 'pbxt_index_cache_size' => [ + 'title' => __('Index cache size'), + 'desc' => __( + 'This is the amount of memory allocated to the' + . ' index cache. Default value is 32MB. The memory' + . ' allocated here is used only for caching index pages.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'pbxt_record_cache_size' => [ + 'title' => __('Record cache size'), + 'desc' => __( + 'This is the amount of memory allocated to the' + . ' record cache used to cache table data. The default' + . ' value is 32MB. This memory is used to cache changes to' + . ' the handle data (.xtd) and row pointer (.xtr) files.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'pbxt_log_cache_size' => [ + 'title' => __('Log cache size'), + 'desc' => __( + 'The amount of memory allocated to the' + . ' transaction log cache used to cache on transaction log' + . ' data. The default is 16MB.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'pbxt_log_file_threshold' => [ + 'title' => __('Log file threshold'), + 'desc' => __( + 'The size of a transaction log before rollover,' + . ' and a new log is created. The default value is 16MB.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'pbxt_transaction_buffer_size' => [ + 'title' => __('Transaction buffer size'), + 'desc' => __( + 'The size of the global transaction log buffer' + . ' (the engine allocates 2 buffers of this size).' + . ' The default is 1MB.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'pbxt_checkpoint_frequency' => [ + 'title' => __('Checkpoint frequency'), + 'desc' => __( + 'The amount of data written to the transaction' + . ' log before a checkpoint is performed.' + . ' The default value is 24MB.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'pbxt_data_log_threshold' => [ + 'title' => __('Data log threshold'), + 'desc' => __( + 'The maximum size of a data log file. The default' + . ' value is 64MB. PBXT can create a maximum of 32000 data' + . ' logs, which are used by all tables. So the value of' + . ' this variable can be increased to increase the total' + . ' amount of data that can be stored in the database.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'pbxt_garbage_threshold' => [ + 'title' => __('Garbage threshold'), + 'desc' => __( + 'The percentage of garbage in a data log file' + . ' before it is compacted. This is a value between 1 and' + . ' 99. The default is 50.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + 'pbxt_log_buffer_size' => [ + 'title' => __('Log buffer size'), + 'desc' => __( + 'The size of the buffer used when writing a data' + . ' log. The default is 256MB. The engine allocates one' + . ' buffer per thread, but only if the thread is required' + . ' to write a data log.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'pbxt_data_file_grow_size' => [ + 'title' => __('Data file grow size'), + 'desc' => __('The grow size of the handle data (.xtd) files.'), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'pbxt_row_file_grow_size' => [ + 'title' => __('Row file grow size'), + 'desc' => __('The grow size of the row pointer (.xtr) files.'), + 'type' => PMA_ENGINE_DETAILS_TYPE_SIZE, + ], + 'pbxt_log_file_count' => [ + 'title' => __('Log file count'), + 'desc' => __( + 'This is the number of transaction log files' + . ' (pbxt/system/xlog*.xt) the system will maintain. If the' + . ' number of logs exceeds this value then old logs will be' + . ' deleted, otherwise they are renamed and given the next' + . ' highest number.' + ), + 'type' => PMA_ENGINE_DETAILS_TYPE_NUMERIC, + ], + ]; + } + + /** + * returns the pbxt engine specific handling for + * PMA_ENGINE_DETAILS_TYPE_SIZE variables. + * + * @param string $formatted_size the size expression (for example 8MB) + * + * @return array the formatted value and its unit + */ + public function resolveTypeSize($formatted_size) + { + if (preg_match('/^[0-9]+[a-zA-Z]+$/', $formatted_size)) { + $value = Util::extractValueFromFormattedSize( + $formatted_size + ); + } else { + $value = $formatted_size; + } + + return Util::formatByteDown($value); + } + + //-------------------- + /** + * Get information about pages + * + * @return array Information about pages + */ + public function getInfoPages() + { + $pages = []; + $pages['Documentation'] = __('Documentation'); + + return $pages; + } + + //-------------------- + /** + * Get content of documentation page + * + * @return string + */ + public function getPageDocumentation() + { + $output = '<p>' . sprintf( + __( + 'Documentation and further information about PBXT' + . ' can be found on the %sPrimeBase XT Home Page%s.' + ), + '<a href="' . Core::linkURL('https://mariadb.com/kb/en/mariadb/about-pbxt/') + . '" rel="noopener noreferrer" target="_blank">', + '</a>' + ) + . '</p>' . "\n"; + + return $output; + } +} diff --git a/srcs/phpmyadmin/libraries/classes/Engines/PerformanceSchema.php b/srcs/phpmyadmin/libraries/classes/Engines/PerformanceSchema.php new file mode 100644 index 0000000..01669b4 --- /dev/null +++ b/srcs/phpmyadmin/libraries/classes/Engines/PerformanceSchema.php @@ -0,0 +1,31 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * The performance schema storage engine + * + * @package PhpMyAdmin-Engines + */ +declare(strict_types=1); + +namespace PhpMyAdmin\Engines; + +use PhpMyAdmin\StorageEngine; + +/** + * The performance schema storage engine + * + * @package PhpMyAdmin-Engines + */ +class PerformanceSchema extends StorageEngine +{ + /** + * Returns string with filename for the MySQL helppage + * about this storage engine + * + * @return string mysql helppage filename + */ + public function getMysqlHelpPage() + { + return 'performance-schema'; + } +} |