Skip navigation links
MySQL 5.1 Reference Manual :: INFORMATION_SCHEMA Index
Transaction Isolation Level Index »
Section Navigation      [Toggle]

INFORMATION_SCHEMA Index

CHARACTER_SETS

Section 9.1.9.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.9.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 21.9.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.5, “What Is New in MySQL 5.1”
Section 17.5.7, “Quick Reference: MySQL Cluster SQL Statements”
Section 20.18, “The INFORMATION_SCHEMA ENGINES Table”

EVENTS

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

FILES

Section 1.5, “What Is New in MySQL 5.1”
Section 17.5.10.1, “MySQL Cluster Disk Data Objects”
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.COLLATIONS

Section 9.4.2, “Choosing a Collation ID”

INFORMATION_SCHEMA.ENGINES

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

INFORMATION_SCHEMA.EVENTS

Section 12.4.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.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”
Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 17.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 17.5.10.3, “MySQL Cluster Disk Data Storage Requirements”

INFORMATION_SCHEMA.PARAMETERS

Section 1.5, “What Is New in MySQL 5.1”

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 12.4.3.4, “INSTALL PLUGIN Syntax”
Section 22.2.4.1, “General Plugin Data Structures and Functions”
Section 12.4.3.1, “Installing and Uninstalling Plugins”
Section 22.2.1, “Plugin API Characteristics”
Section 22.2.2, “Plugin API Components”

INFORMATION_SCHEMA.PROCESSLIST

Section 20.22, “The INFORMATION_SCHEMA PROCESSLIST Table”

INFORMATION_SCHEMA.ROUTINES

Chapter 20, INFORMATION_SCHEMA Tables
Section 1.5, “What Is New in MySQL 5.1”
Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”

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.4.5.40, “SHOW TRIGGERS Syntax”
Section 2.4.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.5, “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 1.5, “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.4.5.31, “SHOW PROCESSLIST Syntax”
Section 7.5.6, “Examining Thread Information”
Section 1.5, “What Is New in MySQL 5.1”
Section 20.22, “The INFORMATION_SCHEMA PROCESSLIST Table”

PROFILING

Section 12.4.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.4.5.30, “SHOW PROCEDURE STATUS Syntax”
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.4.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.4.5.14, “SHOW CREATE VIEW Syntax”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 19.5.4, “View Metadata”