INFORMATION_SCHEMA Index

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

C

[index top]

CHARACTER_SETS

Section 10.2, “Character Sets and Collations in MySQL”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 13.7.6.3, “SHOW CHARACTER SET Syntax”
Section 10.10, “Supported Character Sets and Collations”
Section 24.1, “The INFORMATION_SCHEMA CHARACTER_SETS Table”

COLLATION_CHARACTER_SET_APPLICABILITY

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

COLLATIONS

Section 27.7.5, “C API Data Structures”
Section 10.2, “Character Sets and Collations in MySQL”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 13.7.6.4, “SHOW COLLATION Syntax”
Section 10.8.5, “The binary Collation Compared to _bin Collations”
Section 11.4.1, “The CHAR and VARCHAR Types”
Section 24.2, “The INFORMATION_SCHEMA COLLATIONS Table”
Section 10.10.1, “Unicode Character Sets”

COLUMN_PRIVILEGES

Section 24.5, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

COLUMN_STATISTICS

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

COLUMNS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 13.7.6.5, “SHOW COLUMNS Syntax”
Section 24.4, “The INFORMATION_SCHEMA COLUMNS Table”
Section 24.13, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 24.20, “The INFORMATION_SCHEMA ROUTINES Table”
Section 24.24, “The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table”

CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS

Section 6.5.2.1, “Connection-Control Plugin Installation”
Section 6.5.2.2, “Connection-Control System and Status Variables”
Section 6.5.2, “The Connection-Control Plugins”
Section 24.35.1, “The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table”

E

[index top]

ENGINES

Section 5.1.7, “Server System Variables”
Section 13.7.6.16, “SHOW ENGINES Syntax”
Section 24.7, “The INFORMATION_SCHEMA ENGINES Table”

EVENTS

Section 23.4.4, “Event Metadata”
Section 23.4.2, “Event Scheduler Configuration”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.4.1.16, “Replication of Invoked Features”
Section 24.8, “The INFORMATION_SCHEMA EVENTS Table”

F

[index top]

FILES

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 24.9, “The INFORMATION_SCHEMA FILES Table”

I

[index top]

INFORMATION_SCHEMA

Section 2.10.1.2, “Changes Affecting Upgrades to MySQL 8.0”
Section 14.1, “Data Dictionary Schema”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.14, “InnoDB INFORMATION_SCHEMA Tables”
Chapter 14, MySQL Data Dictionary
MySQL Glossary
Section 6.3.5, “Reserved User Accounts”
Section B.3, “Server Error Codes and Messages”
Section 5.2, “The MySQL Data Directory”
Section 26.2, “Using the sys Schema”
Section 1.4, “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.13.2, “Choosing a Collation ID”
Section 8.9.6, “Optimizer Statistics”

INFORMATION_SCHEMA.COLUMN_STATISTICS

Section 8.9.6, “Optimizer Statistics”

INFORMATION_SCHEMA.COLUMNS

Section 25.1, “Performance Schema Quick Start”
Section 5.1.7, “Server System Variables”

INFORMATION_SCHEMA.ENGINES

Section 25.1, “Performance Schema Quick Start”
Section 15.1.3, “Verifying that InnoDB is the Default Storage Engine”

INFORMATION_SCHEMA.EVENTS

Section 23.4.4, “Event Metadata”
Section 17.4.1.16, “Replication of Invoked Features”
Section C.1, “Restrictions on Stored Programs”
Section 13.7.6.18, “SHOW EVENTS Syntax”
Section 23.4.6, “The Event Scheduler and MySQL Privileges”

INFORMATION_SCHEMA.FILES

Section 2.10.1.2, “Changes Affecting Upgrades to MySQL 8.0”
Section 15.7.7, “Moving Tablespace Files While the Server is Offline”
Section 15.14.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 15.4.11, “Temporary Tablespace”
Section 24.9, “The INFORMATION_SCHEMA FILES Table”
Section 24.33.18, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
Section 24.33.24, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
Section 24.27, “The INFORMATION_SCHEMA TABLESPACES Table”

