INFORMATION_SCHEMA Index

A | C | E | F | I | K | M | N | O | P | R | S | T | U | V

A

[index top]

ADMINISTRABLE_ROLE_AUTHORIZATIONS

Section 26.2, “The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table”

APPLICABLE_ROLES

Section 26.3, “The INFORMATION_SCHEMA APPLICABLE_ROLES Table”

C

[index top]

CHARACTER_SETS

Section 10.3.8, “Character Set Introducers”
Section 10.2, “Character Sets and Collations in MySQL”
Section 10.3.6, “Character String Literal Character Set and Collation”
Section 10.3.5, “Column Character Set and Collation”
Section 10.3.3, “Database Character Set and Collation”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 13.7.7.3, “SHOW CHARACTER SET Statement”
Section 10.10, “Supported Character Sets and Collations”
Section 10.3.4, “Table Character Set and Collation”
Section 26.4, “The INFORMATION_SCHEMA CHARACTER_SETS Table”

CHECK_CONSTRAINTS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 26.5, “The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table”

COLLATION_CHARACTER_SET_APPLICABILITY

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 26.7, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”

COLLATIONS

Section 10.15, “Character Set Configuration”
Section 10.2, “Character Sets and Collations in MySQL”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 13.7.7.4, “SHOW COLLATION Statement”
Section 10.8.5, “The binary Collation Compared to _bin Collations”
Section 11.3.2, “The CHAR and VARCHAR Types”
Section 26.6, “The INFORMATION_SCHEMA COLLATIONS Table”
Section 10.10.1, “Unicode Character Sets”

COLUMN_PRIVILEGES

Section 26.10, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

COLUMN_STATISTICS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 8.9.6, “Optimizer Statistics”
Section 26.11, “The INFORMATION_SCHEMA COLUMN_STATISTICS Table”

COLUMNS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 13.7.7.5, “SHOW COLUMNS Statement”
Section 26.8, “The INFORMATION_SCHEMA COLUMNS Table”
Section 26.51.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 26.51.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 26.51.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”
Section 26.51.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
Section 26.51.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 26.51.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 26.51.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 26.51.8, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”
Section 26.51.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
Section 26.51.10, “The INFORMATION_SCHEMA INNODB_FIELDS Table”
Section 26.51.11, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”
Section 26.51.12, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”
Section 26.51.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 26.51.14, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
Section 26.51.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”
Section 26.51.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 26.51.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 26.51.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
Section 26.51.19, “The INFORMATION_SCHEMA INNODB_INDEXES Table”
Section 26.51.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”
Section 26.51.23, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”
Section 26.51.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”
Section 26.51.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
Section 26.51.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
Section 26.51.27, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”
Section 26.51.28, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”
Section 26.51.29, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 26.51.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”
Section 26.35, “The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table”

COLUMNS_EXTENSIONS

Section 26.9, “The INFORMATION_SCHEMA COLUMNS_EXTENSIONS Table”

CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS

Section 6.4.2.1, “Connection-Control Plugin Installation”
Section 6.4.2.2, “Connection-Control System and Status Variables”
Section 6.4.2, “The Connection-Control Plugins”
Section 26.53.1, “The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table”

E

[index top]

ENABLED_ROLES

Section 26.12, “The INFORMATION_SCHEMA ENABLED_ROLES Table”

ENGINES

Section 23.5.16, “Quick Reference: NDB Cluster SQL Statements”
Section 5.1.8, “Server System Variables”
Section 13.7.7.16, “SHOW ENGINES Statement”
Section 26.13, “The INFORMATION_SCHEMA ENGINES Table”

EVENTS

Section 17.1.2.8, “Adding Replicas to a Replication Environment”
Section 25.4.4, “Event Metadata”
Section 25.4.2, “Event Scheduler Configuration”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.5.1.16, “Replication of Invoked Features”
Section 17.1.2.6.2, “Setting Up Replication with Existing Data”
Section 13.7.7.18, “SHOW EVENTS Statement”
Section 26.14, “The INFORMATION_SCHEMA EVENTS Table”

F

[index top]

FILES

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 23.5.15, “INFORMATION_SCHEMA Tables for NDB Cluster”
Section 23.5.10.1, “NDB Cluster Disk Data Objects”
Section 23.5.14, “ndbinfo: The NDB Cluster Information Database”
Section 6.2.2, “Privileges Provided by MySQL”
Section 26.15, “The INFORMATION_SCHEMA FILES Table”
Section 26.51.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
Section 26.51.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
Section 26.40, “The INFORMATION_SCHEMA TABLESPACES Table”

