Chapter 24 INFORMATION_SCHEMA Tables
Table of Contents
- 24.1 Introduction
- 24.2 The INFORMATION_SCHEMA CHARACTER_SETS Table
- 24.3 The INFORMATION_SCHEMA COLLATIONS Table
- 24.4 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- 24.5 The INFORMATION_SCHEMA COLUMNS Table
- 24.6 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- 24.7 The INFORMATION_SCHEMA ENGINES Table
- 24.8 The INFORMATION_SCHEMA EVENTS Table
- 24.9 The INFORMATION_SCHEMA FILES Table
- 24.10 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
- 24.11 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
- 24.12 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- 24.13 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
- 24.14 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
- 24.15 The INFORMATION_SCHEMA PARAMETERS Table
- 24.16 The INFORMATION_SCHEMA PARTITIONS Table
- 24.17 The INFORMATION_SCHEMA PLUGINS Table
- 24.18 The INFORMATION_SCHEMA PROCESSLIST Table
- 24.19 The INFORMATION_SCHEMA PROFILING Table
- 24.20 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
- 24.21 The INFORMATION_SCHEMA ROUTINES Table
- 24.22 The INFORMATION_SCHEMA SCHEMATA Table
- 24.23 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
- 24.24 The INFORMATION_SCHEMA STATISTICS Table
- 24.25 The INFORMATION_SCHEMA TABLES Table
- 24.26 The INFORMATION_SCHEMA TABLESPACES Table
- 24.27 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- 24.28 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
- 24.29 The INFORMATION_SCHEMA TRIGGERS Table
- 24.30 The INFORMATION_SCHEMA USER_PRIVILEGES Table
- 24.31 The INFORMATION_SCHEMA VIEWS Table
- 24.32 INFORMATION_SCHEMA InnoDB Tables
-
- 24.32.1 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
- 24.32.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
- 24.32.3 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
- 24.32.4 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
- 24.32.5 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
- 24.32.6 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
- 24.32.7 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
- 24.32.8 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
- 24.32.9 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
- 24.32.10 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
- 24.32.11 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
- 24.32.12 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
- 24.32.13 The INFORMATION_SCHEMA INNODB_LOCKS Table
- 24.32.14 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
- 24.32.15 The INFORMATION_SCHEMA INNODB_METRICS Table
- 24.32.16 The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table
- 24.32.17 The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table
- 24.32.18 The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table
- 24.32.19 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table
- 24.32.20 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table
- 24.32.21 The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table
- 24.32.22 The INFORMATION_SCHEMA INNODB_SYS_TABLES Table
- 24.32.23 The INFORMATION_SCHEMA INNODB_SYS_TABLESPACES Table
- 24.32.24 The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View
- 24.32.25 The INFORMATION_SCHEMA INNODB_SYS_VIRTUAL Table
- 24.32.26 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table
- 24.32.27 The INFORMATION_SCHEMA INNODB_TRX Table
- 24.33 INFORMATION_SCHEMA Thread Pool Tables
- 24.34 INFORMATION_SCHEMA Connection-Control Tables
- 24.35 Extensions to SHOW Statements
INFORMATION_SCHEMA
provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data dictionary and system catalog.