INFORMATION_SCHEMA Index

C | E | F | G | I | K | N | P | R | S | T | U | V

C

[index top]

CHARACTER_SETS

Section 10.1.9.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 20.1, “The INFORMATION_SCHEMA CHARACTER_SETS Table”

COLLATION_CHARACTER_SET_APPLICABILITY

Section 20.3, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”

COLLATIONS

Section 21.8.5, “C API Data Structures”
Section 8.3.3, “INFORMATION_SCHEMA Optimization”
Section 10.1.9.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 20.2, “The INFORMATION_SCHEMA COLLATIONS Table”

COLUMN_PRIVILEGES

Section 20.5, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

COLUMNS

Section 8.3.3, “INFORMATION_SCHEMA Optimization”
Section 20.4, “The INFORMATION_SCHEMA COLUMNS Table”

E

[index top]

ENGINES

Section 17.5.9, “Quick Reference: MySQL Cluster SQL Statements”
Section 5.1.4, “Server System Variables”
Section 13.7.5.17, “SHOW ENGINES Syntax”
Section 20.6, “The INFORMATION_SCHEMA ENGINES Table”
Section 1.4, “What Is New in MySQL 5.1”

EVENTS

Section 19.4.4, “Event Metadata”
Section 19.4.2, “Event Scheduler Configuration”
Section 16.4.1.11, “Replication of Invoked Features”
Section 20.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 1.4, “What Is New in MySQL 5.1”

F

[index top]

FILES

Section 20.26, “INFORMATION_SCHEMA Tables for MySQL Cluster”
Section 17.5.12.1, “MySQL Cluster Disk Data Objects”
Section 20.26.1, “The INFORMATION_SCHEMA FILES Table”
Section 17.5.10, “The ndbinfo MySQL Cluster Information Database”
Section 1.4, “What Is New in MySQL 5.1”

G

[index top]

GLOBAL_STATUS

Section 17.5, “Management of MySQL Cluster”
Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 17.6, “MySQL Cluster Replication”
Section 17.5.15, “NDB API Statistics Counters and Variables”
Section 20.8, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
Section 20.9, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

GLOBAL_VARIABLES

Section 20.9, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

I

[index top]

INFORMATION_SCHEMA GLOBAL_STATUS

Section 20.8, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

INFORMATION_SCHEMA GLOBAL_VARIABLES

Section 20.9, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

INFORMATION_SCHEMA.COLLATIONS

Section 10.4.2, “Choosing a Collation ID”

INFORMATION_SCHEMA.COLUMNS

Section 17.4.14, “ndb_index_stat — NDB Index Statistics Utility”

INFORMATION_SCHEMA.ENGINES

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

INFORMATION_SCHEMA.EVENTS

Section 19.4.4, “Event Metadata”
Section 16.4.1.11, “Replication of Invoked Features”
Section D.1, “Restrictions on Stored Programs”
Section 13.7.5.19, “SHOW EVENTS Syntax”
Section 19.4.6, “The Event Scheduler and MySQL Privileges”

INFORMATION_SCHEMA.FILES

Section 13.1.3, “ALTER LOGFILE GROUP Syntax”
Section 13.1.8, “ALTER TABLESPACE Syntax”
Section 13.1.14, “CREATE LOGFILE GROUP Syntax”
Section 13.1.18, “CREATE TABLESPACE Syntax”
Section 17.4.10, “ndb_desc — Describe NDB Tables”
Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 17.5.12.3, “MySQL Cluster Disk Data Storage Requirements”

INFORMATION_SCHEMA.GLOBAL_STATUS

Section 17.5.15, “NDB API Statistics Counters and Variables”

INFORMATION_SCHEMA.KEY_COLUMN_USAGE

Section 1.8.3.2, “FOREIGN KEY Constraints”
Section 14.6.5.6, “InnoDB and FOREIGN KEY Constraints”
Section 13.1.17.2, “Using FOREIGN KEY Constraints”

INFORMATION_SCHEMA.PARTITIONS

Section 18.2.6, “How MySQL Partitioning Handles NULL”
Section 18.2.4, “KEY Partitioning”
Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 18.3.4, “Obtaining Information About Partitions”
Section 5.1.3, “Server Command Options”
Section 20.11, “The INFORMATION_SCHEMA PARTITIONS Table”

INFORMATION_SCHEMA.PLUGINS

Section 13.7.3.3, “INSTALL PLUGIN Syntax”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 22.2.4.2.1, “Library and Plugin Descriptors”
Section 5.1.8.2, “Obtaining Server Plugin Information”
Chapter 18, Partitioning
Section 22.2.1, “Plugin API Characteristics”
Section 22.2.2, “Plugin API Components”
Section 22.2.4.5, “Writing Daemon Plugins”
Section 22.2.4.4, “Writing Full-Text Parser Plugins”
Section 22.2.4.6, “Writing INFORMATION_SCHEMA Plugins”

INFORMATION_SCHEMA.PROCESSLIST

