MySQL :: MySQL 9.1 Reference Manual :: INFORMATION_SCHEMA Index

Skip to Main Content

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

version 9.1

9.0
8.4 current
8.0
5.7

MySQL 9.1 Reference Manual / Indexes / INFORMATION_SCHEMA Index

INFORMATION_SCHEMA Index

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

A

ADMINISTRABLE_ROLE_AUTHORIZATIONS

Section 28.3.2, “The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table”

APPLICABLE_ROLES

Section 28.3.3, “The INFORMATION_SCHEMA APPLICABLE_ROLES Table”

C

CHARACTER_SETS

Section 12.3.8, “Character Set Introducers”
Section 12.2, “Character Sets and Collations in MySQL”
Section 12.3.6, “Character String Literal Character Set and Collation”
Section 12.3.5, “Column Character Set and Collation”
Section 12.3.3, “Database Character Set and Collation”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.7.7.4, “SHOW CHARACTER SET Statement”
Section 12.10, “Supported Character Sets and Collations”
Section 12.3.4, “Table Character Set and Collation”
Section 28.3.4, “The INFORMATION_SCHEMA CHARACTER_SETS Table”

CHECK_CONSTRAINTS

Section 15.1.20.6, “CHECK Constraints”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 28.3.5, “The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table”

COLLATION_CHARACTER_SET_APPLICABILITY

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 10.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 28.3.7, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”

COLLATIONS

Section 12.15, “Character Set Configuration”
Section 12.2, “Character Sets and Collations in MySQL”
Section 12.14.2, “Choosing a Collation ID”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 10.9.6, “Optimizer Statistics”
Section 15.7.7.5, “SHOW COLLATION Statement”
Section 12.8.5, “The binary Collation Compared to _bin Collations”
Section 13.3.2, “The CHAR and VARCHAR Types”
Section 28.3.6, “The INFORMATION_SCHEMA COLLATIONS Table”
Section 12.10.1, “Unicode Character Sets”

COLUMN_PRIVILEGES

Section 28.3.10, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

COLUMN_STATISTICS

Section 15.7.3.1, “ANALYZE TABLE Statement”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 10.9.6, “Optimizer Statistics”
Section 28.3.11, “The INFORMATION_SCHEMA COLUMN_STATISTICS Table”

COLUMNS

Section 15.1.20, “CREATE TABLE Statement”
Section 15.1.20.11, “Generated Invisible Primary Keys”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 28.1, “Introduction”
Section 15.1.20.10, “Invisible Columns”
Section 15.7.7.6, “SHOW COLUMNS Statement”
Section 28.3.8, “The INFORMATION_SCHEMA COLUMNS Table”
Section 28.4.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 28.4.3, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 28.4.4, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”
Section 28.4.5, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
Section 28.4.6, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 28.4.8, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 28.4.7, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 28.4.9, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”
Section 28.4.10, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
Section 28.4.11, “The INFORMATION_SCHEMA INNODB_FIELDS Table”
Section 28.4.12, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”
Section 28.4.13, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”
Section 28.4.14, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 28.4.15, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
Section 28.4.16, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”
Section 28.4.17, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 28.4.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 28.4.19, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
Section 28.4.20, “The INFORMATION_SCHEMA INNODB_INDEXES Table”
Section 28.4.21, “The INFORMATION_SCHEMA INNODB_METRICS Table”
Section 28.4.22, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”
Section 28.4.23, “The INFORMATION_SCHEMA INNODB_TABLES Table”
Section 28.4.24, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
Section 28.4.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
Section 28.4.26, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”
Section 28.4.27, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”
Section 28.4.28, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 28.4.29, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”
Section 28.3.35, “The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table”
Section 3.7, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”

COLUMNS_EXTENSIONS

Section 28.3.9, “The INFORMATION_SCHEMA COLUMNS_EXTENSIONS Table”

CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS

