/** * Returns html with Advisor * * @return string */ function PMA_getHtmlForAdvisor() { $output = '<a href="#openAdvisorInstructions">'; $output .= PMA_Util::getIcon('b_help.png', __('Instructions')); $output .= '</a>'; $output .= '<div id="statustabs_advisor"></div>'; $output .= '<div id="advisorInstructionsDialog" style="display:none;">'; $output .= '<p>'; $output .= __('The Advisor system can provide recommendations ' . 'on server variables by analyzing the server status variables.'); $output .= '</p>'; $output .= '<p>'; $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 .= '</p>'; $output .= '<p>'; $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 .= '</p>'; $output .= '<p>'; $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 .= '</p>'; $output .= '</div>'; $output .= '<div id="advisorData" style="display:none;">'; $advisor = new Advisor(); $output .= htmlspecialchars(json_encode($advisor->run())); $output .= '</div>'; return $output; }
$return['error'] = PMA_DBI_getError(); PMA_DBI_free_result($result); if ($profiling) { $return['profiling'] = array(); $result = PMA_DBI_try_query('SELECT seq,state,duration FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=1 ORDER BY seq'); while ($row = PMA_DBI_fetch_assoc($result)) { $return['profiling'][] = $row; } PMA_DBI_free_result($result); } exit(json_encode($return)); } if (isset($_REQUEST['advisor'])) { include 'libraries/Advisor.class.php'; $advisor = new Advisor(); exit(json_encode($advisor->run())); } } /** * Replication library */ if (PMA_DRIZZLE) { $server_master_status = false; $server_slave_status = false; } else { include_once './libraries/replication.inc.php'; include_once './libraries/replication_gui.lib.php'; } /** * JS Includes */
} $ServerStatusData = new PMA_ServerStatusData(); $response = PMA_Response::getInstance(); $scripts = $response->getHeader()->getScripts(); $scripts->addFile('server_status_advisor.js'); $output = '<div>'; $output .= $ServerStatusData->getMenuHtml(); $output .= '<a href="#openAdvisorInstructions">'; $output .= PMA_Util::getIcon('b_help.png', __('Instructions')); $output .= '</a>'; $output .= '<div id="statustabs_advisor"></div>'; $output .= '<div id="advisorInstructionsDialog" style="display:none;">'; $output .= '<p>'; $output .= __('The Advisor system can provide recommendations ' . 'on server variables by analyzing the server status variables.'); $output .= '</p>'; $output .= '<p>'; $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 .= '</p>'; $output .= '<p>'; $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 .= '</p>'; $output .= '<p>'; $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 .= '</p>'; $output .= '</div>'; $output .= '<div id="advisorData" style="display:none;">'; $advisor = new Advisor(); $output .= htmlspecialchars(json_encode($advisor->run())); $output .= '</div>'; $output .= '</div>'; $response->addHTML($output);