Statistics for Optimizing Queries

Different statistics provided by MariaDB to help you optimize your queries

Title Description
Engine-Independent Table Statistics Table statistics independent of the storage engine.
Histogram-Based Statistics Histogram-based statistics can improve the optimizer query plan in certain situations.
Index Statistics Index statistics and the query optimizer.
InnoDB Persistent Statistics InnoDB persistent statistics are stored on disk, leading to more consistent query plans.
Slow Query Log Extended Statistics The slow query log makes extended statistics available.
User Statistics User Statistics.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/statistics-for-optimizing-queries/