I

[index top]

INFORMATION_SCHEMA

Section 2.11.4, “Changes in MySQL 8.0”
Section 14.1, “Data Dictionary Schema”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 23.5.15, “INFORMATION_SCHEMA Tables for NDB Cluster”
Section 15.15, “InnoDB INFORMATION_SCHEMA Tables”
Chapter 14, MySQL Data Dictionary
MySQL Glossary
Section 6.2.9, “Reserved Accounts”
Section 5.2, “The MySQL Data Directory”
Section 28.2, “Using the sys Schema”
Section 1.3, “What Is New in MySQL 8.0”

INFORMATION_SCHEMA.CHARACTER_SETS

Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”

INFORMATION_SCHEMA.COLLATIONS

Section 10.14.2, “Choosing a Collation ID”
Section 8.9.6, “Optimizer Statistics”

INFORMATION_SCHEMA.COLUMN_STATISTICS

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 8.9, “Controlling the Query Optimizer”
Section 8.9.6, “Optimizer Statistics”

INFORMATION_SCHEMA.COLUMNS

Section 13.1.20.10, “Invisible Columns”
Section 23.4.14, “ndb_index_stat — NDB Index Statistics Utility”
Section 27.1, “Performance Schema Quick Start”
Section 5.1.8, “Server System Variables”
Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”

INFORMATION_SCHEMA.ENGINES

Section 27.1, “Performance Schema Quick Start”
Section 23.5.16, “Quick Reference: NDB Cluster SQL Statements”
Section 15.1.3, “Verifying that InnoDB is the Default Storage Engine”

INFORMATION_SCHEMA.EVENTS

Section 25.4.4, “Event Metadata”
Section 17.5.1.16, “Replication of Invoked Features”
Section 25.8, “Restrictions on Stored Programs”
Section 25.4.6, “The Event Scheduler and MySQL Privileges”

INFORMATION_SCHEMA.FILES

Section 13.1.6, “ALTER LOGFILE GROUP Statement”
Section 13.1.10, “ALTER TABLESPACE Statement”
Section 2.11.4, “Changes in MySQL 8.0”
Section 5.6.7.3, “Cloning Remote Data”
Section 13.1.16, “CREATE LOGFILE GROUP Statement”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 15.6.3.6, “Moving Tablespace Files While the Server is Offline”
Section 23.5.10.2, “NDB Cluster Disk Data Storage Requirements”
Section 23.4.9, “ndb_desc — Describe NDB Tables”
Section 15.15.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 15.6.3.5, “Temporary Tablespaces”
Section 23.5.14.21, “The ndbinfo dict_obj_info Table”
Section 23.5.14.22, “The ndbinfo dict_obj_tree Table”
Section 23.5.14.33, “The ndbinfo logbuffers Table”
Section 23.5.14.34, “The ndbinfo logspaces Table”
Section 15.6.3.4, “Undo Tablespaces”
Section 23.1.4, “What is New in NDB Cluster”

INFORMATION_SCHEMA.INNODB_BUFFER_PAGE

Section 15.5.2, “Change Buffer”

INFORMATION_SCHEMA.INNODB_CACHED_INDEXES

Section 1.3, “What Is New in MySQL 8.0”

INFORMATION_SCHEMA.INNODB_CMP

MySQL Glossary
Section 15.9.1.3, “Tuning Compression for InnoDB Tables”
Section 15.15.1.3, “Using the Compression Information Schema Tables”

INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.9.1.3, “Tuning Compression for InnoDB Tables”

INFORMATION_SCHEMA.INNODB_CMPMEM

Section 15.15.1.3, “Using the Compression Information Schema Tables”

INFORMATION_SCHEMA.INNODB_COLUMNS

Section 15.12.1, “Online DDL Operations”

INFORMATION_SCHEMA.INNODB_DATAFILES

Section 2.11.4, “Changes in MySQL 8.0”

INFORMATION_SCHEMA.INNODB_FT_CONFIG

Section 15.6.2.4, “InnoDB FULLTEXT Indexes”

INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD

Section 12.10.4, “Full-Text Stopwords”

INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE

Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 12.10.9, “MeCab Full-Text Parser Plugin”
Section 12.10.8, “ngram Full-Text Parser”

INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE

Section 12.10.4, “Full-Text Stopwords”

