# MySQL Information Schema

The [MySQL `information_schema` database](https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html) provides access to a variety of database metadata useful for inspecting your database and also used by database tooling. Dolt provides a subset of the data available in `information_schema`, as described below. In general, all tables from MySQL's `information_schema` exist, with the correct schema, but not all data is populated. If you need support for information\_schema metadata that is available in MySQL, but not yet available in Dolt, please [open a GitHub issue](https://github.com/dolthub/dolt/issues/new) to let us know what you need.

## Core Metadata Tables

| Table                                                                                                                                                   | Supported | Notes and limitations                                                                                 |
| ------------------------------------------------------------------------------------------------------------------------------------------------------- | --------- | ----------------------------------------------------------------------------------------------------- |
| [ADMINISTRABLE\_ROLE\_AUTHORIZATIONS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-administrable-role-authorizations-table.html)          | ❌         |                                                                                                       |
| [APPLICABLE\_ROLES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-applicable-roles-table.html)                                             | ❌         |                                                                                                       |
| [CHARACTER\_SETS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-character-sets-table.html)                                                 | ✅         |                                                                                                       |
| [CHECK\_CONSTRAINTS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-check-constraints-table.html)                                           | ✅         |                                                                                                       |
| [COLLATION\_CHARACTER\_SET\_APPLICABILITY](https://dev.mysql.com/doc/refman/8.0/en/information-schema-collation-character-set-applicability-table.html) | ✅         |                                                                                                       |
| [COLLATIONS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-collations-table.html)                                                          | ✅         |                                                                                                       |
| [COLUMN\_PRIVILEGES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-column-privileges-table.html)                                           | 🟠        | Dolt does not `mysql.columns_priv` table yet.                                                         |
| [COLUMN\_STATISTICS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-column-statistics-table.html)                                           | 🟠️       | `histogram` column shows only `buckets` key values.                                                   |
| [COLUMNS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html)                                                                | 🟠️       | View columns are not included ([GitHub Issue](https://github.com/dolthub/dolt/issues/3168)).          |
| [COLUMNS\_EXTENSIONS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-extensions-table.html)                                         | ✅         | Reserved in MySQL for future use.                                                                     |
| [ENABLED\_ROLES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-enabled-roles-table.html)                                                   | ❌         |                                                                                                       |
| [ENGINES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-engines-table.html)                                                                | ✅         | Only the `InnoDB` engine is supported.                                                                |
| [EVENTS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html)                                                                  | ❌         | Not supported in Dolt.                                                                                |
| [FILES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html)                                                                    | ❌         | Not supported in Dolt.                                                                                |
| [KEY\_COLUMN\_USAGE](https://dev.mysql.com/doc/refman/8.0/en/information-schema-key-column-usage-table.html)                                            | ✅         |                                                                                                       |
| [KEYWORDS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-keywords-table.html)                                                              | ✅         |                                                                                                       |
| [ndb\_transid\_mysql\_connection\_map](https://dev.mysql.com/doc/refman/8.0/en/information-schema-ndb-transid-mysql-connection-map-table.html)          | ❌         | Not supported in Dolt.                                                                                |
| [OPTIMIZER\_TRACE](https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimizer-trace-table.html)                                               | ❌         | Not supported in Dolt.                                                                                |
| [PARAMETERS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-parameters-table.html)                                                          | ✅         | Dolt does not support stored functions yet.                                                           |
| [PARTITIONS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html)                                                          | ❌         | Not supported in Dolt.                                                                                |
| [PLUGINS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-plugins-table.html)                                                                | ❌️        | Not supported in Dolt.                                                                                |
| [PROCESSLIST](https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html)                                                        | 🟠️       | `status` column missing some cases.                                                                   |
| [PROFILING](https://dev.mysql.com/doc/refman/8.0/en/information-schema-profiling-table.html)                                                            | ❌         | Not supported in Dolt.                                                                                |
| [REFERENTIAL\_CONSTRAINTS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-referential-constraints-table.html)                               | ✅         |                                                                                                       |
| [RESOURCE\_GROUPS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-resource-groups-table.html)                                               | ❌         | Not supported in Dolt.                                                                                |
| [ROLE\_COLUMN\_GRANTS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-column-grants-table.html)                                        | 🟠        | Dolt does not `mysql.columns_priv` table yet.                                                         |
| [ROLE\_ROUTINE\_GRANTS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-routine-grants-table.html)                                      | ❌         |                                                                                                       |
| [ROLE\_TABLE\_GRANTS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-table-grants-table.html)                                          | ❌         |                                                                                                       |
| [ROUTINES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html)                                                              | 🟠️       | Dolt does not support stored functions yet.                                                           |
| [SCHEMA\_PRIVILEGES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-schema-privileges-table.html)                                           | ✅         |                                                                                                       |
| [SCHEMATA](https://dev.mysql.com/doc/refman/8.0/en/information-schema-schemata-table.html)                                                              | ✅         |                                                                                                       |
| [SCHEMATA\_EXTENSIONS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-schemata-extensions-table.html)                                       | ✅         |                                                                                                       |
| [ST\_GEOMETRY\_COLUMNS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-geometry-columns-table.html)                                      | ✅         |                                                                                                       |
| [ST\_SPATIAL\_REFERENCE\_SYSTEMS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-spatial-reference-systems-table.html)                   | ✅         |                                                                                                       |
| [ST\_UNITS\_OF\_MEASURE](https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-units-of-measure-table.html)                                     | ✅         |                                                                                                       |
| [STATISTICS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html)                                                          | 🟠        | `cardinality` column is not populated ([GitHub Issue](https://github.com/dolthub/dolt/issues/5200)).  |
| [TABLE\_CONSTRAINTS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-table.html)                                           | ✅         |                                                                                                       |
| [TABLE\_CONSTRAINTS\_EXTENSIONS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-extensions-table.html)                    | ✅         |                                                                                                       |
| [TABLE\_PRIVILEGES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-privileges-table.html)                                             | ✅         |                                                                                                       |
| [TABLES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html)                                                                  | 🟠️       | Some columns are not populated ([GitHub Issue](https://github.com/dolthub/dolt/issues/5202)).         |
| [TABLES\_EXTENSIONS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-extensions-table.html)                                           | ✅         | Reserved in MySQL for future use.                                                                     |
| [TABLESPACES\_EXTENSIONS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-tablespaces-extensions-table.html)                                 | ❌         | Reserved in MySQL for future use.                                                                     |
| [TRIGGERS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-triggers-table.html)                                                              | ✅         |                                                                                                       |
| [USER\_ATTRIBUTES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-attributes-table.html)                                               | 🟠        | `attributes` column is not populated ([GitHub Issue](https://github.com/dolthub/dolt/issues/5203)).   |
| [USER\_PRIVILEGES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-privileges-table.html)                                               | ✅         |                                                                                                       |
| [VIEW\_ROUTINE\_USAGE](https://dev.mysql.com/doc/refman/8.0/en/information-schema-view-routine-usage-table.html)                                        | ❌         |                                                                                                       |
| [VIEW\_TABLE\_USAGE](https://dev.mysql.com/doc/refman/8.0/en/information-schema-view-table-usage-table.html)                                            | ❌         |                                                                                                       |
| [VIEWS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-views-table.html)                                                                    | 🟠        | `view_definition` does not match MySQL ([GitHub Issue](https://github.com/dolthub/dolt/issues/3004)). |

## InnoDB Tables

MySQL's `information_schema` also provides tables specific to the use of the [InnoDB storage engine](https://dev.mysql.com/doc/refman/5.6/en/innodb-introduction.html). These tables are provided in Dolt to avoid issues with MySQL tools that read from these tables, however since Dolt uses its own storage engine, no data is populated in these tables.

| Table                                                                                                                                       | Supported | Notes and limitations |
| ------------------------------------------------------------------------------------------------------------------------------------------- | --------- | --------------------- |
| [INNODB\_BUFFER\_PAGE](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-table.html)                            | ❌         |                       |
| [INNODB\_BUFFER\_PAGE\_LRU](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-lru-table.html)                   | ❌         |                       |
| [INNODB\_BUFFER\_POOL\_STATS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html)               | ❌         |                       |
| [INNODB\_CACHED\_INDEXES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cached-indexes-table.html)                      | ❌         |                       |
| [INNODB\_CMP](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-table.html)                                             | ❌         |                       |
| [INNODB\_CMP\_PER\_INDEX](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-per-index-table.html)                       | ❌         |                       |
| [INNODB\_CMP\_PER\_INDEX\_RESET](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-per-index-table.html)                | ❌         |                       |
| [INNODB\_CMP\_RESET](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-table.html)                                      | ❌         |                       |
| [INNODB\_CMPMEM](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmpmem-table.html)                                       | ❌         |                       |
| [INNODB\_CMPMEM\_RESET](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmpmem-table.html)                                | ❌         |                       |
| [INNODB\_COLUMNS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html)                                     | ❌         |                       |
| [INNODB\_DATAFILES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-datafiles-table.html)                                 | ❌         |                       |
| [INNODB\_FIELDS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-fields-table.html)                                       | ❌         |                       |
| [INNODB\_FOREIGN](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-table.html)                                     | ❌         |                       |
| [INNODB\_FOREIGN\_COLS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-cols-table.html)                          | ❌         |                       |
| [INNODB\_FT\_BEING\_DELETED](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-being-deleted-table.html)                 | ❌         |                       |
| [INNODB\_FT\_CONFIG](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-config-table.html)                                | ❌         |                       |
| [INNODB\_FT\_DEFAULT\_STOPWORD](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-default-stopword-table.html)           | ❌         |                       |
| [INNODB\_FT\_DELETED](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-deleted-table.html)                              | ❌         |                       |
| [INNODB\_FT\_INDEX\_CACHE](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-cache-table.html)                     | ❌         |                       |
| [INNODB\_FT\_INDEX\_TABLE](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-table-table.html)                     | ❌         |                       |
| [INNODB\_INDEXES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html)                                     | ❌         |                       |
| [INNODB\_METRICS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-metrics-table.html)                                     | ❌         |                       |
| [INNODB\_SESSION\_TEMP\_TABLESPACES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-session-temp-tablespaces-table.html) | ❌         |                       |
| [INNODB\_TABLES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tables-table.html)                                       | ❌         |                       |
| [INNODB\_TABLESPACES](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-table.html)                             | ❌         |                       |
| [INNODB\_TABLESPACES\_BRIEF](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-brief-table.html)                | ❌         |                       |
| [INNODB\_TABLESTATS](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html)                               | ❌         |                       |
| [INNODB\_TEMP\_TABLE\_INFO](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-temp-table-info-table.html)                   | ❌         |                       |
| [INNODB\_TRX](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-trx-table.html)                                             | ❌         |                       |
| [INNODB\_VIRTUAL](https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-virtual-table.html)                                     | ❌         |                       |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.dolthub.com/sql-reference/sql-support/information-schema.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.