INFORMATION_SCHEMA Index

C

[index top]

CHARACTER_SETS

Section 10.1.9.3, "SHOW Statements andINFORMATION_SCHEMA"

Section 20.1, "The INFORMATION_SCHEMA CHARACTER_SETS Table"

COLLATION_CHARACTER_SET_APPLICABILITY

Section 20.3, "The INFORMATION_SCHEMACOLLATION_CHARACTER_SET_APPLICABILITY Table"

COLLATIONS

Section 10.1.9.3, "SHOW Statements andINFORMATION_SCHEMA"

Section 22.8.1, "C API Data Structures"

Section 8.2.4, "Optimizing INFORMATION_SCHEMA Queries"

Section 20.2, "The INFORMATION_SCHEMA COLLATIONS Table"

COLUMN_PRIVILEGES

Section 20.5, "The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table"

COLUMNS

Section 8.2.4, "Optimizing INFORMATION_SCHEMA Queries"

Section 20.4, "The INFORMATION_SCHEMA COLUMNS Table"

Section 20.11, "The INFORMATION_SCHEMA PARAMETERS Table"

Section 20.17, "The INFORMATION_SCHEMA ROUTINES Table"

E

[index top]

ENGINES

Section 17.5.9, "Quick Reference: MySQL Cluster SQL Statements"

Section 20.6, "The INFORMATION_SCHEMA ENGINES Table"

EVENTS

Section 19.4.4, "Event Metadata"

Section 19.4.2, "Event Scheduler Configuration"

Section 16.4.1.10, "Replication of Invoked Features"

Section 20.7, "The INFORMATION_SCHEMA EVENTS Table"

F

[index top]

FILES

Section 20.29, "INFORMATION_SCHEMA Tables for MySQL Cluster"

Section 17.5.12.1, "MySQL Cluster Disk Data Objects"

Section 20.29.1, "The INFORMATION_SCHEMA FILES Table"

Section 17.5.10, "The ndbinfo MySQL Cluster Information Database"

G

[index top]

GLOBAL_STATUS

Section 17.5, "Management of MySQL Cluster"

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_STATUSTables"

GLOBAL_VARIABLES

Section 20.9, "The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLESTables"

I

[index top]

INFORMATION_SCHEMA.COLLATIONS

Section 10.4.2, "Choosing a Collation ID"

INFORMATION_SCHEMA.COLUMNS

Section 21.1, "Performance Schema Quick Start"

INFORMATION_SCHEMA.ENGINES

Section 21.1, "Performance Schema Quick Start"

Section 17.5.9, "Quick Reference: MySQL Cluster SQL Statements"

INFORMATION_SCHEMA.EVENTS

Section 13.7.5.19, "SHOW EVENTS Syntax"

Section 19.4.4, "Event Metadata"

Section 16.4.1.10, "Replication of Invoked Features"

Section E.1, "Restrictions on Stored Programs"

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.9, "ndb_desc - Describe NDB Tables"

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.PARTITIONS

Section 18.2.5, "KEY Partitioning"

Section 18.2.3.1, "RANGE COLUMNS partitioning"

Section 18.2.7, "How MySQL Partitioning Handles NULL"

Section 18.3.4, "Obtaining Information About Partitions"

Section 20.12, "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 6.3.10.1, "Installing the Audit Log Plugin"

Section 6.3.6.2.1, "Installing the PAM Authentication Plugin"

Section 6.3.6.3.1, "Installing the Windows Authentication Plugin"

Section 5.1.8.2, "Obtaining Server Plugin Information"

Section 23.2.1, "Plugin API Characteristics"

Section 23.2.2, "Plugin API Components"

Section 16.3.8.2, "Semisynchronous Replication Installation and Configuration"

Section 23.2.4.2.1, "Server Plugin Library and Plugin Descriptors"

Section 8.11.6.1, "Thread Pool Components and Installation"

Section 23.2.4.6, "Writing INFORMATION_SCHEMA Plugins"

Section 23.2.4.8, "Writing Audit Plugins"

Section 23.2.4.5, "Writing Daemon Plugins"

Section 23.2.4.4, "Writing Full-Text Parser Plugins"

Section 23.2.4.9.1, "Writing the Server-Side Authentication Plugin"

INFORMATION_SCHEMA.PROCESSLIST

Section 20.14, "The INFORMATION_SCHEMA PROCESSLIST Table"

Section 21.7.5.2, "The threads Table"

INFORMATION_SCHEMA.ROUTINES

Chapter 20, INFORMATION_SCHEMA Tables

Section 22.2.6, "Connector/Net Connection String Options Reference"

Section 20.17, "The INFORMATION_SCHEMA ROUTINES Table"

INFORMATION_SCHEMA.SESSION_STATUS

Section 17.5.15, "NDB API Statistics Counters and Variables"

INFORMATION_SCHEMA.TABLE_CONSTRAINTS

Section 20.16, "The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table"

INFORMATION_SCHEMA.TABLES

Chapter 20, INFORMATION_SCHEMA Tables

Section 17.5.13.3, "Adding MySQL Cluster Data Nodes Online: Detailed Example"

INFORMATION_SCHEMA.TRIGGERS

Section 13.7.5.39, "SHOW TRIGGERS Syntax"

INFORMATION_SCHEMA.VIEWS

Section 19.5.3, "Updatable and Insertable Views"

INNODB_CMP

Section 20.28.1, "The INFORMATION_SCHEMA INNODB_CMP andINNODB_CMP_RESET Tables"

INNODB_CMPMEM

