MariaDB starting with 10.0.1

The mysql.table_stats table was introduced as part of the Engine-independent table statistics feature implemented in MariaDB 10.0.1.

The mysql.table_stats table is one of three tables storing data used for Engine-independent table statistics added in MariaDB 10.0.1. The others are mysql.column_stats and mysql.index_stats.

The table contains the following fields:

FieldTypeNullKeyDefaultDescription
db_namevarchar(64)NOPRINULLDatabase the table is in .
table_namevarchar(64)NOPRINULLTable name.
cardinalitybigint(21) unsignedYESNULLNumber of records in the table.

It is possible to manually update the table. See Manual updates to statistics tables for details.

Comments

Comments loading...