INFORMATION_SCHEMA Index

CHARACTER_SETS

Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA
Section 20.9, “The INFORMATION_SCHEMA CHARACTER_SETS Table”

COLLATIONS

Section 7.2.20, “INFORMATION_SCHEMA Optimization”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA
Section 21.10.1, “C API Data Types”
Section 20.10, “The INFORMATION_SCHEMA COLLATIONS Table”

COLLATION_CHARACTER_SET_APPLICABILITY

Section 20.11, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”

COLUMNS

Section 7.2.20, “INFORMATION_SCHEMA Optimization”
Section 20.3, “The INFORMATION_SCHEMA COLUMNS Table”
Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”

COLUMN_PRIVILEGES

Section 20.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

ENGINES

Section 1.4.1, “What Is New in MySQL 5.1”
Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
Section 20.18, “The INFORMATION_SCHEMA ENGINES Table”

EVENTS

Section 1.4.1, “What Is New in MySQL 5.1”
Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”

FILES

Section 1.4.1, “What Is New in MySQL 5.1”
Section 20.21, “The INFORMATION_SCHEMA FILES Table”

GLOBAL_STATUS

Section 20.24, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
Section 20.25, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

GLOBAL_VARIABLES

Section 20.25, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

INFORMATION_SCHEMA.CHARACTER_SETS

Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”

INFORMATION_SCHEMA.COLLATIONS

Section 9.5.2, “Choosing a Collation ID”

INFORMATION_SCHEMA.COLUMNS

Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”

INFORMATION_SCHEMA.ENGINES

Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”

INFORMATION_SCHEMA.EVENTS

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

INFORMATION_SCHEMA.FILES

Section 12.1.3, “ALTER LOGFILE GROUP Syntax”
Section 12.1.8, “ALTER TABLESPACE Syntax”
Section 12.1.14, “CREATE LOGFILE GROUP Syntax”
Section 12.1.18, “CREATE TABLESPACE Syntax”

INFORMATION_SCHEMA.PARAMETERS

Section 1.4.1, “What Is New in MySQL 5.1”
Section 1.4.2, “What Is Planned for MySQL 6.0”

INFORMATION_SCHEMA.PARTITIONS

Section 18.2.4, “KEY Partitioning”
Section 18.2.6, “How MySQL Partitioning Handles NULL
Section 18.3.4, “Obtaining Information About Partitions”
Section 20.19, “The INFORMATION_SCHEMA PARTITIONS Table”

INFORMATION_SCHEMA.PLUGINS

Section 22.2.3.1, “General Plugin Structures and Functions”

INFORMATION_SCHEMA.PROCESSLIST

Section 20.22, “The INFORMATION_SCHEMA PROCESSLIST Table”

INFORMATION_SCHEMA.ROUTINES

Chapter 20, INFORMATION_SCHEMA Tables
Section 1.4.1, “What Is New in MySQL 5.1”
Section A.4, “MySQL 5.1 FAQ — Stored Procedures and Functions”
Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”
Section 1.4.2, “What Is Planned for MySQL 6.0”

INFORMATION_SCHEMA.TABLES

Chapter 20, INFORMATION_SCHEMA Tables
Chapter 18, Partitioning

INFORMATION_SCHEMA.TABLE_CONSTRAINTS

Section 20.23, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

INFORMATION_SCHEMA.TRIGGERS

Section 12.5.5.40, “SHOW TRIGGERS Syntax”
Section A.5, “MySQL 5.1 FAQ — Triggers”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

INFORMATION_SCHEMA.VIEWS

Section 19.5.3, “Updatable and Insertable Views”

KEY_COLUMN_USAGE

Section 7.2.20, “INFORMATION_SCHEMA Optimization”
Section 20.13, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”

PARAMETERS

Section 19.2.3, “Stored Routine Metadata”
Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”

PARTITIONS

Section 7.2.20, “INFORMATION_SCHEMA Optimization”
Section 18.2.6, “How MySQL Partitioning Handles NULL
Section 1.4.1, “What Is New in MySQL 5.1”
Section 18.3.4, “Obtaining Information About Partitions”
Chapter 18, Partitioning
Section 20.19, “The INFORMATION_SCHEMA PARTITIONS Table”

PLUGINS

Section 22.2.1, “Characteristics of the Plugin Interface”
Section 1.4.1, “What Is New in MySQL 5.1”
Section 20.18, “The INFORMATION_SCHEMA ENGINES Table”
Section 20.17, “The INFORMATION_SCHEMA PLUGINS Table”

PROCESSLIST

Section 12.5.5.31, “SHOW PROCESSLIST Syntax”
Section 7.5.6, “Examining Thread Information”
Section 1.4.1, “What Is New in MySQL 5.1”
Section 20.22, “The INFORMATION_SCHEMA PROCESSLIST Table”

PROFILING

Section 12.5.5.33, “SHOW PROFILES Syntax”
Section 20.26, “The INFORMATION_SCHEMA PROFILING Table”

REFERENTIAL_CONSTRAINTS

Section 7.2.20, “INFORMATION_SCHEMA Optimization”
Section 20.23, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

ROUTINES

Section 12.5.5.30, “SHOW PROCEDURE STATUS Syntax”
Section A.4, “MySQL 5.1 FAQ — Stored Procedures and Functions”
Section 19.2.3, “Stored Routine Metadata”
Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”

SCHEMATA

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

SCHEMA_PRIVILEGES

Section 20.6, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”

SESSION_STATUS

Section 20.24, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
Section 20.25, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

SESSION_VARIABLES

Section 20.25, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

STATISTICS

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

TABLES

Section 7.2.20, “INFORMATION_SCHEMA Optimization”
Chapter 20, INFORMATION_SCHEMA Tables
Section 13.6.3, “InnoDB Startup Options and System Variables”
Section 20.2, “The INFORMATION_SCHEMA TABLES Table”

TABLE_CONSTRAINTS

Section 7.2.20, “INFORMATION_SCHEMA Optimization”
Section 20.12, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

TABLE_PRIVILEGES

Section 20.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

TRIGGERS

Section 7.2.20, “INFORMATION_SCHEMA Optimization”
Section 12.5.5.13, “SHOW CREATE TRIGGER Syntax”
Section 20.16, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.3.2, “Trigger Metadata”

USER_PRIVILEGES

Section 20.5, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

VIEWS

Section 7.2.20, “INFORMATION_SCHEMA Optimization”
Section 12.5.5.14, “SHOW CREATE VIEW Syntax”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 19.5.4, “View Metadata”