Section 20.28.2, "The INFORMATION_SCHEMA INNODB_CMPMEM andINNODB_CMPMEM_RESET Tables"

INNODB_LOCK_WAITS

Section 20.28.5, "The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table"

INNODB_LOCKS

Section 20.28.4, "The INFORMATION_SCHEMA INNODB_LOCKS Table"

INNODB_TRX

Section 20.28.3, "The INFORMATION_SCHEMA INNODB_TRX Table"

K

[index top]

KEY_COLUMN_USAGE

Section 8.2.4, "Optimizing INFORMATION_SCHEMA Queries"

Section 20.10, "The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table"

N

[index top]

NDB_TRANSID_MYSQL_CONNECTION_MAP

Section 17.5.10.15, "The ndbinfo server_operations Table"

Section 17.5.10.16, "The ndbinfo server_transactions Table"

ndb_transid_mysql_connection_map

Section 20.29, "INFORMATION_SCHEMA Tables for MySQL Cluster"

Section 17.3.4.2, "MySQL Server Options for MySQL Cluster"

P

[index top]

PARAMETERS

Section 20.11, "The INFORMATION_SCHEMA PARAMETERS Table"

Section 20.17, "The INFORMATION_SCHEMA ROUTINES Table"

PARTITIONS

Section 18.2.7, "How MySQL Partitioning Handles NULL"

Section 18.3.4, "Obtaining Information About Partitions"

Section 8.2.4, "Optimizing INFORMATION_SCHEMA Queries"

Chapter 18, Partitioning

Section 20.12, "The INFORMATION_SCHEMA PARTITIONS Table"

PLUGINS

Section 5.1.8.2, "Obtaining Server Plugin Information"

Section 20.6, "The INFORMATION_SCHEMA ENGINES Table"

Section 20.13, "The INFORMATION_SCHEMA PLUGINS Table"

PROCESSLIST

Section 13.7.5.30, "SHOW PROCESSLIST Syntax"

Section 8.12.5, "Examining Thread Information"

Section 20.14, "The INFORMATION_SCHEMA PROCESSLIST Table"

PROFILING

Section 13.7.5.31, "SHOW PROFILE Syntax"

Section 20.15, "The INFORMATION_SCHEMA PROFILING Table"

R

[index top]

REFERENTIAL_CONSTRAINTS

Section 8.2.4, "Optimizing INFORMATION_SCHEMA Queries"

Section 20.16, "The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table"

ROUTINES

Section 13.7.5.29, "SHOW PROCEDURE STATUS Syntax"

Section 19.2.3, "Stored Routine Metadata"

Section 20.11, "The INFORMATION_SCHEMA PARAMETERS Table"

Section 20.17, "The INFORMATION_SCHEMA ROUTINES Table"

S

[index top]

SCHEMA_PRIVILEGES

Section 20.19, "The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table"

SCHEMATA

Section 6.2.2, "Privilege System Grant Tables"

Section 20.18, "The INFORMATION_SCHEMA SCHEMATA Table"

SESSION_STATUS

Section 17.5, "Management of MySQL Cluster"

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_STATUSTables"

SESSION_VARIABLES

Section 20.9, "The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLESTables"

STATISTICS

Section 14.3.4, "InnoDB Startup Options and System Variables"

Section 8.2.4, "Optimizing INFORMATION_SCHEMA Queries"

Section 20.20, "The INFORMATION_SCHEMA STATISTICS Table"

T

[index top]

TABLE_CONSTRAINTS

Section 8.2.4, "Optimizing INFORMATION_SCHEMA Queries"

Section 20.23, "The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table"

TABLE_PRIVILEGES

Section 20.24, "The INFORMATION_SCHEMA TABLE_PRIVILEGES Table"

TABLES

Chapter 20, INFORMATION_SCHEMA Tables

Section 14.3.4, "InnoDB Startup Options and System Variables"

Section 8.2.4, "Optimizing INFORMATION_SCHEMA Queries"

Section 20.21, "The INFORMATION_SCHEMA TABLES Table"

TABLESPACES

Section 20.22, "The INFORMATION_SCHEMA TABLESPACES Table"

TP_THREAD_GROUP_STATE

Section 20.30.2, "The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table"

Section 20.30, "Thread Pool INFORMATION_SCHEMA Tables"

Section 8.11.6.1, "Thread Pool Components and Installation"

TP_THREAD_GROUP_STATS

Section 20.30.1, "The INFORMATION_SCHEMA TP_THREAD_STATE Table"

Section 20.30, "Thread Pool INFORMATION_SCHEMA Tables"

Section 8.11.6.1, "Thread Pool Components and Installation"

TP_THREAD_STATE

Section 20.30, "Thread Pool INFORMATION_SCHEMA Tables"

Section 8.11.6.1, "Thread Pool Components and Installation"

TRIGGERS

Section 13.7.5.13, "SHOW CREATE TRIGGER Syntax"

Section 8.2.4, "Optimizing INFORMATION_SCHEMA Queries"

Section 20.25, "The INFORMATION_SCHEMA TRIGGERS Table"

Section 19.3.2, "Trigger Metadata"

U

[index top]

USER_PRIVILEGES

Section 20.26, "The INFORMATION_SCHEMA USER_PRIVILEGES Table"

V

[index top]

VIEWS

Section 13.7.5.14, "SHOW CREATE VIEW Syntax"

Section 8.2.4, "Optimizing INFORMATION_SCHEMA Queries"

Section 20.27, "The INFORMATION_SCHEMA VIEWS Table"

Section 19.5.4, "View Metadata"