'; $output .= '

'; $output .= __( 'The Advisor system can provide recommendations ' . 'on server variables by analyzing the server status variables.' ); $output .= '

'; $output .= '

'; $output .= __( 'Do note however that this system provides recommendations ' . 'based on simple calculations and by rule of thumb which may ' . 'not necessarily apply to your system.' ); $output .= '

'; $output .= '

'; $output .= __( 'Prior to changing any of the configuration, be sure to know ' . 'what you are changing (by reading the documentation) and how ' . 'to undo the change. Wrong tuning can have a very negative ' . 'effect on performance.' ); $output .= '

'; $output .= '

'; $output .= __( 'The best way to tune your system would be to change only one ' . 'setting at a time, observe or benchmark your database, and undo ' . 'the change if there was no clearly measurable improvement.' ); $output .= '

'; $output .= '

'; $advisor = new PmaAdvisor($GLOBALS['dbi'], new ExpressionLanguage()); $output .= htmlspecialchars( json_encode( $advisor->run() ) ); $output .= '