libraries/server_status_advisor.lib.php

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