> 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/reference/system-tables/information-schema/information-schema-tables/information-schema-table_statistics-table.md).

# Information Schema TABLE\_STATISTICS Table

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `TABLE_STATISTICS` table shows statistics on table usage.

This is part of the [User Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/user-statistics.md) feature, which is not enabled by default.

It contains the following columns:

| Field                     | Type         | Notes                                                                                              |
| ------------------------- | ------------ | -------------------------------------------------------------------------------------------------- |
| TABLE\_SCHEMA             | varchar(192) | The schema (database) name.                                                                        |
| TABLE\_NAME               | varchar(192) | The table name.                                                                                    |
| ROWS\_READ                | bigint(21)   | The number of rows read from the table.                                                            |
| ROWS\_CHANGED             | bigint(21)   | The number of rows changed in the table.                                                           |
| ROWS\_CHANGED\_X\_INDEXES | bigint(21)   | The number of rows changed in the table, multiplied by the number of indexes changed.              |
| ROWS\_INSERTED            | bigint(21)   | From [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md) |
| ROWS\_UPDATED             | bigint(21)   | From [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md) |
| ROWS\_DELETED             | bigint(21)   | From [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md) |
| KEY\_READ\_HITS           | bigint(21)   | From [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md) |
| KEY\_READ\_MISSES         | bigint(21)   | From [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md) |

#### Example

```sql
SELECT * FROM INFORMATION_SCHEMA.TABLE_STATISTICS WHERE TABLE_NAME='user';
+--------------+------------+-----------+--------------+------------------------+
| TABLE_SCHEMA | TABLE_NAME | ROWS_READ | ROWS_CHANGED | ROWS_CHANGED_X_INDEXES |
+--------------+------------+-----------+--------------+------------------------+
| mysql        | user       |         5 |            2 |                      2 |
+--------------+------------+-----------+--------------+------------------------+
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}