diff options
| author | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
|---|---|---|
| committer | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
| commit | 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab (patch) | |
| tree | 39a1a4629749056191c05dfd899f931701b7acf3 /srcs/phpmyadmin/libraries/classes/Engines/Innodb.php | |
| parent | 5afd237bbd22028b85532b8c0b3fcead49a00764 (diff) | |
| download | ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.gz ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.bz2 ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.zip | |
Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my famillyHEADmaster
Diffstat (limited to 'srcs/phpmyadmin/libraries/classes/Engines/Innodb.php')
| -rw-r--r-- | srcs/phpmyadmin/libraries/classes/Engines/Innodb.php | 395 |
1 files changed, 0 insertions, 395 deletions
diff --git a/srcs/phpmyadmin/libraries/classes/Engines/Innodb.php b/srcs/phpmyadmin/libraries/classes/Engines/Innodb.php deleted file mode 100644 index e7e7a1f..0000000 --- a/srcs/phpmyadmin/libraries/classes/Engines/Innodb.php +++ /dev/null @@ -1,395 +0,0 @@ -<?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' - ); - } -} |