INFORMATION_SCHEMA.INNODB_BUFFER_PAGE

Section 15.4.2, “Change Buffer”

INFORMATION_SCHEMA.INNODB_CACHED_INDEXES

Section 1.4, “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.14.1.3, “Using the Compression Information Schema Tables”

INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX

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

INFORMATION_SCHEMA.INNODB_CMPMEM

Section 15.14.1.3, “Using the Compression Information Schema Tables”

INFORMATION_SCHEMA.INNODB_DATAFILES

Section 24.9, “The INFORMATION_SCHEMA FILES Table”

INFORMATION_SCHEMA.INNODB_FT_CONFIG

Section 15.8.2.4, “InnoDB FULLTEXT Indexes”

INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD

Section 12.9.4, “Full-Text Stopwords”

INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE

Section 15.8.2.4, “InnoDB FULLTEXT Indexes”
Section 12.9.9, “MeCab Full-Text Parser Plugin”
Section 12.9.8, “ngram Full-Text Parser”

INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE

Section 12.9.4, “Full-Text Stopwords”

INFORMATION_SCHEMA.INNODB_INDEXES

Section 15.8.2.4, “InnoDB FULLTEXT Indexes”

INFORMATION_SCHEMA.INNODB_METRICS

Section 15.4.2, “Change Buffer”
Section 15.13, “InnoDB Startup Options and System Variables”

INFORMATION_SCHEMA.INNODB_TABLES

Section 15.7.10, “InnoDB General Tablespaces”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 15.8.1.2, “The Physical Row Structure of an InnoDB Table”

INFORMATION_SCHEMA.INNODB_TABLESPACES

Section 15.7.10, “InnoDB General Tablespaces”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 15.9.2, “InnoDB Page Compression”

INFORMATION_SCHEMA.INNODB_TABLESPACES_BRIEF

Section 1.4, “What Is New in MySQL 8.0”

INFORMATION_SCHEMA.INNODB_TABLESTATS

Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”

INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO

Section 15.13, “InnoDB Startup Options and System Variables”
Section 15.4.11, “Temporary Tablespace”

INFORMATION_SCHEMA.INNODB_TRX

Section 15.13, “InnoDB Startup Options and System Variables”

INFORMATION_SCHEMA.KEY_COLUMN_USAGE

Section 1.8.3.2, “FOREIGN KEY Constraints”
Section 15.8.1.6, “InnoDB and FOREIGN KEY Constraints”
Section 13.1.18.6, “Using FOREIGN KEY Constraints”

INFORMATION_SCHEMA.OPTIMIZER_TRACE

Section 8.2.1.2, “Range Optimization”

INFORMATION_SCHEMA.PARTITIONS

Section 22.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 22.2.7, “How MySQL Partitioning Handles NULL”
Section 22.2.5, “KEY Partitioning”
Section 22.3.5, “Obtaining Information About Partitions”
Section 22.2.3.1, “RANGE COLUMNS partitioning”
Section 24.14, “The INFORMATION_SCHEMA PARTITIONS Table”

INFORMATION_SCHEMA.PLUGINS

Section 6.5.2.1, “Connection-Control Plugin Installation”
Section 15.7.11, “InnoDB Tablespace Encryption”
Section 13.7.4.4, “INSTALL PLUGIN Syntax”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 6.5.5.2, “Installing or Uninstalling MySQL Enterprise Audit”
Section 6.5.4.1, “Keyring Plugin Installation”
Section 6.5.1.7, “LDAP Pluggable Authentication”
Section A.2, “MySQL 8.0 FAQ: Storage Engines”
Section 6.5.1.8, “No-Login Pluggable Authentication”
Section 5.6.2, “Obtaining Server Plugin Information”
Section 6.5.1.5, “PAM Pluggable Authentication”
Section 28.2.2, “Plugin API Characteristics”
Section 28.2.3, “Plugin API Components”
Section 17.3.10.2, “Semisynchronous Replication Installation and Configuration”
Section 28.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 6.5.1.9, “Socket Peer-Credential Pluggable Authentication”
Section 6.5.1.10, “Test Pluggable Authentication”
Section 5.6.3.2, “Thread Pool Installation”
Section 1.4, “What Is New in MySQL 8.0”
Section 6.5.1.6, “Windows Pluggable Authentication”
Section 28.2.4.8, “Writing Audit Plugins”
Section 28.2.4.5, “Writing Daemon Plugins”
Section 28.2.4.4, “Writing Full-Text Parser Plugins”
Section 28.2.4.6, “Writing INFORMATION_SCHEMA Plugins”
Section 28.2.4.12, “Writing Keyring Plugins”
Section 28.2.4.10, “Writing Password-Validation Plugins”
Section 28.2.4.9.1, “Writing the Server-Side Authentication Plugin”

