INFORMATION_SCHEMA Index

CHARACTER_SETS

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

COLLATIONS

Section 7.2.24, “INFORMATION_SCHEMA Optimization”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA
Section 20.10.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.24, “INFORMATION_SCHEMA Optimization”
Section 19.3, “The INFORMATION_SCHEMA COLUMNS Table”

COLUMN_PRIVILEGES

Section 19.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

ENGINES

Section 1.4.1, “What Is New in MySQL 6.0”
Section 19.18, “The INFORMATION_SCHEMA ENGINES Table”

EVENTS

Section 1.4.1, “What Is New in MySQL 6.0”
Section 19.20, “The INFORMATION_SCHEMA EVENTS Table”

FILES

Section 1.4.1, “What Is New in MySQL 6.0”
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.CHARACTER_SETS

Section A.11, “MySQL 6.0 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 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”

INFORMATION_SCHEMA.EVENTS

Section 12.1.9, “CREATE EVENT Syntax”
Section 12.5.6.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.PARTITIONS

Section 17.2.4, “KEY Partitioning”
Section 17.2.6, “How MySQL Partitioning Handles NULL
Section 17.3.4, “Obtaining Information About Partitions”
Section 19.19, “The INFORMATION_SCHEMA PARTITIONS Table”

INFORMATION_SCHEMA.PLUGINS

Section 21.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 A.4, “MySQL 6.0 FAQ — Stored Procedures and Functions”
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.6.38, “SHOW TRIGGERS Syntax”
Section A.5, “MySQL 6.0 FAQ — Triggers”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

INFORMATION_SCHEMA.VIEWS

Section 18.5.3, “Updatable and Insertable Views”

KEY_COLUMN_USAGE

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

PARTITIONS

Section 7.2.24, “INFORMATION_SCHEMA Optimization”
Section 17.2.6, “How MySQL Partitioning Handles NULL
Section 1.4.1, “What Is New in MySQL 6.0”
Section 17.3.4, “Obtaining Information About Partitions”
Chapter 17, Partitioning
Section 19.19, “The INFORMATION_SCHEMA PARTITIONS Table”

PLUGINS

Section 21.2.1, “Characteristics of the Plugin Interface”
Section 1.4.1, “What Is New in MySQL 6.0”
Section 19.18, “The INFORMATION_SCHEMA ENGINES Table”
Section 19.17, “The INFORMATION_SCHEMA PLUGINS Table”

PROCESSLIST

Section 12.5.6.30, “SHOW PROCESSLIST Syntax”
Section 7.5.6, “Examining Thread Information”
Section 1.4.1, “What Is New in MySQL 6.0”
Section 19.23, “The INFORMATION_SCHEMA PROCESSLIST Table”

PROFILING

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

REFERENTIAL_CONSTRAINTS

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

ROUTINES

Section 12.5.6.29, “SHOW PROCEDURE STATUS Syntax”
Section A.4, “MySQL 6.0 FAQ — Stored Procedures and Functions”
Section 18.2.3, “Stored Routine Metadata”
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.24, “INFORMATION_SCHEMA Optimization”
Section 13.7.3, “InnoDB Startup Options and System Variables”
Section 19.4, “The INFORMATION_SCHEMA STATISTICS Table”

TABLES

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

TABLE_CONSTRAINTS

Section 7.2.24, “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.24, “INFORMATION_SCHEMA Optimization”
Section 12.5.6.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.24, “INFORMATION_SCHEMA Optimization”
Section 12.5.6.14, “SHOW CREATE VIEW Syntax”
Section 19.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 18.5.4, “View Metadata”