NN2021040101/public/phpMyAdmin/templates/server/status/advisor/index.twig

{% extends 'server/status/base.twig' %}
{% set active = 'advisor' %}

{% block content %}

  {% if data is not empty %}
    <a href="#openAdvisorInstructions">{{ get_icon('b_help', 'Instructions'|trans) }}</a>

    <div id="statustabs_advisor"></div>

    <div id="advisorInstructionsDialog" class="hide">
      <p>
        {% trans %}
          The Advisor system can provide recommendations on server variables by analyzing the server status variables.
        {% endtrans %}
      </p>
      <p>
        {% trans %}
          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.
        {% endtrans %}
      </p>
      <p>
        {% trans %}
          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.
        {% endtrans %}
      </p>
      <p>
        {% trans %}
          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.
        {% endtrans %}
      </p>
    </div>

    <div id="advisorData" class="hide">{{ data }}</div>
  {% else %}
    {{ 'Not enough privilege to view the advisor.'|trans|error }}
  {% endif %}

{% endblock %}