Summary of table type information under the MySQL information_schema library

Zoning

PARTITIONS: table partition

FILES: the file that stores the MySQL NDB disk data table

privilege

Column privileges owned by the COLUMN_PRIVILEGES:MySQL user account

Database privileges owned by the SCHEMA_PRIVILEGES:MySQL user account

Table privileges of the TABLE_PRIVILEGES:MySQL user account

Global privileges held by the USER_PRIVILEGES:MySQL user account

Character set support

CHARACTER_SETS: available character sets

COLLATIONS: collation of each character set

COLLATION_CHARACTER_SET_APPLICABILITY: suitable for collation of specific character sets

Constraints and indexing

KEY_COLUMN_USAGE: constraints for key columns

REFERENTIAL_CONSTRAINTS: foreign key

STATISTICS: table index

TABLE_CONSTRAINTS: constraints for tabl

Server settings and statu

KEY_COLUMN_USAGE: constraint

GLOBAL_STATUS: status value of all MySQL connections

GLOBAL_VARIABLES: the value for the new MySQL connection

PLUGINS: server plug-in

PROCESSLIST: indicates which threads are running

SESSION_STATUS: status value of the current MySQL connection

SESSION_VARIABLES: the effective value of the current MySQL connection

Routines and related information

EVENTS: scheduled event

ROUTINES: stored procedures and functions

TRIGGERS: triggers in the database

PARAMETERS: stored procedures and functional parameters and stored functions

Table information

COLUMNS: columns in tables and views

ENGINES: storage engine

SCHEMATA: database

TABLES: tables in the database

VIEWS: views in the database

InnoDB

INNODB_CMP and INNODB_CMP_RESET: status of related operations on compressed InnoDB tables

Status of compressed pages in INNODB_CMPMEM and INNODB_CMPMEM_RESET:InnoDB buffer pools

Every lock requested and held by the INNODB_LOCKS:InnoDB firm

INNODB_LOCK_WAITS: one or more row locks for each blocked InnoDB transaction

INNODB_TRX: all transactions currently being executed within InnoDB

TABLESPACES: active tablespace