{% extends 'server/status/base.twig' %}
{% set active = 'advisor' %}
{% block content %}
<h2>{% trans 'Advisor system' %}</h2>
{% if data is empty %}
{{ 'Not enough privilege to view the advisor.'|trans|error }}
{% else %}
<button type="button" class="btn btn-secondary mb-4" data-bs-toggle="modal" data-bs-target="#advisorInstructionsModal">
{{ get_icon('b_help', 'Instructions'|trans) }}
</button>
<div class="modal fade" id="advisorInstructionsModal" tabindex="-1" role="dialog" aria-labelledby="advisorInstructionsModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="advisorInstructionsModalLabel">{% trans 'Advisor system' %}</h5>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="{% trans 'Close' %}"></button>
</div>
<div class="modal-body">
<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 class="modal-footer">
<button type="button" class="btn btn-primary" data-bs-dismiss="modal">{% trans 'Close' %}</button>
</div>
</div>
</div>
</div>
{% if data.errors|length > 0 %}
<div class="alert alert-danger mt-2 mb-2" role="alert">
<h4 class="alert-heading">{% trans 'Errors occurred while executing rule expressions:' %}</h4>
<ul>
{% for error in data.errors %}
<li>{{ error }}</li>
{% endfor %}
</ul>
</div>
{% endif %}
{% if data.fired|length > 0 %}
<h4>{% trans 'Possible performance issues' %}</h4>
<div class="accordion mb-4" id="rulesAccordion">
{% for rule in data.fired %}
<div class="accordion-item">
<div class="accordion-header" id="heading{{ loop.index }}">
<button class="accordion-button{{ not loop.first ? ' collapsed' }}" type="button" data-bs-toggle="collapse" data-bs-target="#collapse{{ loop.index }}" aria-expanded="{{ loop.first ? 'true' : 'false' }}" aria-controls="collapse{{ loop.index }}">
{{ rule.issue|striptags }}
</button>
</div>
<div id="collapse{{ loop.index }}" class="accordion-collapse collapse{{ loop.first ? ' show' }}" aria-labelledby="heading{{ loop.index }}" data-bs-parent="#rulesAccordion">
<div class="accordion-body">
<dl>
<dt>{% trans 'Issue:' %}</dt>
<dd>{{ rule.issue|raw }}</dd>
<dt>{% trans 'Recommendation:' %}</dt>
<dd>{{ rule.recommendation|raw }}</dd>
<dt>{% trans 'Justification:' %}</dt>
<dd>{{ rule.justification }}</dd>
<dt>{% trans 'Used variable / formula:' %}</dt>
<dd>{{ rule.formula }}</dd>
<dt>{% trans 'Test:' %}</dt>
<dd>{{ rule.test }}</dd>
</dl>
</div>
</div>
</div>
{% endfor %}
</div>
{% endif %}
{% endif %}
{% endblock %}