The information_schema database
The
information_schema
database (often called I_S
for brevity) is a virtual database that contains informative tables. These tables can be divided into several groups:
- Metadata tables: Tables such as
SCHEMATA
,TABLES
, andCOLUMNS
contain information about the structure of databases, tables, columns, and so on. - Status and variables tables: The
GLOBAL_VARIABLES
andSESSION_VARIABLES
tables list the values of the server's system variables. TheGLOBAL_STATUS
andSESSION_STATUS
tables provide information about the operations performed by the server. - Privilege tables: The tables whose names end with
_PRIVILEGES
indicate users that have various permissions on objects. - The PROFILING table: This table can be used to monitor ...
Get Mastering MariaDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.