Section 8.4.2.1, “Connection-Control Plugin Installation”
Section 8.4.2.2, “Connection-Control System and Status Variables”
Section 8.4.2, “The Connection-Control Plugins”
Section 28.6.2, “The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table”

E

ENABLED_ROLES

Section 28.3.12, “The INFORMATION_SCHEMA ENABLED_ROLES Table”

ENGINES

Section 29.1, “Performance Schema Quick Start”
Section 25.6.20, “Quick Reference: NDB Cluster SQL Statements”
Section 7.1.8, “Server System Variables”
Section 15.7.7.17, “SHOW ENGINES Statement”
Section 28.3.13, “The INFORMATION_SCHEMA ENGINES Table”
Section 17.1.3, “Verifying that InnoDB is the Default Storage Engine”

EVENTS

Section 19.1.2.8, “Adding Replicas to a Replication Environment”
Section 15.1.13, “CREATE EVENT Statement”
Section 27.5.4, “Event Metadata”
Section 27.5.2, “Event Scheduler Configuration”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 19.5.1.16, “Replication of Invoked Features”
Section 27.9, “Restrictions on Stored Programs”
Section 19.1.2.6.2, “Setting Up Replication with Existing Data”
Section 15.7.7.19, “SHOW EVENTS Statement”
Section 27.5.6, “The Event Scheduler and MySQL Privileges”
Section 28.3.14, “The INFORMATION_SCHEMA EVENTS Table”

F

FILES

Section 15.1.6, “ALTER LOGFILE GROUP Statement”
Section 15.1.10, “ALTER TABLESPACE Statement”
Section 7.6.7.3, “Cloning Remote Data”
Section 15.1.16, “CREATE LOGFILE GROUP Statement”
Section 15.1.21, “CREATE TABLESPACE Statement”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 25.6.18, “INFORMATION_SCHEMA Tables for NDB Cluster”
Section 17.6.3.6, “Moving Tablespace Files While the Server is Offline”
Section 25.6.11.1, “NDB Cluster Disk Data Objects”
Section 25.6.11.2, “NDB Cluster Disk Data Storage Requirements”
Section 25.5.9, “ndb_desc — Describe NDB Tables”
Section 25.6.17, “ndbinfo: The NDB Cluster Information Database”
Section 8.2.2, “Privileges Provided by MySQL”
Section 17.15.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 17.6.3.5, “Temporary Tablespaces”
Section 28.3.15, “The INFORMATION_SCHEMA FILES Table”
Section 28.4.10, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
Section 28.4.24, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
Section 25.6.17.25, “The ndbinfo dict_obj_info Table”
Section 25.6.17.26, “The ndbinfo dict_obj_tree Table”
Section 25.6.17.43, “The ndbinfo logbuffers Table”
Section 25.6.17.44, “The ndbinfo logspaces Table”
Section 17.6.3.4, “Undo Tablespaces”

I

INFORMATION_SCHEMA

Section 16.1, “Data Dictionary Schema”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 25.6.18, “INFORMATION_SCHEMA Tables for NDB Cluster”
Section 17.15, “InnoDB INFORMATION_SCHEMA Tables”
Chapter 16, MySQL Data Dictionary
MySQL Glossary
Section 25.6.21.2, “NDB Cluster and MySQL Privileges”
Section 17.12.1, “Online DDL Operations”
Section 8.2.9, “Reserved Accounts”
Section 7.2, “The MySQL Data Directory”
Section 12.9.3, “The utf8 Character Set (Deprecated alias for utf8mb3)”
Section 30.2, “Using the sys Schema”
Section 3.4, “What the MySQL Upgrade Process Upgrades”

INFORMATION_SCHEMA.CHARACTER_SETS

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

INFORMATION_SCHEMA.COLUMN_STATISTICS

Section 10.9, “Controlling the Query Optimizer”
Section 10.9.6, “Optimizer Statistics”

INFORMATION_SCHEMA.COLUMNS

Section 25.5.14, “ndb_index_stat — NDB Index Statistics Utility”
Section 29.1, “Performance Schema Quick Start”

