Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /proc/self/root/usr/share/phpMyAdmin/templates/server/status/queries/ |
{% extends 'server/status/base.twig' %}
{% set active = 'queries' %}
{% block content %}
{% if is_data_loaded %}
<div class="row">
<h3 id="serverstatusqueries">
{% trans %}
Questions since startup:
{% notes %}
Questions is the name of a MySQL Status variable
{% endtrans %}
{{ format_number(stats.total, 0) }}
{{ show_mysql_docu('server-status-variables', false, null, null, 'statvar_Questions') }}
</h3>
</div>
<div class="row">
<ul>
<li>ø {% trans 'per hour:' %} {{ format_number(stats.per_hour, 0) }}</li>
<li>ø {% trans 'per minute:' %} {{ format_number(stats.per_minute, 0) }}</li>
{% if stats.per_second >= 1 %}
<li>ø {% trans 'per second:' %} {{ format_number(stats.per_second, 0) }}</li>
{% endif %}
</ul>
</div>
<div class="row">
<table id="serverStatusQueriesDetails" class="table table-light table-striped table-hover sortable col-md-4 col-12">
<colgroup>
<col class="namecol">
<col class="valuecol" span="3">
</colgroup>
<thead class="thead-light">
<tr>
<th scope="col">{% trans 'Statements' %}</th>
<th scope="col">{% trans %}#{% notes %}# = Amount of queries{% endtrans %}</th>
<th scope="col">{% trans 'ø per hour' %}</th>
<th scope="col">%</th>
</tr>
</thead>
<tbody>
{% for query in queries %}
<tr>
<th scope="row">{{ query.name }}</th>
<td class="text-monospace text-right">{{ format_number(query.value, 5, 0, true) }}</td>
<td class="text-monospace text-right">{{ format_number(query.per_hour, 4, 1, true) }}</td>
<td class="text-monospace text-right">{{ format_number(query.percentage, 0, 2) }}</td>
</tr>
{% endfor %}
</tbody>
</table>
<div id="serverstatusquerieschart" class="w-100 col-12 col-md-6" data-chart="{{ chart|json_encode }}"></div>
</div>
{% else %}
{{ 'Not enough privilege to view query statistics.'|trans|error }}
{% endif %}
{% endblock %}