INFORMATION_SCHEMA Index

CHARACTER_SETS

Section 9.1.9.3, “SHOW Statements and INFORMATION_SCHEMA
Section 19.9, “The INFORMATION_SCHEMA CHARACTER_SETS Table”

COLLATIONS

Section 7.2.21, “INFORMATION_SCHEMA Optimization”
Section 9.1.9.3, “SHOW Statements and INFORMATION_SCHEMA
Section 21.9.1, “C API Data Types”
Section 19.10, “The INFORMATION_SCHEMA COLLATIONS Table”

COLLATION_CHARACTER_SET_APPLICABILITY

Section 19.11, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”

COLUMNS

Section 7.2.21, “INFORMATION_SCHEMA Optimization”
Section 19.3, “The INFORMATION_SCHEMA COLUMNS Table”
Section 19.27, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”

COLUMN_PRIVILEGES

Section 19.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

ENGINES

Section 1.5, “What Is New in MySQL 5.5”
Section 19.18, “The INFORMATION_SCHEMA ENGINES Table”

EVENTS

Section 1.5, “What Is New in MySQL 5.5”
Section 19.20, “The INFORMATION_SCHEMA EVENTS Table”

FILES

Section 1.5, “What Is New in MySQL 5.5”
Section 19.21, “The INFORMATION_SCHEMA FILES Table”

GLOBAL_STATUS

Section 19.25, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
Section 19.26, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

GLOBAL_VARIABLES

Section 19.26, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

INFORMATION_SCHEMA.COLLATIONS

Section 9.4.2, “Choosing a Collation ID”

INFORMATION_SCHEMA.EVENTS

Section 12.5.5.19, “SHOW EVENTS Syntax”
Section 16.4.1.8, “Replication of Invoked Features”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

INFORMATION_SCHEMA.PARAMETERS

Section 1.5, “What Is New in MySQL 5.5”

INFORMATION_SCHEMA.PARTITIONS

Section 17.2.5, “KEY Partitioning”
Section 17.2.7, “How MySQL Partitioning Handles NULL
Section 17.3.4, “Obtaining Information About Partitions”
Section 17.2.3.1, “Range columns partitioning”
Section 19.19, “The INFORMATION_SCHEMA PARTITIONS Table”

INFORMATION_SCHEMA.PLUGINS

Section 12.5.3.3, “INSTALL PLUGIN Syntax”
Section 22.2.1, “Characteristics of the Plugin Interface”
Section 22.2.3.1, “General Plugin Structures and Functions”

INFORMATION_SCHEMA.PROCESSLIST

Section 19.23, “The INFORMATION_SCHEMA PROCESSLIST Table”

INFORMATION_SCHEMA.ROUTINES

Chapter 19, INFORMATION_SCHEMA Tables
Section 1.5, “What Is New in MySQL 5.5”
Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”

INFORMATION_SCHEMA.TABLES

Chapter 19, INFORMATION_SCHEMA Tables
Chapter 17, Partitioning

INFORMATION_SCHEMA.TABLE_CONSTRAINTS

Section 19.24, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

INFORMATION_SCHEMA.TRIGGERS

Section 12.5.5.39, “SHOW TRIGGERS Syntax”
Section 2.12.1.1, “Upgrading from MySQL 5.4 to 5.5”

INFORMATION_SCHEMA.VIEWS

Section 18.5.3, “Updatable and Insertable Views”

KEY_COLUMN_USAGE

Section 7.2.21, “INFORMATION_SCHEMA Optimization”
Section 19.13, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”

PARAMETERS

Section 18.2.3, “Stored Routine Metadata”
Section 19.27, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”

PARTITIONS

Section 7.2.21, “INFORMATION_SCHEMA Optimization”
Section 17.2.7, “How MySQL Partitioning Handles NULL
Section 1.5, “What Is New in MySQL 5.5”
Section 17.3.4, “Obtaining Information About Partitions”
Chapter 17, Partitioning
Section 19.19, “The INFORMATION_SCHEMA PARTITIONS Table”

PLUGINS

Section 22.2.1, “Characteristics of the Plugin Interface”
Section 1.5, “What Is New in MySQL 5.5”
Section 19.18, “The INFORMATION_SCHEMA ENGINES Table”
Section 19.17, “The INFORMATION_SCHEMA PLUGINS Table”

PROCESSLIST

Section 12.5.5.30, “SHOW PROCESSLIST Syntax”
Section 7.5.6, “Examining Thread Information”
Section 1.5, “What Is New in MySQL 5.5”
Section 19.23, “The INFORMATION_SCHEMA PROCESSLIST Table”

PROFILING

Section 12.5.5.32, “SHOW PROFILES Syntax”
Section 19.28, “The INFORMATION_SCHEMA PROFILING Table”

REFERENTIAL_CONSTRAINTS

Section 7.2.21, “INFORMATION_SCHEMA Optimization”
Section 19.24, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

ROUTINES

Section 12.5.5.29, “SHOW PROCEDURE STATUS Syntax”
Section 18.2.3, “Stored Routine Metadata”
Section 19.27, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”

SCHEMATA

Section 5.4.2, “Privilege System Grant Tables”
Section 19.1, “The INFORMATION_SCHEMA SCHEMATA Table”

SCHEMA_PRIVILEGES

Section 19.6, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”

SESSION_STATUS

Section 19.25, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
Section 19.26, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

SESSION_VARIABLES

Section 19.26, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

STATISTICS

Section 7.2.21, “INFORMATION_SCHEMA Optimization”
Section 13.6.3, “InnoDB Startup Options and System Variables”
Section 19.4, “The INFORMATION_SCHEMA STATISTICS Table”

TABLES

Section 7.2.21, “INFORMATION_SCHEMA Optimization”
Chapter 19, INFORMATION_SCHEMA Tables
Section 13.6.3, “InnoDB Startup Options and System Variables”
Section 19.2, “The INFORMATION_SCHEMA TABLES Table”

TABLESPACES

Section 19.22, “The INFORMATION_SCHEMA TABLESPACES Table”

TABLE_CONSTRAINTS

Section 7.2.21, “INFORMATION_SCHEMA Optimization”
Section 19.12, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

TABLE_PRIVILEGES

Section 19.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

TRIGGERS

Section 7.2.21, “INFORMATION_SCHEMA Optimization”
Section 12.5.5.13, “SHOW CREATE TRIGGER Syntax”
Section 19.16, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 18.3.2, “Trigger Metadata”

USER_PRIVILEGES

Section 19.5, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

VIEWS

Section 7.2.21, “INFORMATION_SCHEMA Optimization”
Section 12.5.5.14, “SHOW CREATE VIEW Syntax”
Section 19.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 18.5.4, “View Metadata”