INFORMATION_SCHEMA.EVENTS

Section 19.5.1.16, “Replication of Invoked Features”

INFORMATION_SCHEMA.FILES

Section 15.1.21, “CREATE TABLESPACE Statement”
Section 25.6.17.26, “The ndbinfo dict_obj_tree Table”
Section 17.6.3.4, “Undo Tablespaces”

INFORMATION_SCHEMA.INNODB_CMP

MySQL Glossary
Section 17.9.1.3, “Tuning Compression for InnoDB Tables”
Section 17.15.1.3, “Using the Compression Information Schema Tables”

INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX

Section 17.9.1.3, “Tuning Compression for InnoDB Tables”

INFORMATION_SCHEMA.INNODB_CMPMEM

Section 17.15.1.3, “Using the Compression Information Schema Tables”

INFORMATION_SCHEMA.INNODB_TABLES

Section 26.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”

INFORMATION_SCHEMA.INNODB_TABLESPACES

Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”

INFORMATION_SCHEMA.INNODB_TABLESTATS

Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”

INFORMATION_SCHEMA.OPTIMIZER_TRACE

Section 10.15, “Tracing the Optimizer”
Section 10.15.1, “Typical Usage”

INFORMATION_SCHEMA.PARTITIONS

Section 26.2.7, “How MySQL Partitioning Handles NULL”

INFORMATION_SCHEMA.PROCESSLIST

Section 28.3.23, “The INFORMATION_SCHEMA PROCESSLIST Table”

information_schema.processlist

Section 7.1.10, “Server Status Variables”

INFORMATION_SCHEMA.ROUTINES

Section A.4, “MySQL 9.1 FAQ: Stored Procedures and Functions”

INFORMATION_SCHEMA.STATISTICS

Section 25.5.14, “ndb_index_stat — NDB Index Statistics Utility”
Section 7.3, “The mysql System Schema”

INFORMATION_SCHEMA.TABLES

Section 17.13, “InnoDB Data-at-Rest Encryption”

INFORMATION_SCHEMA.TRIGGERS

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

INNODB_BUFFER_PAGE

Section 17.5.2, “Change Buffer”
Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 30.1, “Prerequisites for Using the sys Schema”
Section 28.4.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 28.4.3, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 30.4.3.7, “The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views”
Section 30.4.3.8, “The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views”

INNODB_BUFFER_PAGE_LRU

Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 17.8.3.6, “Saving and Restoring the Buffer Pool State”
Section 28.4.3, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”

INNODB_BUFFER_POOL_STATS

Section 17.5.1, “Buffer Pool”
Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 28.4.4, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”

INNODB_CACHED_INDEXES

Section 28.4.5, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”

INNODB_CMP

Section 17.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 17.15.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 17.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 17.9.1.4, “Monitoring InnoDB Table Compression at Runtime”
Section 28.4.6, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 17.9.1.3, “Tuning Compression for InnoDB Tables”
Section 17.15.1.3, “Using the Compression Information Schema Tables”

INNODB_CMP_PER_INDEX

Section 17.14, “InnoDB Startup Options and System Variables”
Section 17.9.1.4, “Monitoring InnoDB Table Compression at Runtime”
Section 28.4.8, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 17.9.1.3, “Tuning Compression for InnoDB Tables”
Section 17.15.1.3, “Using the Compression Information Schema Tables”

INNODB_CMP_PER_INDEX_RESET

Section 28.4.8, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”

INNODB_CMP_RESET

Section 17.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 17.15.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 17.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 28.4.6, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”

INNODB_CMPMEM

Section 17.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 17.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 28.4.7, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 17.15.1.3, “Using the Compression Information Schema Tables”

INNODB_CMPMEM_RESET

Section 17.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 17.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 28.4.7, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”

INNODB_COLUMNS

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 28.4.9, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”
Section 28.4.29, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”

INNODB_DATAFILES

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 17.15.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 28.3.15, “The INFORMATION_SCHEMA FILES Table”
Section 28.4.10, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
Section 28.4.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”

