Information Schema for MariaDB Community Server 10.3

Overview

MariaDB Community Server stores data on configuration and operations in the Information Schema. These tables provide general information about how the Server is configured, information on the different tables, keys, and indexes on the Server, as well as information on the various installed plugins and storage engines.

Table

ALL_PLUGINS

APPLICABLE_ROLES

CHARACTER_SETS

CHECK_CONSTRAINTS

CLIENT_STATISTICS

COLLATION_CHARACTER_SET_APPLICABILITY

COLLATIONS

COLUMN_PRIVILEGES

COLUMNS

DISKS

ENABLED_ROLES

ENGINES

EVENTS

FEEDBACK

FILES

GEOMETRY_COLUMNS

GLOBAL_STATUS

GLOBAL_VARIABLES

INDEX_STATISTICS

INNODB_BUFFER_PAGE

INNODB_BUFFER_PAGE_LRU

INNODB_BUFFER_POOL_STATS

INNODB_CMP

INNODB_CMP_PER_INDEX

INNODB_CMP_PER_INDEX_RESET

INNODB_CMP_RESET

INNODB_CMPMEM

INNODB_CMPMEM_RESET

INNODB_FT_BEING_DELETED

INNODB_FT_CONFIG

INNODB_FT_DEFAULT_STOPWORD

INNODB_FT_DELETED

INNODB_FT_INDEX_CACHE

INNODB_FT_INDEX_TABLE

INNODB_LOCK_WAITS

INNODB_LOCKS

INNODB_METRICS

INNODB_MUTEXES

INNODB_SYS_COLUMNS

INNODB_SYS_DATAFILES

INNODB_SYS_FIELDS

INNODB_SYS_FOREIGN

INNODB_SYS_FOREIGN_COLS

INNODB_SYS_INDEXES

INNODB_SYS_SEMAPHORE_WAITS

INNODB_SYS_TABLES

INNODB_SYS_TABLESPACES

INNODB_SYS_TABLESTATS

INNODB_SYS_VIRTUAL

INNODB_TABLESPACES_ENCRYPTION

INNODB_TABLESPACES_SCRUBBING

INNODB_TRX

KEY_CACHES

KEY_COLUMN_USAGE

KEYWORDS

LOCALES

METADATA_LOCK_INFO

PARAMETERS

PARTITIONS

PLUGINS

PROCESSLIST

PROFILING

QUERY_CACHE_INFO

QUERY_RESPONSE_TIME

REFERENTIAL_CONSTRAINTS

ROCKSDB_CF_OPTIONS

ROCKSDB_CFSTATS

ROCKSDB_COMPACTION_STATS

ROCKSDB_DBSTATS

ROCKSDB_DDL

ROCKSDB_DEADLOCK

ROCKSDB_GLOBAL_INFO

ROCKSDB_INDEX_FILE_MAP

ROCKSDB_LOCKS

ROCKSDB_PERF_CONTEXT

ROCKSDB_PERF_CONTEXT_GLOBAL

ROCKSDB_SST_PROPS

ROCKSDB_TRX

ROUTINES

SCHEMA_PRIVILEGES

SCHEMATA

SESSION_STATUS

SESSION_VARIABLES

SPATIAL_REF_SYS

SPIDER_ALLOC_MEM

SQL_FUNCTIONS

STATISTICS

SYSTEM_VARIABLES

TABLE_CONSTRAINTS

TABLE_PRIVILEGES

TABLE_STATISTICS

TABLES

TABLESPACES

TRIGGERS

USER_PRIVILEGES

USER_STATISTICS

USER_VARIABLES

VIEWS

WSREP_MEMBERSHIP

WSREP_STATUS

The following Information-schema Tables are not present in MariaDB Community Server 10.3.39 but are present in one or more older 10.3 CS versions. Click on an item to see its details, including when it was removed.

Table

INNODB_CHANGED_PAGES