#8119 introduced the framework for creating virtual schemas, and specifically, the information_schema. Subsequently, a group PRs added what was deemed to be the most immediately critical set of tables. However, the specification for the information_schema is extensive, and there are a number of other tables which can be added with relative ease. The set of all information_schema tables is:

• character_sets
• collations
• collation_character_set_applicability
• columns
• column_privileges
• constraint_column_usage
• engines
• events
• files
• global_status
• session_statuss
• global_variables
• session_variables
• key_column_usage
• optimizer_trace
• parameters
• partitions
• plugins
• processlist
• profiling
• referential_constraints
• routines
• schemata
• schema_privileges
• sequences
• statistics
• tables
• tablespaces
• table_constraints
• table_privileges
• triggers
• user_privileges
• views

The process for adding a new information_schema table is:

1. create a new virtualSchemaTable variable with a table schema definition
2. construct a population function implementation to populate this schema on demand
3. add the variable to the information_schema's table list
4. add necessary testing to testdata/information_schema

Helpful sources:

• MySQL information_schema docs
• PostgreSQL information_schema docs