INNODB_FIELDS

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 28.4.11, “The INFORMATION_SCHEMA INNODB_FIELDS Table”

INNODB_FOREIGN

Section 1.7.3.2, “FOREIGN KEY Constraints”
Section 15.1.20.5, “FOREIGN KEY Constraints”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 28.4.12, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”

INNODB_FOREIGN_COLS

Section 1.7.3.2, “FOREIGN KEY Constraints”
Section 15.1.20.5, “FOREIGN KEY Constraints”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 28.4.13, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”

INNODB_FT_BEING_DELETED

Section 17.6.2.4, “InnoDB Full-Text Indexes”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 17.14, “InnoDB Startup Options and System Variables”
Section 28.4.14, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”

INNODB_FT_CONFIG

Section 17.6.2.4, “InnoDB Full-Text Indexes”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 17.14, “InnoDB Startup Options and System Variables”
Section 28.4.15, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”

INNODB_FT_DEFAULT_STOPWORD

Section 14.9.4, “Full-Text Stopwords”
Section 17.6.2.4, “InnoDB Full-Text Indexes”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 28.4.16, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”

INNODB_FT_DELETED

Section 17.6.2.4, “InnoDB Full-Text Indexes”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 17.14, “InnoDB Startup Options and System Variables”
Section 28.4.14, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 28.4.17, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”

INNODB_FT_INDEX_CACHE

Section 17.6.2.4, “InnoDB Full-Text Indexes”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 17.14, “InnoDB Startup Options and System Variables”
Section 14.9.9, “MeCab Full-Text Parser Plugin”
Section 14.9.8, “ngram Full-Text Parser”
Section 28.4.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”

INNODB_FT_INDEX_TABLE

Section 14.9.4, “Full-Text Stopwords”
Section 17.6.2.4, “InnoDB Full-Text Indexes”
Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 17.14, “InnoDB Startup Options and System Variables”
Section 28.4.14, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 28.4.17, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 28.4.19, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”

INNODB_INDEXES

Section 17.8.11, “Configuring the Merge Threshold for Index Pages”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.6.2.4, “InnoDB Full-Text Indexes”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 28.4.5, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
Section 28.4.20, “The INFORMATION_SCHEMA INNODB_INDEXES Table”

INNODB_METRICS

Section 15.7.3.1, “ANALYZE TABLE Statement”
Section 17.5.2, “Change Buffer”
Section 17.8.11, “Configuring the Merge Threshold for Index Pages”
Section 17.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
Section 17.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 28.4.21, “The INFORMATION_SCHEMA INNODB_METRICS Table”
Section 30.4.3.21, “The metrics View”
Section 17.7.6, “Transaction Scheduling”
Section 17.6.3.4, “Undo Tablespaces”

INNODB_SESSION_TEMP_TABLESPACES

Section 17.6.3.5, “Temporary Tablespaces”
Section 28.4.22, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”

INNODB_TABLES

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.6.2.4, “InnoDB Full-Text Indexes”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 17.10, “InnoDB Row Formats”
Section 11.2.4, “Mapping of Identifiers to File Names”
Section 28.4.5, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
Section 28.4.23, “The INFORMATION_SCHEMA INNODB_TABLES Table”

INNODB_TABLESPACES

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.13, “InnoDB Data-at-Rest Encryption”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 17.9.2, “InnoDB Page Compression”
Section 17.15.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 15.7.7.37, “SHOW TABLE STATUS Statement”
Section 17.6.3.9, “Tablespace AUTOEXTEND_SIZE Configuration”
Section 28.3.15, “The INFORMATION_SCHEMA FILES Table”
Section 28.4.24, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
Section 28.4.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
Section 28.3.38, “The INFORMATION_SCHEMA TABLES Table”
Section 17.6.3.4, “Undo Tablespaces”

INNODB_TABLESPACES_BRIEF

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 28.4.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”