INFORMATION_SCHEMA.PROCESSLIST

Section 8.14, “Examining Thread Information”
Section 12.14, “Information Functions”
Section 13.7.7.4, “KILL Syntax”
Section 25.6, “Performance Schema Instrument Naming Conventions”
Section 25.11.5, “Performance Schema Stage Event Tables”
Section 13.7.6.29, “SHOW PROCESSLIST Syntax”
Section 24.16, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 25.11.16.3, “The threads Table”

INFORMATION_SCHEMA.RESOURCE_GROUPS

Section 8.12.5, “Resource Groups”

INFORMATION_SCHEMA.ROUTINES

Chapter 24, INFORMATION_SCHEMA Tables
Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”

INFORMATION_SCHEMA.SCHEMATA

Section 10.3.3, “Database Character Set and Collation”

INFORMATION_SCHEMA.STATISTICS

Section 13.7.3.1, “ANALYZE TABLE Syntax”
Section 15.6.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 8.9.4, “Index Hints”
Section 15.13, “InnoDB Startup Options and System Variables”
Section 8.3.12, “Invisible Indexes”
Section 5.3, “The mysql System Database”

INFORMATION_SCHEMA.TABLE_CONSTRAINTS

Section 15.12.1, “Online DDL Overview”
Section 24.18, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

INFORMATION_SCHEMA.TABLES

Section 13.1.8, “ALTER TABLE Syntax”
Section 15.6.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Chapter 24, INFORMATION_SCHEMA Tables
Section 15.13, “InnoDB Startup Options and System Variables”
Section 15.7.11, “InnoDB Tablespace Encryption”
Section 14.2, “Removal of File-based Metadata Storage”
Section 15.10.2, “Specifying the Row Format for a Table”
Section 26.4.4.2, “The diagnostics() Procedure”
Section 26.4.2.1, “The sys_config Table”

INFORMATION_SCHEMA.TRIGGERS

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

INFORMATION_SCHEMA.VIEWS

Section 23.5.3, “Updatable and Insertable Views”

INNODB_BUFFER_PAGE

Section 15.4.2, “Change Buffer”
Section 15.14.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 26.1, “Prerequisites for Using the sys Schema”
Section 24.33.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 26.4.3.7, “The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views”
Section 26.4.3.8, “The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views”

INNODB_BUFFER_PAGE_LRU

Section 15.14.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 15.6.3.8, “Saving and Restoring the Buffer Pool State”
Section 24.33.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”

INNODB_BUFFER_POOL_STATS

Section 15.14.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 15.6.3.9, “Monitoring the Buffer Pool Using the InnoDB Standard Monitor”

INNODB_CMP

Section 15.14.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 15.14.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 15.14.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime”
Section 15.14.1.3, “Using the Compression Information Schema Tables”

INNODB_CMP_PER_INDEX

Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime”
Section 15.14.1.3, “Using the Compression Information Schema Tables”

INNODB_CMP_RESET

Section 15.14.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 15.14.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 15.14.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”

INNODB_CMPMEM

Section 15.14.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 15.14.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 15.14.1.3, “Using the Compression Information Schema Tables”

INNODB_CMPMEM_RESET

Section 15.14.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”

INNODB_COLUMNS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 24.33.27, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”

