Server : Apache/2.4.52 (Ubuntu) System : Linux webserver 6.8.0-49-generic #49~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Wed Nov 6 17:42:15 UTC 2 x86_64 User : www-data ( 33) PHP Version : 8.1.2-1ubuntu2.21 Disable Function : NONE Directory : /var/lib/phpmyadmin/tmp/twig/95/ |
<?php
use Twig\Environment;
use Twig\Error\LoaderError;
use Twig\Error\RuntimeError;
use Twig\Extension\SandboxExtension;
use Twig\Markup;
use Twig\Sandbox\SecurityError;
use Twig\Sandbox\SecurityNotAllowedTagError;
use Twig\Sandbox\SecurityNotAllowedFilterError;
use Twig\Sandbox\SecurityNotAllowedFunctionError;
use Twig\Source;
use Twig\Template;
/* server/status/monitor/index.twig */
class __TwigTemplate_9d036b06b4e645a7468beabbdf99171a extends Template
{
private $source;
private $macros = [];
public function __construct(Environment $env)
{
parent::__construct($env);
$this->source = $this->getSourceContext();
$this->blocks = [
'content' => [$this, 'block_content'],
];
}
protected function doGetParent(array $context)
{
// line 1
return "server/status/base.twig";
}
protected function doDisplay(array $context, array $blocks = [])
{
$macros = $this->macros;
// line 2
$context["active"] = "monitor";
// line 1
$this->parent = $this->loadTemplate("server/status/base.twig", "server/status/monitor/index.twig", 1);
$this->parent->display($context, array_merge($this->blocks, $blocks));
}
// line 3
public function block_content($context, array $blocks = [])
{
$macros = $this->macros;
// line 4
echo "
<div class=\"tabLinks row\">
<a href=\"#pauseCharts\">
";
// line 7
echo \PhpMyAdmin\Html\Generator::getImage("play");
echo "
";
// line 8
echo _gettext("Start Monitor");
// line 9
echo " </a>
<a href=\"#settingsPopup\" class=\"popupLink\">
";
// line 11
echo \PhpMyAdmin\Html\Generator::getImage("s_cog");
echo "
";
// line 12
echo _gettext("Settings");
// line 13
echo " </a>
<a href=\"#monitorInstructionsDialog\">
";
// line 15
echo \PhpMyAdmin\Html\Generator::getImage("b_help");
echo "
";
// line 16
echo _gettext("Instructions/Setup");
// line 17
echo " </a>
<a href=\"#endChartEditMode\" class=\"hide\">
";
// line 19
echo \PhpMyAdmin\Html\Generator::getImage("s_okay");
echo "
";
// line 20
echo _gettext("Done dragging (rearranging) charts");
// line 21
echo " </a>
</div>
<div class=\"popupContent settingsPopup\">
<a href=\"#addNewChart\">
";
// line 26
echo \PhpMyAdmin\Html\Generator::getImage("b_chart");
echo "
";
// line 27
echo _gettext("Add chart");
// line 28
echo " </a>
<a href=\"#rearrangeCharts\">
";
// line 30
echo \PhpMyAdmin\Html\Generator::getImage("b_tblops");
echo "
";
// line 31
echo _gettext("Enable charts dragging");
// line 32
echo " </a>
<div class=\"clearfloat paddingtop\"></div>
<div class=\"floatleft\">
";
// line 36
echo _gettext("Refresh rate");
// line 37
echo " <br>
<select id=\"id_gridChartRefresh\" class=\"refreshRate\" name=\"gridChartRefresh\">
";
// line 39
$context['_parent'] = $context;
$context['_seq'] = twig_ensure_traversable([0 => 2, 1 => 3, 2 => 4, 3 => 5, 4 => 10, 5 => 20, 6 => 40, 7 => 60, 8 => 120, 9 => 300, 10 => 600, 11 => 1200]);
foreach ($context['_seq'] as $context["_key"] => $context["rate"]) {
// line 40
echo " <option value=\"";
echo twig_escape_filter($this->env, $context["rate"], "html", null, true);
echo "\"";
echo ((($context["rate"] == 5)) ? (" selected") : (""));
echo ">
";
// line 41
if (($context["rate"] < 60)) {
// line 42
echo " ";
if (($context["rate"] == 1)) {
// line 43
echo " ";
echo twig_escape_filter($this->env, twig_sprintf(_gettext("%d second"), $context["rate"]), "html", null, true);
echo "
";
} else {
// line 45
echo " ";
echo twig_escape_filter($this->env, twig_sprintf(_gettext("%d seconds"), $context["rate"]), "html", null, true);
echo "
";
}
// line 47
echo " ";
} else {
// line 48
echo " ";
if ((($context["rate"] / 60) == 1)) {
// line 49
echo " ";
echo twig_escape_filter($this->env, twig_sprintf(_gettext("%d minute"), ($context["rate"] / 60)), "html", null, true);
echo "
";
} else {
// line 51
echo " ";
echo twig_escape_filter($this->env, twig_sprintf(_gettext("%d minutes"), ($context["rate"] / 60)), "html", null, true);
echo "
";
}
// line 53
echo " ";
}
// line 54
echo " </option>
";
}
$_parent = $context['_parent'];
unset($context['_seq'], $context['_iterated'], $context['_key'], $context['rate'], $context['_parent'], $context['loop']);
$context = array_intersect_key($context, $_parent) + $_parent;
// line 56
echo " </select>
<br>
</div>
<div class=\"floatleft\">
";
// line 61
echo _gettext("Chart columns");
// line 62
echo " <br>
<select name=\"chartColumns\">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
</select>
</div>
<div class=\"clearfloat paddingtop\">
<strong>";
// line 74
echo _gettext("Chart arrangement");
echo "</strong>
";
// line 75
echo \PhpMyAdmin\Html\Generator::showHint(_gettext("The arrangement of the charts is stored to the browsers local storage. You may want to export it if you have a complicated set up."));
echo "
<br>
<a class=\"ajax\" href=\"#importMonitorConfig\">
";
// line 78
echo _gettext("Import");
// line 79
echo " </a> -
<a class=\"disableAjax\" href=\"#exportMonitorConfig\">
";
// line 81
echo _gettext("Export");
// line 82
echo " </a> -
<a href=\"#clearMonitorConfig\">
";
// line 84
echo _gettext("Reset to default");
// line 85
echo " </a>
</div>
</div>
<div id=\"monitorInstructionsDialog\" title=\"";
// line 89
echo _gettext("Monitor Instructions");
echo "\" class=\"hide\">
<p>
";
// line 91
echo _gettext("The phpMyAdmin Monitor can assist you in optimizing the server configuration and track down time intensive queries. For the latter you will need to set log_output to 'TABLE' and have either the slow_query_log or general_log enabled. Note however, that the general_log produces a lot of data and increases server load by up to 15%.");
// line 94
echo " </p>
<img class=\"ajaxIcon\" src=\"";
// line 95
echo twig_escape_filter($this->env, ($context["image_path"] ?? null), "html", null, true);
echo "ajax_clock_small.gif\" alt=\"";
echo _gettext("Loading…");
echo "\">
<div class=\"ajaxContent\"></div>
<br>
<div class=\"monitorUse hide\">
<p><strong>";
// line 101
echo _gettext("Using the monitor:");
echo "</strong></p>
<p>
";
// line 103
echo _gettext("Your browser will refresh all displayed charts in a regular interval. You may add charts and change the refresh rate under 'Settings', or remove any chart using the cog icon on each respective chart.");
// line 106
echo " </p>
<p>
";
// line 108
echo _gettext("To display queries from the logs, select the relevant time span on any chart by holding down the left mouse button and panning over the chart. Once confirmed, this will load a table of grouped queries, there you may click on any occurring SELECT statements to further analyze them.");
// line 111
echo " </p>
<p>
";
// line 113
echo \PhpMyAdmin\Html\Generator::getImage("s_attention");
echo "
<strong>";
// line 114
echo _gettext("Please note:");
echo "</strong>
</p>
<p>
";
// line 117
echo _gettext("Enabling the general_log may increase the server load by 5-15%. Also be aware that generating statistics from the logs is a load intensive task, so it is advisable to select only a small time span and to disable the general_log and empty its table once monitoring is not required any more.");
// line 120
echo " </p>
</div>
</div>
<div id=\"addChartDialog\" title=\"";
// line 124
echo _gettext("Add chart");
echo "\" class=\"hide\">
<div id=\"tabGridVariables\">
<p>
<input type=\"text\" name=\"chartTitle\" value=\"";
// line 127
echo _gettext("Chart Title");
echo "\">
</p>
<input type=\"radio\" name=\"chartType\" value=\"preset\" id=\"chartPreset\">
<label for=\"chartPreset\">";
// line 131
echo _gettext("Preset chart");
echo "</label>
<select name=\"presetCharts\"></select>
<br>
<input type=\"radio\" name=\"chartType\" value=\"variable\" id=\"chartStatusVar\" checked=\"checked\">
<label for=\"chartStatusVar\">
";
// line 137
echo _gettext("Status variable(s)");
// line 138
echo " </label>
<br>
<div id=\"chartVariableSettings\">
<label for=\"chartSeries\">";
// line 142
echo _gettext("Select series:");
echo "</label>
<br>
<select id=\"chartSeries\" name=\"varChartList\" size=\"1\">
<option>";
// line 145
echo _gettext("Commonly monitored");
echo "</option>
<option>Processes</option>
<option>Questions</option>
<option>Connections</option>
<option>Bytes_sent</option>
<option>Bytes_received</option>
<option>Threads_connected</option>
<option>Created_tmp_disk_tables</option>
<option>Handler_read_first</option>
<option>Innodb_buffer_pool_wait_free</option>
<option>Key_reads</option>
<option>Open_tables</option>
<option>Select_full_join</option>
<option>Slow_queries</option>
</select>
<br>
<label for=\"variableInput\">
";
// line 163
echo _gettext("or type variable name:");
// line 164
echo " </label>
<input type=\"text\" name=\"variableInput\" id=\"variableInput\">
<br>
<input type=\"checkbox\" name=\"differentialValue\" id=\"differentialValue\" value=\"differential\" checked=\"checked\">
<label for=\"differentialValue\">
";
// line 170
echo _gettext("Display as differential value");
// line 171
echo " </label>
<br>
<input type=\"checkbox\" id=\"useDivisor\" name=\"useDivisor\" value=\"1\">
<label for=\"useDivisor\">";
// line 175
echo _gettext("Apply a divisor");
echo "</label>
<span class=\"divisorInput hide\">
<input type=\"text\" name=\"valueDivisor\" size=\"4\" value=\"1\">
(<a href=\"#kibDivisor\">";
// line 179
echo _gettext("KiB");
echo "</a>,
<a href=\"#mibDivisor\">";
// line 180
echo _gettext("MiB");
echo "</a>)
</span>
<br>
<input type=\"checkbox\" id=\"useUnit\" name=\"useUnit\" value=\"1\">
<label for=\"useUnit\">
";
// line 186
echo _gettext("Append unit to data values");
// line 187
echo " </label>
<span class=\"unitInput hide\">
<input type=\"text\" name=\"valueUnit\" size=\"4\" value=\"\">
</span>
<p>
<a href=\"#submitAddSeries\">
<strong>";
// line 194
echo _gettext("Add this series");
echo "</strong>
</a>
<span id=\"clearSeriesLink\" class=\"hide\">
| <a href=\"#submitClearSeries\">";
// line 197
echo _gettext("Clear series");
echo "</a>
</span>
</p>
";
// line 201
echo _gettext("Series in chart:");
// line 202
echo " <br>
<span id=\"seriesPreview\">
<em>";
// line 204
echo _gettext("None");
echo "</em>
</span>
</div>
</div>
</div>
<div id=\"logAnalyseDialog\" title=\"";
// line 210
echo _gettext("Log statistics");
echo "\" class=\"hide\">
<p>
";
// line 212
echo _gettext("Selected time range:");
// line 213
echo " <input type=\"text\" name=\"dateStart\" class=\"datetimefield\" value=\"\">
-
<input type=\"text\" name=\"dateEnd\" class=\"datetimefield\" value=\"\">
</p>
<input type=\"checkbox\" id=\"limitTypes\" value=\"1\" checked=\"checked\">
<label for=\"limitTypes\">
";
// line 220
echo _gettext("Only retrieve SELECT,INSERT,UPDATE and DELETE Statements");
// line 221
echo " </label>
<br>
<input type=\"checkbox\" id=\"removeVariables\" value=\"1\" checked=\"checked\">
<label for=\"removeVariables\">
";
// line 226
echo _gettext("Remove variable data in INSERT statements for better grouping");
// line 227
echo " </label>
<p>
";
// line 230
echo _gettext("Choose from which log you want the statistics to be generated from.");
// line 231
echo " </p>
<p>
";
// line 233
echo _gettext("Results are grouped by query text.");
// line 234
echo " </p>
</div>
<div id=\"queryAnalyzerDialog\" title=\"";
// line 237
echo _gettext("Query analyzer");
echo "\" class=\"hide\">
<textarea id=\"sqlquery\"></textarea>
<br>
<div class=\"placeHolder\"></div>
</div>
<div class=\"clearfloat\"></div>
<div class=\"row\"><table class=\"pma-table clearfloat tdblock\" id=\"chartGrid\"></table></div>
<div id=\"logTable\"><br></div>
<script type=\"text/javascript\">
var variableNames = [
";
// line 249
$context['_parent'] = $context;
$context['_seq'] = twig_ensure_traversable(($context["javascript_variable_names"] ?? null));
foreach ($context['_seq'] as $context["_key"] => $context["variable_name"]) {
// line 250
echo " \"";
echo twig_escape_filter($this->env, twig_escape_filter($this->env, $context["variable_name"], "js"), "html", null, true);
echo "\",
";
}
$_parent = $context['_parent'];
unset($context['_seq'], $context['_iterated'], $context['_key'], $context['variable_name'], $context['_parent'], $context['loop']);
$context = array_intersect_key($context, $_parent) + $_parent;
// line 252
echo " ];
</script>
<form id=\"js_data\" class=\"hide\">
";
// line 256
$context['_parent'] = $context;
$context['_seq'] = twig_ensure_traversable(($context["form"] ?? null));
foreach ($context['_seq'] as $context["name"] => $context["value"]) {
// line 257
echo " <input type=\"hidden\" name=\"";
echo twig_escape_filter($this->env, $context["name"], "html", null, true);
echo "\" value=\"";
echo twig_escape_filter($this->env, $context["value"], "html", null, true);
echo "\">
";
}
$_parent = $context['_parent'];
unset($context['_seq'], $context['_iterated'], $context['name'], $context['value'], $context['_parent'], $context['loop']);
$context = array_intersect_key($context, $_parent) + $_parent;
// line 259
echo "</form>
<div id=\"profiling_docu\" class=\"hide\">
";
// line 262
echo \PhpMyAdmin\Html\MySQLDocumentation::show("general-thread-states");
echo "
</div>
<div id=\"explain_docu\" class=\"hide\">
";
// line 266
echo \PhpMyAdmin\Html\MySQLDocumentation::show("explain-output");
echo "
</div>
";
}
public function getTemplateName()
{
return "server/status/monitor/index.twig";
}
public function isTraitable()
{
return false;
}
public function getDebugInfo()
{
return array ( 534 => 266, 527 => 262, 522 => 259, 511 => 257, 507 => 256, 501 => 252, 492 => 250, 488 => 249, 473 => 237, 468 => 234, 466 => 233, 462 => 231, 460 => 230, 455 => 227, 453 => 226, 446 => 221, 444 => 220, 435 => 213, 433 => 212, 428 => 210, 419 => 204, 415 => 202, 413 => 201, 406 => 197, 400 => 194, 391 => 187, 389 => 186, 380 => 180, 376 => 179, 369 => 175, 363 => 171, 361 => 170, 353 => 164, 351 => 163, 330 => 145, 324 => 142, 318 => 138, 316 => 137, 307 => 131, 300 => 127, 294 => 124, 288 => 120, 286 => 117, 280 => 114, 276 => 113, 272 => 111, 270 => 108, 266 => 106, 264 => 103, 259 => 101, 248 => 95, 245 => 94, 243 => 91, 238 => 89, 232 => 85, 230 => 84, 226 => 82, 224 => 81, 220 => 79, 218 => 78, 212 => 75, 208 => 74, 194 => 62, 192 => 61, 185 => 56, 178 => 54, 175 => 53, 169 => 51, 163 => 49, 160 => 48, 157 => 47, 151 => 45, 145 => 43, 142 => 42, 140 => 41, 133 => 40, 129 => 39, 125 => 37, 123 => 36, 117 => 32, 115 => 31, 111 => 30, 107 => 28, 105 => 27, 101 => 26, 94 => 21, 92 => 20, 88 => 19, 84 => 17, 82 => 16, 78 => 15, 74 => 13, 72 => 12, 68 => 11, 64 => 9, 62 => 8, 58 => 7, 53 => 4, 49 => 3, 44 => 1, 42 => 2, 35 => 1,);
}
public function getSourceContext()
{
return new Source("", "server/status/monitor/index.twig", "/usr/share/phpmyadmin/templates/server/status/monitor/index.twig");
}
}