Information Schema Tables

• Information Schema InnoDB Tables

  All InnoDB-specific Information Schema tables.
• Information Schema MyRocks Tables

  List of Information Schema tables specifically related to MyRocks.
• Information Schema XtraDB Tables

  All XtraDB-specific Information Schema Tables
• Information Schema ALL_PLUGINS Table

  Information about server plugins, whether installed or not.
• Information Schema APPLICABLE_ROLES Table

  Roles available to be used.
• Information Schema CHANGED_PAGE_BITMAPS Table

  Dummy table to allow FLUSH NO_WRITE_TO_BINLOG CHANGED_PAGE_BITMAPS
• Information Schema CHARACTER_SETS Table

  Supported character sets.
• Information Schema CHECK_CONSTRAINTS Table

  Supported check constraints.
• Information Schema CLIENT_STATISTICS Table

  Statistics about client connections
• Information Schema COLLATION_CHARACTER_SET_APPLICABILITY Table

  Collations and associated character sets
• Information Schema COLLATIONS Table

  Supported collations.
• Information Schema COLUMN_PRIVILEGES Table

  Column privileges
• Information Schema COLUMNS Table

  Information about table fields.
• Information Schema DISKS Table

  Plugin that allows the disk space situation to be monitored.
• Information Schema ENABLED_ROLES Table

  Enabled roles for the current session.
• Information Schema ENGINES Table

  Storage engine information.
• Information Schema EVENTS Table

  Server event information
• Information Schema FEEDBACK Table

  Contents submitted by the Feedback Plugin
• Information Schema FILES Table

  The FILES tables is unused in MariaDB.
• Information Schema GEOMETRY_COLUMNS Table

  Support for Spatial Reference systems for GIS data
• Information Schema GLOBAL_STATUS and SESSION_STATUS Tables

  Global and session status variables
• Information Schema GLOBAL_VARIABLES and SESSION_VARIABLES Tables

  Global and session system variables
• Information Schema INDEX_STATISTICS Table

  Statistics on index usage
• Information Schema KEY_CACHES Table

  Segmented key cache statistics
• Information Schema KEY_COLUMN_USAGE Table

  Key columns that have constraints
• Information Schema LOCALES Table

  Compiled-in server locales
• Information Schema METADATA_LOCK_INFO Table

  Active metadata locks
• Information Schema MROONGA_STATS Table

  Mroonga activities statistics.
• Information Schema OPTIMIZER_TRACE Table

  Contains Optimizer Trace information.
• Information Schema PARAMETERS Table

  Information about stored procedures and stored functions parameters
• Information Schema PARTITIONS Table

  Table partition information
• Plugins Table - Information Schema

  Information Schema table containing information on plugins installed on a server.
• Information Schema PROCESSLIST Table

  Thread information.
• Information Schema PROFILING Table

  Statement resource usage
• Information Schema QUERY_CACHE_INFO Table

  View the contents of the query cache
• Information Schema QUERY_CACHE_QUERIES Table

  MariaDB starting with <a href="/kb/en/mariadb-101x-release-notes/">10.1.x</...
• Information Schema QUERY_CACHE_QUERIES_TABLES Table

  All tables used in a query cache entry
• Information Schema QUERY_CACHE_TABLES Table

  Tables and number of queries used in a query cache entry
• Information Schema QUERY_RESPONSE_TIME Table

  Query time information
• Information Schema REFERENTIAL_CONSTRAINTS Table

  Foreign key information
• Information Schema ROUTINES Table

  Stored procedures and stored functions information
• Information Schema SCHEMA_PRIVILEGES Table

  Database privilege information
• Information Schema SCHEMATA Table

  Information about databases
• Information Schema SPATIAL_REF_SYS Table

  Information on each spatial reference system used in the database
• Information Schema SPIDER_ALLOC_MEM Table

  Information about Spider's memory usage.
• Information Schema STATISTICS Table

  Table index information
• Information Schema SYSTEM_VARIABLES Table

  Current global and session values and various metadata of all system variables.
• Information Schema TABLE_CONSTRAINTS Table

  Tables containing constraints
• Information Schema TABLE_PRIVILEGES Table

  Table privileges
• Information Schema TABLE_STATISTICS Table

  Statistics on table usage
• Information Schema TABLES Table

  Database table information.
• Information Schema TABLESPACES Table

  Information about active tablespaces
• Information Schema TRIGGERS Table

  Information about triggers
• Information Schema USER_PRIVILEGES Table

  Global user privilege information derived from the mysql.user grant table
• Information Schema USER_STATISTICS Table

  User activity
• Information Schema USER_VARIABLES Table

  User-defined variable information.
• Information Schema VIEWS Table

  under: » Library » MariaDB Server Documentation » Programming & Customizing MariaDB » Views
  Information about views
• Information Schema WSREP_MEMBERSHIP Table

  Galera node cluster membership information
• Information Schema WSREP_STATUS Table

  Galera node cluster status information
• ColumnStore Information Schema Tables

  under: » Library » MariaDB Server Documentation » Columns, Storage Engines, and Plugins » Storage Engines » MariaDB ColumnStore » ColumnStore SQL Structure and Commands
  ColumnStore-related Information Schema tables

There are 2 related questions.

• ↑ Information Schema ↑
• Extended Show →