INNODB_DATAFILES

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 15.14.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 24.9, “The INFORMATION_SCHEMA FILES Table”
Section 24.33.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
Section 24.27, “The INFORMATION_SCHEMA TABLESPACES Table”

INNODB_FIELDS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”

INNODB_FOREIGN

Section 1.8.3.2, “FOREIGN KEY Constraints”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.8.1.6, “InnoDB and FOREIGN KEY Constraints”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 13.1.18.6, “Using FOREIGN KEY Constraints”

INNODB_FOREIGN_COLS

Section 1.8.3.2, “FOREIGN KEY Constraints”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.8.1.6, “InnoDB and FOREIGN KEY Constraints”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 13.1.18.6, “Using FOREIGN KEY Constraints”

INNODB_FT_BEING_DELETED

Section 15.8.2.4, “InnoDB FULLTEXT Indexes”
Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.13, “InnoDB Startup Options and System Variables”

INNODB_FT_CONFIG

Section 15.8.2.4, “InnoDB FULLTEXT Indexes”
Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.13, “InnoDB Startup Options and System Variables”

INNODB_FT_DEFAULT_STOPWORD

Section 12.9.4, “Full-Text Stopwords”
Section 15.8.2.4, “InnoDB FULLTEXT Indexes”
Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”

INNODB_FT_DELETED

Section 15.8.2.4, “InnoDB FULLTEXT Indexes”
Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.13, “InnoDB Startup Options and System Variables”
Section 24.33.8, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”

INNODB_FT_INDEX_CACHE

Section 15.8.2.4, “InnoDB FULLTEXT Indexes”
Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.13, “InnoDB Startup Options and System Variables”

INNODB_FT_INDEX_TABLE

Section 15.8.2.4, “InnoDB FULLTEXT Indexes”
Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.13, “InnoDB Startup Options and System Variables”

innodb_ft_index_table

Section 24.33.8, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 24.33.11, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”

INNODB_INDEXES

Section 15.6.12, “Configuring the Merge Threshold for Index Pages”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.8.2.4, “InnoDB FULLTEXT Indexes”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 24.33.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”

INNODB_LOCK_WAITS

Section 15.14.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 15.14.2.2, “InnoDB Lock and Lock-Wait Information”
Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 24.33.15, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”
Section 1.4, “What Is New in MySQL 8.0”

INNODB_LOCKS

Section 15.14.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 15.14.2.2, “InnoDB Lock and Lock-Wait Information”
Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 24.33.14, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”
Section 1.4, “What Is New in MySQL 8.0”

INNODB_METRICS

Section 15.4.2, “Change Buffer”
Section 15.6.12, “Configuring the Merge Threshold for Index Pages”
Section 15.14.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
MySQL Glossary
Section 26.4.3.21, “The metrics View”

INNODB_TABLES

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.8.2.4, “InnoDB FULLTEXT Indexes”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 24.33.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
Section 1.4, “What Is New in MySQL 8.0”

INNODB_TABLESPACES

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 15.14.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 24.9, “The INFORMATION_SCHEMA FILES Table”
Section 24.33.24, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
Section 24.33.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
Section 24.27, “The INFORMATION_SCHEMA TABLESPACES Table”
Section 1.4, “What Is New in MySQL 8.0”

INNODB_TABLESPACES_BRIEF

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”

INNODB_TABLESTATS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”

INNODB_TEMP_TABLE_INFO

Section 15.14.7, “InnoDB INFORMATION_SCHEMA Temporary Table Info Table”

INNODB_TRX

Section 15.14.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 15.14.2.2, “InnoDB Lock and Lock-Wait Information”
Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 25.11.12.1, “The data_locks Table”
Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”

K

[index top]

KEY_COLUMN_USAGE

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

KEYWORDS

Section 24.11, “The INFORMATION_SCHEMA KEYWORDS Table”

O

[index top]

OPTIMIZER_TRACE

Section 24.12, “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 24.13, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 24.20, “The INFORMATION_SCHEMA ROUTINES Table”

PARTITIONS