INNODB_TABLESTATS

Section 15.7.3.1, “ANALYZE TABLE Statement”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 28.4.26, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”

INNODB_TEMP_TABLE_INFO

Section 17.15.7, “InnoDB INFORMATION_SCHEMA Temporary Table Info Table”
Section 17.6.3.5, “Temporary Tablespaces”
Section 28.4.27, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”

INNODB_TRX

Section 17.15.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 17.15.2.2, “InnoDB Lock and Lock-Wait Information”
Section 17.14, “InnoDB Startup Options and System Variables”
Section 17.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 29.12.13.1, “The data_locks Table”
Section 28.4.28, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 17.7.6, “Transaction Scheduling”
Section 17.15.2.1, “Using InnoDB Transaction and Locking Information”

INNODB_VIRTUAL

Section 28.4.29, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”

K

KEY_COLUMN_USAGE

Section 1.7.3.2, “FOREIGN KEY Constraints”
Section 15.1.20.5, “FOREIGN KEY Constraints”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 28.3.16, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”
Section 7.3, “The mysql System Schema”

KEYWORDS

Section 28.3.17, “The INFORMATION_SCHEMA KEYWORDS Table”

M

MYSQL_FIREWALL_USERS

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”
Section 28.7.2, “The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table”
Section 8.4.7.3, “Using MySQL Enterprise Firewall”

MYSQL_FIREWALL_WHITELIST

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”
Section 28.7.3, “The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table”

N

NDB_TRANSID_MYSQL_CONNECTION_MAP

Section 25.6.17.55, “The ndbinfo server_operations Table”
Section 25.6.17.56, “The ndbinfo server_transactions Table”

ndb_transid_mysql_connection_map

Section 25.6.18, “INFORMATION_SCHEMA Tables for NDB Cluster”
Section 25.4.3.9.1, “MySQL Server Options for NDB Cluster”
Section 25.6.17, “ndbinfo: The NDB Cluster Information Database”

O

OPTIMIZER_TRACE

Section 10.2.1.2, “Range Optimization”
Section 28.3.19, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”
Section 10.15.4, “Tuning Trace Purging”

P

PARAMETERS

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section A.4, “MySQL 9.1 FAQ: Stored Procedures and Functions”
Section 15.7.7.29, “SHOW PROCEDURE STATUS Statement”
Section 28.3.20, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”

PARTITIONS

Section 26.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 26.2.7, “How MySQL Partitioning Handles NULL”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 26.2.5, “KEY Partitioning”
Section 26.3.5, “Obtaining Information About Partitions”
Chapter 26, Partitioning
Section 26.2.3.1, “RANGE COLUMNS partitioning”
Section 15.7.7.37, “SHOW TABLE STATUS Statement”
Section 28.3.21, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 28.3.38, “The INFORMATION_SCHEMA TABLES Table”

PLUGINS

Section 7.6.7.3, “Cloning Remote Data”
Section 8.4.2.1, “Connection-Control Plugin Installation”
Section 15.7.4.4, “INSTALL PLUGIN Statement”
Section 7.6.1, “Installing and Uninstalling Plugins”
Section 7.6.5.1, “Installing or Uninstalling ddl_rewriter”
Section 8.4.5.2, “Installing or Uninstalling MySQL Enterprise Audit”
Section 19.4.10.1, “Installing Semisynchronous Replication”
Section 7.6.7.1, “Installing the Clone Plugin”
Section 8.4.1.7, “Kerberos Pluggable Authentication”
Section 8.4.4.15, “Keyring Metadata”
Section 8.4.4.3, “Keyring Plugin Installation”
Section 8.4.1.6, “LDAP Pluggable Authentication”
Section 8.4.1.8, “No-Login Pluggable Authentication”
Section 7.6.2, “Obtaining Server Plugin Information”
Section 8.4.1.4, “PAM Pluggable Authentication”
Section 25.6.20, “Quick Reference: NDB Cluster SQL Statements”
Section 7.1.7, “Server Command Options”
Section 8.4.1.10, “Socket Peer-Credential Pluggable Authentication”
Section 8.4.1.12, “Test Pluggable Authentication”
Section 28.3.22, “The INFORMATION_SCHEMA PLUGINS Table”
Section 7.6.3.2, “Thread Pool Installation”
Section 8.4.1.11, “WebAuthn Pluggable Authentication”
Section 8.4.1.5, “Windows Pluggable Authentication”

