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. -
ColumnStore Information Schema Tables
ColumnStore-related 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 CATALOG Table
Information about server catalogs. -
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 KEY_PERIOD_USAGE Table
Information about Application-Time Periods. -
Information Schema KEYWORDS Table
MariaDB keywords. -
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. -
Information Schema PERIODS Table
Information about application time periods. -
Information Schema PLUGINS Table
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_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 SEQUENCES Table
Information about sequences on the server. -
Information Schema SLAVE_STATUS Table
Information Schema SLAVE_STATUS Table. -
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 SPIDER_WRAPPER_PROTOCOLS Table
Installed along with the Spider storage engine. -
Information Schema SQL_FUNCTIONS Table
Functions in MariaDB. -
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 THREAD_POOL_GROUPS Table
Information Schema THREAD_POOL_GROUPS Table. -
Information Schema THREAD_POOL_QUEUES Table
Information Schema THREAD_POOL_QUEUES Table. -
Information Schema THREAD_POOL_STATS Table
Information Schema THREAD_POOL_STATS Table. -
Information Schema THREAD_POOL_WAITS Table
Information Schema THREAD_POOL_WAITS Table. -
Information Schema TRIGGERS Table
Information about triggers -
Information Schema USER_PRIVILEGES Table
Global user privilege information derived from the mysql.global_priv grant table -
Information Schema USER_STATISTICS Table
User activity -
Information Schema USER_VARIABLES Table
User-defined variable information. -
Information Schema USERS Table
Users, password expiry, and limits due to max_password_errors. -
Information Schema VIEWS Table
Information about views. -
Information Schema WSREP_MEMBERSHIP Table
Galera node cluster membership information. -
Information Schema WSREP_STATUS Table
Galera node cluster status information.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
