Links

MySQL Information Schema

The MySQL information_schema database 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 to let us know what you need.

Core Metadata Tables

Table
Supported
Notes and limitations
COLUMNS
🟠️
Some column metadata not populated (e.g. character_maximum_length, numeric_precision, numeric_scale, datetime_precision, privileges). View columns are not included (#3168).
🟠
Reserved in MySQL for future use
ENGINES
EVENTS
FILES
KEYWORDS
PLUGINS
🟠️
Dolt does not support loading plugins
PROFILING
ROUTINES
🟠️
All routines are listed; some metadata is not populated (e.g. data_type, numeric_precision, numeric_scale, datetime_precision)
SCHEMATA
TABLES
🟠️
All tables are listed; some metadata is not populated (e.g. table_rows, avg_row_length, data_length, index_length)
Reserved in MySQL for future use
Unused and deprecated in MySQL
Reserved in MySQL for future use
Deprecated in MySQL; moved to performance_schema
Deprecated in MySQL; moved to performance_schema
Deprecated in MySQL; moved to performance_schema
TRIGGERS
VIEWS

InnoDB Tables

MySQL's information_schema also provides tables specific to the use of the InnoDB storage engine. 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