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 -
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_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 THREADPOOL_GROUPS Table
Information Schema THREADPOOL_GROUPS Table. -
Information Schema THREADPOOL_QUEUES Table
Information Schema THREADPOOL_QUEUES Table. -
Information Schema THREADPOOL_STATS Table
Information Schema THREADPOOL_STATS Table. -
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
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
ColumnStore-related Information Schema tables
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.