Section 20.13, “The INFORMATION_SCHEMA PROCESSLIST Table”

INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS

Section 1.8.2.4, “Foreign Keys”

INFORMATION_SCHEMA.ROUTINES

Chapter 20, INFORMATION_SCHEMA Tables
Section 20.16, “The INFORMATION_SCHEMA ROUTINES Table”

INFORMATION_SCHEMA.SESSION_STATUS

Section 17.5.15, “NDB API Statistics Counters and Variables”

INFORMATION_SCHEMA.STATISTICS

Section 17.4.14, “ndb_index_stat — NDB Index Statistics Utility”

INFORMATION_SCHEMA.TABLE_CONSTRAINTS

Section 1.8.2.4, “Foreign Keys”
Section 20.15, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

INFORMATION_SCHEMA.TABLES

Section 17.5.13.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Chapter 20, INFORMATION_SCHEMA Tables
Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Chapter 18, Partitioning
Section 5.1.3, “Server Command Options”

INFORMATION_SCHEMA.VIEWS

Section 19.5.3, “Updatable and Insertable Views”

INNODB_SYS_FOREIGN

Section 1.8.3.2, “FOREIGN KEY Constraints”
Section 14.6.5.6, “InnoDB and FOREIGN KEY Constraints”

INNODB_SYS_FOREIGN_COLS

Section 1.8.3.2, “FOREIGN KEY Constraints”
Section 14.6.5.6, “InnoDB and FOREIGN KEY Constraints”

K

[index top]

KEY_COLUMN_USAGE

Section 8.3.3, “INFORMATION_SCHEMA Optimization”
Section 20.10, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”

N

[index top]

NDB_TRANSID_MYSQL_CONNECTION_MAP

Section 17.5.10.16, “The ndbinfo server_operations Table”
Section 17.5.10.17, “The ndbinfo server_transactions Table”

ndb_transid_mysql_connection_map

Section 20.26, “INFORMATION_SCHEMA Tables for MySQL Cluster”
Section 17.3.4.2, “MySQL Server Options for MySQL Cluster”

P

[index top]

PARTITIONS

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

PLUGINS

Section 5.1.8.2, “Obtaining Server Plugin Information”
Section 20.12, “The INFORMATION_SCHEMA PLUGINS Table”
Section 1.4, “What Is New in MySQL 5.1”

PROCESSLIST

Section 8.10, “Examining Thread Information”
Section 13.7.5.31, “SHOW PROCESSLIST Syntax”
Section 20.13, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 1.4, “What Is New in MySQL 5.1”

PROFILING

Section 13.7.5.32, “SHOW PROFILE Syntax”
Section 20.14, “The INFORMATION_SCHEMA PROFILING Table”

R

[index top]

REFERENTIAL_CONSTRAINTS

Section 8.3.3, “INFORMATION_SCHEMA Optimization”
Section 20.15, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

ROUTINES

Section 13.7.5.30, “SHOW PROCEDURE STATUS Syntax”
Section 19.2.3, “Stored Routine Metadata”
Section 20.16, “The INFORMATION_SCHEMA ROUTINES Table”

S

[index top]

SCHEMA_PRIVILEGES

Section 20.18, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”

SCHEMATA

Section 6.2.2, “Privilege System Grant Tables”
Section 20.17, “The INFORMATION_SCHEMA SCHEMATA Table”

SESSION_STATUS

Section 17.5, “Management of MySQL Cluster”
Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 17.6, “MySQL Cluster Replication”
Section 17.5.15, “NDB API Statistics Counters and Variables”
Section 20.8, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
Section 20.9, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

SESSION_VARIABLES

Section 20.9, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

STATISTICS

Section 8.3.3, “INFORMATION_SCHEMA Optimization”
Section 14.6.7, “InnoDB Startup Options and System Variables”
Section 20.19, “The INFORMATION_SCHEMA STATISTICS Table”

T

[index top]

TABLE_CONSTRAINTS

Section 8.3.3, “INFORMATION_SCHEMA Optimization”
Section 20.21, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

TABLE_PRIVILEGES

Section 20.22, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

TABLES

Section 8.3.3, “INFORMATION_SCHEMA Optimization”
Chapter 20, INFORMATION_SCHEMA Tables
Section 14.6.7, “InnoDB Startup Options and System Variables”
Section 20.20, “The INFORMATION_SCHEMA TABLES Table”

TRIGGERS

Section 8.3.3, “INFORMATION_SCHEMA Optimization”
Section 13.7.5.13, “SHOW CREATE TRIGGER Syntax”
Section 13.7.5.40, “SHOW TRIGGERS Syntax”
Section 20.23, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.3.2, “Trigger Metadata”

U

[index top]

USER_PRIVILEGES

Section 20.24, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

V

[index top]

VIEWS

Section 8.3.3, “INFORMATION_SCHEMA Optimization”
Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
Section 20.25, “The INFORMATION_SCHEMA VIEWS Table”
Section 19.5.4, “View Metadata”