INFORMATION_SCHEMA.INNODB_INDEXES

Section 15.6.2.4, “InnoDB FULLTEXT Indexes”

INFORMATION_SCHEMA.INNODB_METRICS

Section 15.5.2, “Change Buffer”
Section 15.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.6.3.4, “Undo Tablespaces”

INFORMATION_SCHEMA.INNODB_TABLES

Section 24.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 15.10, “InnoDB Row Formats”
Section 15.12.1, “Online DDL Operations”

INFORMATION_SCHEMA.INNODB_TABLESPACES

Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 15.9.2, “InnoDB Page Compression”
Section 15.6.3.9, “Tablespace AUTOEXTEND_SIZE Configuration”
Section 15.6.3.4, “Undo Tablespaces”
Section 1.3, “What Is New in MySQL 8.0”

INFORMATION_SCHEMA.INNODB_TABLESPACES_BRIEF

Section 1.3, “What Is New in MySQL 8.0”

INFORMATION_SCHEMA.INNODB_TABLESTATS

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”

INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO

Section 15.6.3.5, “Temporary Tablespaces”

INFORMATION_SCHEMA.INNODB_TRX

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.7.6, “Transaction Scheduling”

INFORMATION_SCHEMA.KEY_COLUMN_USAGE

Section 1.7.3.2, “FOREIGN KEY Constraints”
Section 13.1.20.5, “FOREIGN KEY Constraints”

INFORMATION_SCHEMA.MYSQL_FIREWALL_USERS

Section 6.4.7.4, “MySQL Enterprise Firewall Reference”

INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST

Section 6.4.7.4, “MySQL Enterprise Firewall Reference”

INFORMATION_SCHEMA.OPTIMIZER_TRACE

Section 8.2.1.2, “Range Optimization”

INFORMATION_SCHEMA.PARTITIONS

Section 24.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 24.2.7, “How MySQL Partitioning Handles NULL”
Section 24.2.5, “KEY Partitioning”
Section 24.3.5, “Obtaining Information About Partitions”
Section 24.2.3.1, “RANGE COLUMNS partitioning”

INFORMATION_SCHEMA.PLUGINS

Section 5.6.7.3, “Cloning Remote Data”
Section 6.4.2.1, “Connection-Control Plugin Installation”
Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 5.6.5.1, “Installing or Uninstalling ddl_rewriter”
Section 6.4.5.2, “Installing or Uninstalling MySQL Enterprise Audit”
Section 5.6.7.1, “Installing the Clone Plugin”
Section 6.4.4.1, “Keyring Plugin Installation”
Section 6.4.1.7, “LDAP Pluggable Authentication”
Section A.2, “MySQL 8.0 FAQ: Storage Engines”
Section 6.4.1.8, “No-Login Pluggable Authentication”
Section 5.6.2, “Obtaining Server Plugin Information”
Section 6.4.1.5, “PAM Pluggable Authentication”
Section 23.5.16, “Quick Reference: NDB Cluster SQL Statements”
Section 17.4.10.2, “Semisynchronous Replication Installation and Configuration”
Section 6.4.1.9, “Socket Peer-Credential Pluggable Authentication”
Section 6.4.1.10, “Test Pluggable Authentication”
Section 5.6.3.2, “Thread Pool Installation”
Section 1.3, “What Is New in MySQL 8.0”
Section 6.4.1.6, “Windows Pluggable Authentication”

INFORMATION_SCHEMA.PROCESSLIST

Section 12.16, “Information Functions”
Section 27.6, “Performance Schema Instrument Naming Conventions”
Section 27.12.5, “Performance Schema Stage Event Tables”
Section 6.2.2, “Privileges Provided by MySQL”

INFORMATION_SCHEMA.RESOURCE_GROUPS

Section 5.1.16, “Resource Groups”

INFORMATION_SCHEMA.ROUTINES

Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”
Section 6.2.2, “Privileges Provided by MySQL”
Section 25.2.2, “Stored Routines and MySQL Privileges”

INFORMATION_SCHEMA.SCHEMATA

Section 10.3.3, “Database Character Set and Collation”
Section 15.13, “InnoDB Data-at-Rest Encryption”

INFORMATION_SCHEMA.STATISTICS

Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 8.9.4, “Index Hints”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.3.12, “Invisible Indexes”
Section 23.4.14, “ndb_index_stat — NDB Index Statistics Utility”
Section 5.3, “The mysql System Schema”