PROCESSLIST

Section 10.14.1, “Accessing the Process List”
Section 14.15, “Information Functions”
Section 15.7.8.4, “KILL Statement”
Section 10.8.4, “Obtaining Execution Plan Information for a Named Connection”
Section 29.6, “Performance Schema Instrument Naming Conventions”
Section 29.12.11, “Performance Schema Replication Tables”
Section 29.12.5, “Performance Schema Stage Event Tables”
Section 17.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.7.30, “SHOW PROCESSLIST Statement”
Section 7.6.7.11, “Stopping a Cloning Operation”
Section 29.12.22.2, “The error_log Table”
Section 28.4.28, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 28.3.23, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 30.4.3.22, “The processlist and x$processlist Views”
Section 29.12.22.8, “The processlist Table”
Section 29.12.22.9, “The threads Table”
Section 17.15.2.1, “Using InnoDB Transaction and Locking Information”

PROFILING

Section 15.7.7.31, “SHOW PROFILE Statement”
Section 28.3.24, “The INFORMATION_SCHEMA PROFILING Table”

R

REFERENTIAL_CONSTRAINTS

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 28.3.25, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”
Section 7.3, “The mysql System Schema”

RESOURCE_GROUPS

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 7.1.16, “Resource Groups”
Section 28.3.26, “The INFORMATION_SCHEMA RESOURCE_GROUPS Table”

ROLE_COLUMN_GRANTS

Section 28.3.27, “The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table”

ROLE_ROUTINE_GRANTS

Section 28.3.28, “The INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS Table”

ROLE_TABLE_GRANTS

Section 28.3.29, “The INFORMATION_SCHEMA ROLE_TABLE_GRANTS Table”

ROUTINES

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 28.1, “Introduction”
Section 27.3.1, “JavaScript Stored Program Creation and Management”
Section A.4, “MySQL 9.1 FAQ: Stored Procedures and Functions”
Section 27.3.2, “Obtaining Information About JavaScript Stored Programs”
Section 8.2.2, “Privileges Provided by MySQL”
Section 15.7.7.29, “SHOW PROCEDURE STATUS Statement”
Section 27.7, “Stored Object Access Control”
Section 27.2.3, “Stored Routine Metadata”
Section 27.2.2, “Stored Routines and MySQL Privileges”
Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”

S

SCHEMA_PRIVILEGES

Section 28.3.33, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”

SCHEMATA

Section 12.3.3, “Database Character Set and Collation”
Section 8.2.3, “Grant Tables”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.13, “InnoDB Data-at-Rest Encryption”
Section 8.2.2, “Privileges Provided by MySQL”
Section 7.1.8, “Server System Variables”
Section 15.7.7.15, “SHOW DATABASES Statement”
Section 28.3.31, “The INFORMATION_SCHEMA SCHEMATA Table”
Section 28.3.32, “The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table”

SCHEMATA_EXTENSIONS

Section 15.1.2, “ALTER DATABASE Statement”
Section 28.3.31, “The INFORMATION_SCHEMA SCHEMATA Table”
Section 28.3.32, “The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table”

ST_GEOMETRY_COLUMNS

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 28.3.8, “The INFORMATION_SCHEMA COLUMNS Table”
Section 28.3.35, “The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table”

ST_SPATIAL_REFERENCE_SYSTEMS

Section 15.1.19, “CREATE SPATIAL REFERENCE SYSTEM Statement”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 13.4.5, “Spatial Reference System Support”
Section 28.3.36, “The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table”

