Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 29.5Mb
PDF (A4) - 29.5Mb
PDF (RPM) - 28.2Mb
HTML Download (TGZ) - 7.1Mb
HTML Download (Zip) - 7.1Mb
HTML Download (RPM) - 6.1Mb
Man Pages (TGZ) - 190.2Kb
Man Pages (Zip) - 305.1Kb
Info (Gzip) - 2.8Mb
Info (Zip) - 2.8Mb
Excerpts from this Manual

MySQL 5.6 Reference Manual  /  INFORMATION_SCHEMA Tables

Chapter 21 INFORMATION_SCHEMA Tables

Table of Contents

21.1 Introduction
21.2 INFORMATION_SCHEMA Table Reference
21.3 INFORMATION_SCHEMA General Tables
21.3.1 INFORMATION_SCHEMA General Table Reference
21.3.2 The INFORMATION_SCHEMA CHARACTER_SETS Table
21.3.3 The INFORMATION_SCHEMA COLLATIONS Table
21.3.4 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
21.3.5 The INFORMATION_SCHEMA COLUMNS Table
21.3.6 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
21.3.7 The INFORMATION_SCHEMA ENGINES Table
21.3.8 The INFORMATION_SCHEMA EVENTS Table
21.3.9 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
21.3.10 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
21.3.11 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
21.3.12 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table
21.3.13 The INFORMATION_SCHEMA PARAMETERS Table
21.3.14 The INFORMATION_SCHEMA PARTITIONS Table
21.3.15 The INFORMATION_SCHEMA PLUGINS Table
21.3.16 The INFORMATION_SCHEMA PROCESSLIST Table
21.3.17 The INFORMATION_SCHEMA PROFILING Table
21.3.18 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
21.3.19 The INFORMATION_SCHEMA ROUTINES Table
21.3.20 The INFORMATION_SCHEMA SCHEMATA Table
21.3.21 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
21.3.22 The INFORMATION_SCHEMA STATISTICS Table
21.3.23 The INFORMATION_SCHEMA TABLES Table
21.3.24 The INFORMATION_SCHEMA TABLESPACES Table
21.3.25 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
21.3.26 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
21.3.27 The INFORMATION_SCHEMA TRIGGERS Table
21.3.28 The INFORMATION_SCHEMA USER_PRIVILEGES Table
21.3.29 The INFORMATION_SCHEMA VIEWS Table
21.4 INFORMATION_SCHEMA InnoDB Tables
21.4.1 INFORMATION_SCHEMA InnoDB Table Reference
21.4.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
21.4.3 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
21.4.4 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
21.4.5 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
21.4.6 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
21.4.7 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
21.4.8 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
21.4.9 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
21.4.10 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
21.4.11 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
21.4.12 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
21.4.13 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
21.4.14 The INFORMATION_SCHEMA INNODB_LOCKS Table
21.4.15 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
21.4.16 The INFORMATION_SCHEMA INNODB_METRICS Table
21.4.17 The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table
21.4.18 The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table
21.4.19 The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table
21.4.20 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table
21.4.21 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table
21.4.22 The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table
21.4.23 The INFORMATION_SCHEMA INNODB_SYS_TABLES Table
21.4.24 The INFORMATION_SCHEMA INNODB_SYS_TABLESPACES Table
21.4.25 The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View
21.4.26 The INFORMATION_SCHEMA INNODB_TRX Table
21.5 INFORMATION_SCHEMA NDB Cluster Tables
21.5.1 The INFORMATION_SCHEMA FILES Table
21.5.2 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
21.6 INFORMATION_SCHEMA Thread Pool Tables
21.6.1 INFORMATION_SCHEMA Thread Pool Table Reference
21.6.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table
21.6.3 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table
21.6.4 The INFORMATION_SCHEMA TP_THREAD_STATE Table
21.7 INFORMATION_SCHEMA Connection-Control Tables
21.7.1 INFORMATION_SCHEMA Connection-Control Table Reference
21.7.2 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table
21.8 INFORMATION_SCHEMA MySQL Enterprise Firewall Tables
21.8.1 INFORMATION_SCHEMA Firewall Table Reference
21.8.2 The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table
21.8.3 The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table
21.9 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.