phpmyadmin/libraries/server_status_advisor.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3
   4 /**
   5  * functions for displaying server status sub item: advisor
   6  *
   7  * @usedby  server_status_advisor.php
   8  *
   9  * @package PhpMyAdmin
  10  */
  11 if (! defined('PHPMYADMIN')) {
  12     exit;
  13 }
  14
  15 /**
  16  * Returns html with Advisor
  17  *
  18  * @return string
  19  */
  20 function PMA_getHtmlForAdvisor()
  21 {
  22     $output  = '<a href="#openAdvisorInstructions">';
  23     $output .= PMA_Util::getIcon('b_help.png', __('Instructions'));
  24     $output .= '</a>';
  25     $output .= '<div id="statustabs_advisor"></div>';
  26     $output .= '<div id="advisorInstructionsDialog" style="display:none;">';
  27     $output .= '<p>';
  28     $output .= __(
  29         'The Advisor system can provide recommendations '
  30         . 'on server variables by analyzing the server status variables.'
  31     );
  32     $output .= '</p>';
  33     $output .= '<p>';
  34     $output .= __(
  35         'Do note however that this system provides recommendations '
  36         . 'based on simple calculations and by rule of thumb which may '
  37         . 'not necessarily apply to your system.'
  38     );
  39     $output .= '</p>';
  40     $output .= '<p>';
  41     $output .= __(
  42         'Prior to changing any of the configuration, be sure to know '
  43         . 'what you are changing (by reading the documentation) and how '
  44         . 'to undo the change. Wrong tuning can have a very negative '
  45         . 'effect on performance.'
  46     );
  47     $output .= '</p>';
  48     $output .= '<p>';
  49     $output .= __(
  50         'The best way to tune your system would be to change only one '
  51         . 'setting at a time, observe or benchmark your database, and undo '
  52         . 'the change if there was no clearly measurable improvement.'
  53     );
  54     $output .= '</p>';
  55     $output .= '</div>';
  56     $output .= '<div id="advisorData" style="display:none;">';
  57     $advisor = new Advisor();
  58     $output .= htmlspecialchars(
  59         json_encode(
  60             $advisor->run()
  61         )
  62     );
  63     $output .= '</div>';
  64
  65     return $output;
  66 }
  67