INFORMATION_SCHEMA.TABLE_CONSTRAINTS

Section 15.12.1, “Online DDL Operations”

INFORMATION_SCHEMA.TABLES

Section 23.5.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 13.1.9, “ALTER TABLE Statement”
Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 15.9.2, “InnoDB Page Compression”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 14.2, “Removal of File-based Metadata Storage”
Section 28.4.4.2, “The diagnostics() Procedure”
Section 28.4.2.1, “The sys_config Table”
Section 5.6.3.2, “Thread Pool Installation”

INFORMATION_SCHEMA.TRIGGERS

Section A.5, “MySQL 8.0 FAQ: Triggers”

INFORMATION_SCHEMA.USER_ATTRIBUTES

Section 13.7.1.1, “ALTER USER Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 1.3, “What Is New in MySQL 8.0”

INFORMATION_SCHEMA.VIEWS

Section 2.11.5, “Preparing Your Installation for Upgrade”
Section 25.5.3, “Updatable and Insertable Views”

INNODB_BUFFER_PAGE

Section 15.5.2, “Change Buffer”
Section 15.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 28.1, “Prerequisites for Using the sys Schema”
Section 26.51.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 26.51.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 28.4.3.7, “The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views”
Section 28.4.3.8, “The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views”

INNODB_BUFFER_PAGE_LRU

Section 15.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 15.8.3.6, “Saving and Restoring the Buffer Pool State”
Section 26.51.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”

INNODB_BUFFER_POOL_STATS

Section 15.5.1, “Buffer Pool”
Section 15.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 26.51.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”

INNODB_CACHED_INDEXES

Section 26.51.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”

INNODB_CMP

Section 15.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 15.15.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 15.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime”
Section 26.51.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 15.15.1.3, “Using the Compression Information Schema Tables”

INNODB_CMP_PER_INDEX

Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime”
Section 26.51.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 15.15.1.3, “Using the Compression Information Schema Tables”

INNODB_CMP_PER_INDEX_RESET

Section 26.51.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”

INNODB_CMP_RESET

Section 15.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 15.15.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 15.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 26.51.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”

INNODB_CMPMEM

Section 15.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 15.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 26.51.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 15.15.1.3, “Using the Compression Information Schema Tables”

INNODB_CMPMEM_RESET

Section 15.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 15.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 26.51.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”

INNODB_COLUMNS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 26.51.8, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”
Section 26.51.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”

INNODB_DATAFILES

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 15.15.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 26.15, “The INFORMATION_SCHEMA FILES Table”
Section 26.51.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
Section 26.51.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
Section 26.40, “The INFORMATION_SCHEMA TABLESPACES Table”

INNODB_FIELDS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 26.51.10, “The INFORMATION_SCHEMA INNODB_FIELDS Table”

INNODB_FOREIGN

Section 1.7.3.2, “FOREIGN KEY Constraints”
Section 13.1.20.5, “FOREIGN KEY Constraints”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 26.51.11, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”

INNODB_FOREIGN_COLS

Section 1.7.3.2, “FOREIGN KEY Constraints”
Section 13.1.20.5, “FOREIGN KEY Constraints”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 26.51.12, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”

INNODB_FT_BEING_DELETED

Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 26.51.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”

INNODB_FT_CONFIG

Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 26.51.14, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”

INNODB_FT_DEFAULT_STOPWORD

Section 12.10.4, “Full-Text Stopwords”
Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 26.51.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”

INNODB_FT_DELETED

Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 26.51.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 26.51.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”

INNODB_FT_INDEX_CACHE

Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 26.51.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”

INNODB_FT_INDEX_TABLE

Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 26.51.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 26.51.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 26.51.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”

INNODB_INDEXES

Section 15.8.11, “Configuring the Merge Threshold for Index Pages”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 26.51.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
Section 26.51.19, “The INFORMATION_SCHEMA INNODB_INDEXES Table”

INNODB_LOCK_WAITS

Section 15.15.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 15.15.2.2, “InnoDB Lock and Lock-Wait Information”
Section 15.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 26.51.21, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 15.15.2.1, “Using InnoDB Transaction and Locking Information”
Section 1.3, “What Is New in MySQL 8.0”

INNODB_LOCKS

Section 15.15.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 15.15.2.2, “InnoDB Lock and Lock-Wait Information”
Section 15.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 26.51.20, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 15.15.2.1, “Using InnoDB Transaction and Locking Information”
Section 1.3, “What Is New in MySQL 8.0”

