Initial commit of intern.ccwn.org contentsHEADmaster

1 files changed, 74 insertions, 0 deletions

diff --git a/hugo/server_status_advisor.php b/hugo/server_status_advisor.php
new file mode 100644
index 0000000..e17bf0f
--- /dev/null
+++ b/hugo/server_status_advisor.php
@@ -0,0 +1,74 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * displays the advisor feature
+ *
+ * @package PhpMyAdmin
+ */
+
+require_once 'libraries/common.inc.php';
+require_once 'libraries/Advisor.class.php';
+require_once 'libraries/ServerStatusData.class.php';
+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';
+}
+
+$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);
+
+?>