Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 36.3Mb
PDF (A4) - 36.3Mb
PDF (RPM) - 36.2Mb
HTML Download (TGZ) - 10.4Mb
HTML Download (Zip) - 10.4Mb
HTML Download (RPM) - 9.2Mb
Man Pages (TGZ) - 224.6Kb
Man Pages (Zip) - 332.7Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  INFORMATION_SCHEMA Tables

Chapter 23 INFORMATION_SCHEMA Tables

Table of Contents

23.1 Introduction
23.2 The INFORMATION_SCHEMA CHARACTER_SETS Table
23.3 The INFORMATION_SCHEMA COLLATIONS Table
23.4 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
23.5 The INFORMATION_SCHEMA COLUMNS Table
23.6 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
23.7 The INFORMATION_SCHEMA ENGINES Table
23.8 The INFORMATION_SCHEMA EVENTS Table
23.9 The INFORMATION_SCHEMA FILES Table
23.10 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
23.11 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
23.12 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
23.13 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
23.14 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
23.15 The INFORMATION_SCHEMA PARAMETERS Table
23.16 The INFORMATION_SCHEMA PARTITIONS Table
23.17 The INFORMATION_SCHEMA PLUGINS Table
23.18 The INFORMATION_SCHEMA PROCESSLIST Table
23.19 The INFORMATION_SCHEMA PROFILING Table
23.20 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
23.21 The INFORMATION_SCHEMA ROUTINES Table
23.22 The INFORMATION_SCHEMA SCHEMATA Table
23.23 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
23.24 The INFORMATION_SCHEMA STATISTICS Table
23.25 The INFORMATION_SCHEMA TABLES Table
23.26 The INFORMATION_SCHEMA TABLESPACES Table
23.27 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
23.28 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
23.29 The INFORMATION_SCHEMA TRIGGERS Table
23.30 The INFORMATION_SCHEMA USER_PRIVILEGES Table
23.31 The INFORMATION_SCHEMA VIEWS Table
23.32 INFORMATION_SCHEMA InnoDB Tables
23.32.1 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
23.32.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
23.32.3 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
23.32.4 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
23.32.5 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
23.32.6 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
23.32.7 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
23.32.8 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
23.32.9 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
23.32.10 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
23.32.11 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
23.32.12 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
23.32.13 The INFORMATION_SCHEMA INNODB_LOCKS Table
23.32.14 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
23.32.15 The INFORMATION_SCHEMA INNODB_METRICS Table
23.32.16 The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table
23.32.17 The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table
23.32.18 The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table
23.32.19 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table
23.32.20 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table
23.32.21 The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table
23.32.22 The INFORMATION_SCHEMA INNODB_SYS_TABLES Table
23.32.23 The INFORMATION_SCHEMA INNODB_SYS_TABLESPACES Table
23.32.24 The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View
23.32.25 The INFORMATION_SCHEMA INNODB_SYS_VIRTUAL Table
23.32.26 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table
23.32.27 The INFORMATION_SCHEMA INNODB_TRX Table
23.33 INFORMATION_SCHEMA Thread Pool Tables
23.33.1 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table
23.33.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table
23.33.3 The INFORMATION_SCHEMA TP_THREAD_STATE Table
23.34 INFORMATION_SCHEMA Connection-Control Tables
23.34.1 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table
23.35 INFORMATION_SCHEMA MySQL Enterprise Firewall Tables
23.35.1 The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table
23.35.2 The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table
23.36 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.