INFORMATION_SCHEMA
The name of the database that provides a query interface to the MariaDB data dictionary. (This name is defined by the ANSI SQL standard.) To examine information (metadata) about the database, you can query tables such as INFORMATION-SCHEMA.TABLES and INFORMATION-SCHEMA.COLUMNS, rather than using SHOW commands that produce unstructured output.
The information schema contains some tables that are specific to InnoDB, such as INNODB-LOCKS and INNODB_TRX. You use these tables not to see how the database is structured, but to get real-time information about the workings of the InnoDB storage engine to help with performance monitoring, tuning, and troubleshooting. In particular, these tables provide information about the InnoDB features related to compression, and transactions and their associated locks.
See also compression.
See also data dictionary.
See also database.
See also InnoDB.
See also lock.
See also transaction.