You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
99 lines
4.1 KiB
99 lines
4.1 KiB
{% 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 %}
|
|
|