--- title: MySQL Information Schema description: Which information_schema tables Dolt exposes. --- 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) | ❌ | |