FM / queries

/usr/share/phpmyadmin/templates/server/status/queries/

/usr/share/phpmyadmin/templates/server/status/queries

Name	Size	Mode	Actions
index.twig	2007	0644	edit dl rm

Edit: /usr/share/phpmyadmin/templates/server/status/queries/index.twig (2007B)

{% 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>

<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 %}

{% extends 'server/status/base.twig' %} {% set active = 'queries' %} {% block content %} {% if is_data_loaded %}

{% 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') }}

ø {% trans 'per hour:' %} {{ format_number(stats.per_hour, 0) }}
ø {% trans 'per minute:' %} {{ format_number(stats.per_minute, 0) }}
ø {% trans 'per second:' %} {{ format_number(stats.per_second, 0) }}

{% for query in queries %} {% endfor %}

{% trans 'Statements' %}	{% trans %}#{% notes %}# = Amount of queries{% endtrans %}	{% trans 'ø per hour' %}	%
{{ query.name }}	{{ format_number(query.value, 5, 0, true) }}	{{ format_number(query.per_hour, 4, 1, true) }}	{{ format_number(query.percentage, 0, 2) }}

{% else %} {{ 'Not enough privilege to view query statistics.'|trans|error }} {% endif %} {% endblock %}