INNODB_METRICS

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 15.5.2, “Change Buffer”
Section 15.8.11, “Configuring the Merge Threshold for Index Pages”
Section 15.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
MySQL Glossary
Section 26.51.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”
Section 28.4.3.21, “The metrics View”
Section 15.7.6, “Transaction Scheduling”
Section 1.3, “What Is New in MySQL 8.0”

INNODB_SESSION_TEMP_TABLESPACES

Section 15.6.3.5, “Temporary Tablespaces”
Section 26.51.23, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”
Section 1.3, “What Is New in MySQL 8.0”

INNODB_TABLES

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 26.51.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
Section 26.51.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”
Section 1.3, “What Is New in MySQL 8.0”

INNODB_TABLESPACES

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 15.15.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 13.7.7.38, “SHOW TABLE STATUS Statement”
Section 26.15, “The INFORMATION_SCHEMA FILES Table”
Section 26.51.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
Section 26.51.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
Section 26.38, “The INFORMATION_SCHEMA TABLES Table”
Section 26.40, “The INFORMATION_SCHEMA TABLESPACES Table”
Section 1.3, “What Is New in MySQL 8.0”

INNODB_TABLESPACES_BRIEF

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 26.51.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”

INNODB_TABLESTATS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 26.51.27, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”

INNODB_TEMP_TABLE_INFO

Section 15.15.7, “InnoDB INFORMATION_SCHEMA Temporary Table Info Table”
Section 26.51.28, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”

INNODB_TRX

Section 15.15.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 15.15.2.2, “InnoDB Lock and Lock-Wait Information”
Section 15.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 27.12.13.1, “The data_locks Table”
Section 26.51.29, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 15.15.2.1, “Using InnoDB Transaction and Locking Information”

INNODB_VIRTUAL

Section 26.51.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”

K

[index top]

KEY_COLUMN_USAGE

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 26.16, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”
Section 5.3, “The mysql System Schema”

KEYWORDS

Section 26.18, “The INFORMATION_SCHEMA KEYWORDS Table”

M

[index top]

MYSQL_FIREWALL_USERS

Section 26.54.1, “The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table”

MYSQL_FIREWALL_WHITELIST

Section 26.54.2, “The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table”

N

[index top]

NDB_TRANSID_MYSQL_CONNECTION_MAP

Section 23.5.14.45, “The ndbinfo server_operations Table”
Section 23.5.14.46, “The ndbinfo server_transactions Table”

ndb_transid_mysql_connection_map

Section 23.5.15, “INFORMATION_SCHEMA Tables for NDB Cluster”
Section 23.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 23.5.14, “ndbinfo: The NDB Cluster Information Database”

O

[index top]

OPTIMIZER_TRACE

Section 26.19, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”

P

[index top]

PARAMETERS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”
Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”
Section 26.20, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 26.30, “The INFORMATION_SCHEMA ROUTINES Table”

PARTITIONS

Section 24.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 24.2.7, “How MySQL Partitioning Handles NULL”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 24.3.5, “Obtaining Information About Partitions”
Chapter 24, Partitioning
Section 13.7.7.38, “SHOW TABLE STATUS Statement”
Section 26.21, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 26.38, “The INFORMATION_SCHEMA TABLES Table”

PLUGINS

Section 13.7.4.4, “INSTALL PLUGIN Statement”
Section 5.6.2, “Obtaining Server Plugin Information”
Section 23.5.16, “Quick Reference: NDB Cluster SQL Statements”
Section 26.22, “The INFORMATION_SCHEMA PLUGINS Table”

PROCESSLIST

Section 8.14.1, “Accessing the Process List”
Section 13.7.8.4, “KILL Statement”
Section 8.8.4, “Obtaining Execution Plan Information for a Named Connection”
Section 27.12.11, “Performance Schema Replication Tables”
Section 15.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 13.7.7.29, “SHOW PROCESSLIST Statement”
Section 5.6.7.10, “Stopping a Cloning Operation”
Section 27.12.19.1, “The error_log Table”
Section 26.51.29, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 26.23, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 28.4.3.22, “The processlist and x$processlist Views”
Section 27.12.19.9, “The processlist Table”
Section 27.12.19.10, “The threads Table”
Section 15.15.2.1, “Using InnoDB Transaction and Locking Information”

PROFILING

Section 13.7.7.30, “SHOW PROFILE Statement”
Section 26.24, “The INFORMATION_SCHEMA PROFILING Table”

R

[index top]

