Information Schema in 10.5 ES¶

MariaDB Enterprise 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

COLUMNSTORE_COLUMNS

COLUMNSTORE_EXTENTS

COLUMNSTORE_FILES

COLUMNSTORE_TABLES

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_TRX

KEY_CACHES

KEY_COLUMN_USAGE

LOCALES

METADATA_LOCK_INFO

OPTIMIZER_TRACE

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

SPIDER_WRAPPER_PROTOCOLS

STATISTICS

SYSTEM_VARIABLES

TABLE_CONSTRAINTS

TABLE_PRIVILEGES

TABLE_STATISTICS

TABLES

TABLESPACES

THREAD_POOL_GROUPS

THREAD_POOL_QUEUES

THREAD_POOL_STATS

THREAD_POOL_WAITS

TRIGGERS

USER_PRIVILEGES

USER_STATISTICS

USER_VARIABLES

VIEWS

WSREP_MEMBERSHIP

WSREP_STATUS