Section 22.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 22.2.7, “How MySQL Partitioning Handles NULL”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 22.3.5, “Obtaining Information About Partitions”
Chapter 22, Partitioning
Section 24.14, “The INFORMATION_SCHEMA PARTITIONS Table”

PLUGINS

Section 5.6.2, “Obtaining Server Plugin Information”
Section 24.15, “The INFORMATION_SCHEMA PLUGINS Table”

PROCESSLIST

Section 8.14, “Examining Thread Information”
Section 8.8.4, “Obtaining Execution Plan Information for a Named Connection”
Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 13.7.6.29, “SHOW PROCESSLIST Syntax”
Section 24.33.29, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 24.16, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 26.4.3.22, “The processlist and x$processlist Views”
Section 25.11.16.3, “The threads Table”
Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”

PROFILING

Section 13.7.6.30, “SHOW PROFILE Syntax”
Section 24.17, “The INFORMATION_SCHEMA PROFILING Table”

R

[index top]

REFERENTIAL_CONSTRAINTS

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

RESOURCE_GROUPS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 24.19, “The INFORMATION_SCHEMA RESOURCE_GROUPS Table”

ROUTINES

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”
Section 13.7.6.28, “SHOW PROCEDURE STATUS Syntax”
Section 23.2.3, “Stored Routine Metadata”
Section 24.13, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 24.20, “The INFORMATION_SCHEMA ROUTINES Table”

S

[index top]

SCHEMA_PRIVILEGES

Section 24.22, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”

SCHEMATA

Section 6.2.3, “Grant Tables”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 24.21, “The INFORMATION_SCHEMA SCHEMATA Table”

ST_GEOMETRY_COLUMNS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 24.4, “The INFORMATION_SCHEMA COLUMNS Table”
Section 24.24, “The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table”

ST_SPATIAL_REFERENCE_SYSTEMS

Section 13.1.17, “CREATE SPATIAL REFERENCE SYSTEM Syntax”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 11.5.5, “Spatial Reference System Support”
Section 24.25, “The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table”

STATISTICS

Section 14.7, “Data Dictionary Usage Differences”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 13.7.6.22, “SHOW INDEX Syntax”
Section 24.23, “The INFORMATION_SCHEMA STATISTICS Table”

T

[index top]

TABLE_CONSTRAINTS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 24.28, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

TABLE_PRIVILEGES

Section 24.29, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

TABLES

Section 14.7, “Data Dictionary Usage Differences”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Chapter 24, INFORMATION_SCHEMA Tables
Section 24.26, “The INFORMATION_SCHEMA TABLES Table”

TABLESPACES

Section 24.27, “The INFORMATION_SCHEMA TABLESPACES Table”

TP_THREAD_GROUP_STATE

Section 24.34.1, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 5.6.3.1, “Thread Pool Components”
Section 24.34, “Thread Pool INFORMATION_SCHEMA Tables”

TP_THREAD_GROUP_STATS

Section 24.34.3, “The INFORMATION_SCHEMA TP_THREAD_STATE Table”
Section 5.6.3.1, “Thread Pool Components”
Section 24.34, “Thread Pool INFORMATION_SCHEMA Tables”

TP_THREAD_STATE

Section 5.6.3.1, “Thread Pool Components”
Section 24.34, “Thread Pool INFORMATION_SCHEMA Tables”
Section 5.6.3.2, “Thread Pool Installation”

TRIGGERS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 2.10.1.1, “MySQL Upgrade Strategies”
Section 13.7.6.11, “SHOW CREATE TRIGGER Syntax”
Section 13.7.6.38, “SHOW TRIGGERS Syntax”
Section 24.30, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 23.3.2, “Trigger Metadata”

U

[index top]

USER_PRIVILEGES

Section 6.2.2, “Static Versus Dynamic Privileges”
Section 24.31, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

V

[index top]

VIEWS

Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 13.7.6.13, “SHOW CREATE VIEW Syntax”
Section 24.32, “The INFORMATION_SCHEMA VIEWS Table”
Section 23.5.5, “View Metadata”