> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries.md).

# Statistics for Optimizing Queries

{% columns %}
{% column %}
{% content-ref url="/pages/oqGUGl2yP1SqrLMVKYlW" %}
[Engine-Independent Table Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/engine-independent-table-statistics.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Engine-independent table statistics store optimizer statistics in mysql database tables, collected via ANALYZE TABLE and controlled by the use\_stat\_tables variable.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Pda96aUffb0qmQWAv40r" %}
[Histogram-Based Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/histogram-based-statistics.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Histogram-based statistics give the optimizer value-distribution data for indexed and non-indexed columns, improving query plans through better selectivity estimates.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/zenMJwvog8lhxfzu75Os" %}
[InnoDB Persistent Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/innodb-persistent-statistics.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
InnoDB persistent statistics store index and table statistics on disk so they survive server restarts, controlled by innodb\_stats\_persistent and related variables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/mQYm4REHJO5TZGBoq9Za" %}
[Slow Query Log Extended Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/slow-query-log-extended-statistics.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Extends the slow query log with query-plan, EXPLAIN, and storage-engine statistics, controlled by log\_slow\_verbosity, log\_slow\_filter, and log\_slow\_rate\_limit.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/6XheIeTYX5ucJ7jMEcT1" %}
[User Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/user-statistics.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The userstat plugin adds USER, CLIENT, INDEX, and TABLE statistics as INFORMATION\_SCHEMA tables plus SHOW and FLUSH statements to track server activity and load.
{% endcolumn %}
{% endcolumns %}