REFERENTIAL_CONSTRAINTS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 26.25, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”
Section 5.3, “The mysql System Schema”

RESOURCE_GROUPS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 5.1.16, “Resource Groups”
Section 26.26, “The INFORMATION_SCHEMA RESOURCE_GROUPS Table”

ROLE_COLUMN_GRANTS

Section 26.27, “The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table”

ROLE_ROUTINE_GRANTS

Section 26.28, “The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table”

ROLE_TABLE_GRANTS

Section 26.29, “The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table”

ROUTINES

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 26.1, “Introduction”
Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”
Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”
Section 25.6, “Stored Object Access Control”
Section 25.2.3, “Stored Routine Metadata”
Section 26.30, “The INFORMATION_SCHEMA ROUTINES Table”

S

[index top]

SCHEMA_PRIVILEGES

Section 26.33, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”

SCHEMATA

Section 6.2.3, “Grant Tables”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.8, “Server System Variables”
Section 13.7.7.14, “SHOW DATABASES Statement”
Section 26.31, “The INFORMATION_SCHEMA SCHEMATA Table”
Section 26.32, “The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table”

SCHEMATA_EXTENSIONS

Section 13.1.2, “ALTER DATABASE Statement”
Section 26.31, “The INFORMATION_SCHEMA SCHEMATA Table”
Section 26.32, “The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table”

ST_GEOMETRY_COLUMNS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 26.8, “The INFORMATION_SCHEMA COLUMNS Table”
Section 26.35, “The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table”

ST_SPATIAL_REFERENCE_SYSTEMS

Section 13.1.19, “CREATE SPATIAL REFERENCE SYSTEM Statement”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 11.4.5, “Spatial Reference System Support”
Section 26.36, “The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table”

ST_UNITS_OF_MEASURE

Section 12.17.7.3, “LineString and MultiLineString Property Functions”
Section 12.17.9.1, “Spatial Relation Functions That Use Object Shapes”
Section 26.37, “The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table”

STATISTICS

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 14.7, “Data Dictionary Usage Differences”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 13.7.7.22, “SHOW INDEX Statement”
Section 26.34, “The INFORMATION_SCHEMA STATISTICS Table”

T

[index top]

TABLE_CONSTRAINTS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 26.25, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”
Section 26.42, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

TABLE_CONSTRAINTS_EXTENSIONS

Section 26.43, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table”

TABLE_PRIVILEGES

Section 26.44, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

TABLES

Section 13.1.20, “CREATE TABLE Statement”
Section 14.7, “Data Dictionary Usage Differences”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 26.1, “Introduction”
Section 13.1.20.11, “Setting NDB_TABLE Options”
Section 13.7.7.38, “SHOW TABLE STATUS Statement”
Section 13.7.7.39, “SHOW TABLES Statement”
Section 26.38, “The INFORMATION_SCHEMA TABLES Table”

TABLES_EXTENSIONS

Section 26.39, “The INFORMATION_SCHEMA TABLES_EXTENSIONS Table”

TABLESPACES_EXTENSIONS

Section 26.41, “The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table”

TP_THREAD_GROUP_STATE

Section 26.52, “INFORMATION_SCHEMA Thread Pool Tables”

TP_THREAD_GROUP_STATS

Section 26.52, “INFORMATION_SCHEMA Thread Pool Tables”

TP_THREAD_STATE

Section 26.52, “INFORMATION_SCHEMA Thread Pool Tables”
Section 5.6.3.2, “Thread Pool Installation”

TRIGGERS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 2.11.5, “Preparing Your Installation for Upgrade”
Section 13.7.7.11, “SHOW CREATE TRIGGER Statement”
Section 13.7.7.40, “SHOW TRIGGERS Statement”
Section 26.45, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 25.3.2, “Trigger Metadata”

U

[index top]

USER_ATTRIBUTES

Section 13.7.1.1, “ALTER USER Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 26.46, “The INFORMATION_SCHEMA USER_ATTRIBUTES Table”

USER_PRIVILEGES

Section 6.2.2, “Privileges Provided by MySQL”
Section 26.47, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

V

[index top]

VIEW_ROUTINE_USAGE

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 26.49, “The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table”

VIEW_TABLE_USAGE

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 26.50, “The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table”

VIEWS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 13.7.7.13, “SHOW CREATE VIEW Statement”
Section 26.48, “The INFORMATION_SCHEMA VIEWS Table”
Section 25.5.5, “View Metadata”