ST_UNITS_OF_MEASURE

Section 14.16.7.3, “LineString and MultiLineString Property Functions”
Section 14.16.9.1, “Spatial Relation Functions That Use Object Shapes”
Section 28.3.37, “The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table”

STATISTICS

Section 15.7.3.1, “ANALYZE TABLE Statement”
Section 17.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 16.7, “Data Dictionary Usage Differences”
Section 15.1.20.11, “Generated Invisible Primary Keys”
Section 10.9.4, “Index Hints”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.14, “InnoDB Startup Options and System Variables”
Section 28.1, “Introduction”
Section 10.3.12, “Invisible Indexes”
Section 15.7.7.23, “SHOW INDEX Statement”
Section 28.3.34, “The INFORMATION_SCHEMA STATISTICS Table”

T

TABLE_CONSTRAINTS

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.12.1, “Online DDL Operations”
Section 28.3.25, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”
Section 28.3.41, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

TABLE_CONSTRAINTS_EXTENSIONS

Section 28.3.42, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table”

TABLE_PRIVILEGES

Section 28.3.43, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

TABLES

Section 25.6.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 15.1.9, “ALTER TABLE Statement”
Section 17.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 15.1.20, “CREATE TABLE Statement”
Section 16.7, “Data Dictionary Usage Differences”
Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 17.9.2, “InnoDB Page Compression”
Section 17.14, “InnoDB Startup Options and System Variables”
Section 28.1, “Introduction”
Section 11.2.4, “Mapping of Identifiers to File Names”
Section 25.4.3.9.2, “NDB Cluster System Variables”
Section 16.2, “Removal of File-based Metadata Storage”
Section 15.1.20.12, “Setting NDB Comment Options”
Section 15.7.7.37, “SHOW TABLE STATUS Statement”
Section 15.7.7.38, “SHOW TABLES Statement”
Section 30.4.4.2, “The diagnostics() Procedure”
Section 28.3.38, “The INFORMATION_SCHEMA TABLES Table”
Section 30.4.2.1, “The sys_config Table”
Section 7.6.3.2, “Thread Pool Installation”

TABLES_EXTENSIONS

Section 28.3.39, “The INFORMATION_SCHEMA TABLES_EXTENSIONS Table”

TABLESPACES_EXTENSIONS

Section 28.3.40, “The INFORMATION_SCHEMA TABLESPACES_EXTENSIONS Table”

TP_THREAD_GROUP_STATE

Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”

TP_THREAD_GROUP_STATS

Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”

TP_THREAD_STATE

Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”

TRIGGERS

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 3.6, “Preparing Your Installation for Upgrade”
Section 15.7.7.12, “SHOW CREATE TRIGGER Statement”
Section 15.7.7.39, “SHOW TRIGGERS Statement”
Section 28.3.44, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 27.4.2, “Trigger Metadata”

U

USER_ATTRIBUTES

Section 15.7.1.1, “ALTER USER Statement”
Section 15.7.1.3, “CREATE USER Statement”
Section 8.2.3, “Grant Tables”
Section 28.3.45, “The INFORMATION_SCHEMA USER_ATTRIBUTES Table”

USER_PRIVILEGES

Section 8.2.2, “Privileges Provided by MySQL”
Section 28.3.46, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

V

VIEW_ROUTINE_USAGE

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 28.3.48, “The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table”

VIEW_TABLE_USAGE

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 28.3.49, “The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table”

VIEWS

Section 16.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 3.6, “Preparing Your Installation for Upgrade”
Section 15.7.7.14, “SHOW CREATE VIEW Statement”
Section 28.3.47, “The INFORMATION_SCHEMA VIEWS Table”
Section 27.6.3, “Updatable and Insertable Views”
Section 27.6.5, “View Metadata”

PREV HOME UP NEXT

PDF (US Ltr) - 40.3Mb
PDF (A4) - 40.4Mb
Man Pages (TGZ) - 259.3Kb
Man Pages (Zip) - 366.4Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb