INFORMATION_SCHEMA Index

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

C

[index top]

CHARACTER_SETS

Section 10.3.8, “Character Set Introducers”
Section 10.2, “Character Sets and Collations in MySQL”
Section 10.3.6, “Character String Literal Character Set and Collation”
Section 10.3.5, “Column Character Set and Collation”
Section 10.3.3, “Database Character Set and Collation”
Section 13.7.5.4, “SHOW CHARACTER SET Statement”
Section 10.10, “Supported Character Sets and Collations”
Section 10.3.4, “Table Character Set and Collation”
Section 21.2, “The INFORMATION_SCHEMA CHARACTER_SETS Table”

COLLATION_CHARACTER_SET_APPLICABILITY

Section 21.4, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”

COLLATIONS

Section 23.7.4, “C API Data Structures”
Section 10.15, “Character Set Configuration”
Section 10.2, “Character Sets and Collations in MySQL”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 13.7.5.5, “SHOW COLLATION Statement”
Section 21.3, “The INFORMATION_SCHEMA COLLATIONS Table”

COLUMN_PRIVILEGES

Section 21.6, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

COLUMNS

Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 13.7.5.6, “SHOW COLUMNS Statement”
Section 21.5, “The INFORMATION_SCHEMA COLUMNS Table”
Section 21.29.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 21.29.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 21.29.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”
Section 21.29.4, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 21.29.5, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 21.29.7, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 21.29.6, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 21.29.8, “The INFORMATION_SCHEMA INNODB_TRX Table”

E

[index top]

ENGINES

Section 18.5.9, “Quick Reference: NDB Cluster SQL Statements”
Section 5.1.7, “Server System Variables”
Section 13.7.5.17, “SHOW ENGINES Statement”
Section 21.7, “The INFORMATION_SCHEMA ENGINES Table”

EVENTS

Section 20.4.4, “Event Metadata”
Section 20.4.2, “Event Scheduler Configuration”
Section 17.4.1.15, “Replication of Invoked Features”
Section 13.7.5.19, “SHOW EVENTS Statement”
Section 21.8, “The INFORMATION_SCHEMA EVENTS Table”

F

[index top]

FILES

Section 21.30, “INFORMATION_SCHEMA NDB Cluster Tables”
Section 18.5.12.1, “NDB Cluster Disk Data Objects”
Section 18.5.10, “ndbinfo: The NDB Cluster Information Database”
Section 21.30.1, “The INFORMATION_SCHEMA FILES Table”

G

[index top]

GLOBAL_STATUS

Section 18.5, “Management of NDB Cluster”
Section 18.5.16, “NDB API Statistics Counters and Variables”
Section 18.6, “NDB Cluster Replication”
Section 13.7.5.36, “SHOW STATUS Statement”
Section 21.9, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

GLOBAL_VARIABLES

Section 13.7.5.40, “SHOW VARIABLES Statement”
Section 21.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

I

[index top]

INFORMATION_SCHEMA

Section 14.18, “InnoDB INFORMATION_SCHEMA Tables”
MySQL Glossary
Section 5.2, “The MySQL Data Directory”

INFORMATION_SCHEMA.CHARACTER_SETS

Section A.11, “MySQL 5.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”

INFORMATION_SCHEMA.COLLATIONS

Section 10.14.2, “Choosing a Collation ID”

INFORMATION_SCHEMA.COLUMNS

Section A.11, “MySQL 5.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 18.4.14, “ndb_index_stat — NDB Index Statistics Utility”
Section 22.1, “Performance Schema Quick Start”

INFORMATION_SCHEMA.ENGINES

Section 14.1.3, “Checking InnoDB Availability”
Section 22.1, “Performance Schema Quick Start”
Section 18.5.9, “Quick Reference: NDB Cluster SQL Statements”

INFORMATION_SCHEMA.EVENTS

Section 20.4.4, “Event Metadata”
Section 17.4.1.15, “Replication of Invoked Features”
Section 20.8, “Restrictions on Stored Programs”
Section 20.4.6, “The Event Scheduler and MySQL Privileges”

INFORMATION_SCHEMA.FILES

Section 13.1.4, “ALTER LOGFILE GROUP Statement”
Section 13.1.8, “ALTER TABLESPACE Statement”
Section 13.1.14, “CREATE LOGFILE GROUP Statement”
Section 13.1.18, “CREATE TABLESPACE Statement”
Section 18.5.12.3, “NDB Cluster Disk Data Storage Requirements”
Section 18.4.10, “ndb_desc — Describe NDB Tables”

INFORMATION_SCHEMA.GLOBAL_STATUS

Section 18.5.16, “NDB API Statistics Counters and Variables”

INFORMATION_SCHEMA.INNODB_BUFFER_PAGE

Section 14.8.2, “Change Buffer”

INFORMATION_SCHEMA.INNODB_CMP

MySQL Glossary
Section 14.12.3, “Tuning Compression for InnoDB Tables”
Section 14.18.1.3, “Using the Compression Information Schema Tables”

INFORMATION_SCHEMA.INNODB_CMPMEM

Section 14.18.1.3, “Using the Compression Information Schema Tables”

INFORMATION_SCHEMA.INNODB_LOCK_WAITS

Section 14.18.2.1, “Using InnoDB Transaction and Locking Information”

INFORMATION_SCHEMA.INNODB_LOCKS

Section 14.18.2.1, “Using InnoDB Transaction and Locking Information”

INFORMATION_SCHEMA.INNODB_TRX

Section 14.17, “InnoDB Startup Options and System Variables”
Section 14.18.2.1, “Using InnoDB Transaction and Locking Information”

INFORMATION_SCHEMA.KEY_COLUMN_USAGE

Section 1.7.3.2, “FOREIGN KEY Constraints”
Section 13.1.17.6, “FOREIGN KEY Constraints”

INFORMATION_SCHEMA.PARTITIONS

Section 19.2.7, “How MySQL Partitioning Handles NULL”
Section 19.2.5, “KEY Partitioning”
Section 19.3.4, “Obtaining Information About Partitions”
Section 19.2.3.1, “RANGE COLUMNS partitioning”
Section 5.1.6, “Server Command Options”

INFORMATION_SCHEMA.PLUGINS

Section 14.18, “InnoDB INFORMATION_SCHEMA Tables”
Section 5.5.1, “Installing and Uninstalling Plugins”
Section 6.4.2.1, “Installing MySQL Enterprise Audit”
Section 5.5.2, “Obtaining Server Plugin Information”
Section 6.4.1.4, “PAM Pluggable Authentication”
Chapter 19, Partitioning
Section 24.2.2, “Plugin API Characteristics”
Section 24.2.3, “Plugin API Components”
Section 17.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 24.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 6.4.1.6, “Socket Peer-Credential Pluggable Authentication”
Section 6.4.1.7, “Test Pluggable Authentication”
Section 5.5.3.2, “Thread Pool Installation”
Section 6.4.1.5, “Windows Pluggable Authentication”
Section 24.2.4.8, “Writing Audit Plugins”
Section 24.2.4.5, “Writing Daemon Plugins”
Section 24.2.4.4, “Writing Full-Text Parser Plugins”
Section 24.2.4.6, “Writing INFORMATION_SCHEMA Plugins”
Section 24.2.4.9.1, “Writing the Server-Side Authentication Plugin”

INFORMATION_SCHEMA.PROCESSLIST

Section 12.15, “Information Functions”
Section 22.10.6.2, “The threads Table”
Section 14.18.2.1, “Using InnoDB Transaction and Locking Information”

INFORMATION_SCHEMA.ROUTINES

Section A.4, “MySQL 5.5 FAQ: Stored Procedures and Functions”

INFORMATION_SCHEMA.SESSION_STATUS

Section 18.5.16, “NDB API Statistics Counters and Variables”

INFORMATION_SCHEMA.STATISTICS

Section 14.11.10, “Configuring Optimizer Statistics for InnoDB”
Section 8.9.3, “Index Hints”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 18.4.14, “ndb_index_stat — NDB Index Statistics Utility”

INFORMATION_SCHEMA.TABLES

Section 18.5.14.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 13.1.7, “ALTER TABLE Statement”
Section 14.11.10, “Configuring Optimizer Statistics for InnoDB”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 5.1.6, “Server Command Options”

INFORMATION_SCHEMA.TRIGGERS

Section A.5, “MySQL 5.5 FAQ: Triggers”

INFORMATION_SCHEMA.VIEWS

Section 20.5.3, “Updatable and Insertable Views”

INNODB_BUFFER_PAGE

Section 14.8.2, “Change Buffer”
Section 14.18.3, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 21.29.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 21.29.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”

INNODB_BUFFER_PAGE_LRU

Section 14.18.3, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 21.29.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”

INNODB_BUFFER_POOL_STATS

Section 14.8.1, “Buffer Pool”
Section 14.18.3, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 21.29.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”

INNODB_CMP

Section 14.18.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 14.18.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 14.18.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 14.12.4, “Monitoring InnoDB Table Compression at Runtime”
Section 21.29.4, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 14.18.1.3, “Using the Compression Information Schema Tables”

INNODB_CMP_RESET

Section 14.18.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 14.18.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 14.18.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 21.29.4, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”

INNODB_CMPMEM

Section 14.18.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 14.18.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 21.29.5, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 14.18.1.3, “Using the Compression Information Schema Tables”

INNODB_CMPMEM_RESET

Section 14.18.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 14.18.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 21.29.5, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”

INNODB_LOCK_WAITS

Section 14.18.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 14.18.2.2, “InnoDB Lock and Lock-Wait Information”
Section 14.18.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 21.29.7, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”

INNODB_LOCKS

Section 14.18.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 14.18.2.2, “InnoDB Lock and Lock-Wait Information”
Section 14.18.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 21.29.7, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 21.29.6, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 21.29.8, “The INFORMATION_SCHEMA INNODB_TRX Table”

INNODB_METRICS

MySQL Glossary

INNODB_TRX

Section 14.18.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 14.18.2.2, “InnoDB Lock and Lock-Wait Information”
Section 14.18.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 21.29.6, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 21.29.8, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 14.18.2.1, “Using InnoDB Transaction and Locking Information”

K

[index top]

KEY_COLUMN_USAGE

Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 21.11, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”

N

[index top]

NDB_TRANSID_MYSQL_CONNECTION_MAP

Section 18.5.10.15, “The ndbinfo server_operations Table”
Section 18.5.10.16, “The ndbinfo server_transactions Table”

ndb_transid_mysql_connection_map

Section 21.30, “INFORMATION_SCHEMA NDB Cluster Tables”
Section 18.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 21.30.2, “The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table”

P

[index top]

PARAMETERS

Section A.4, “MySQL 5.5 FAQ: Stored Procedures and Functions”
Section 13.7.5.29, “SHOW PROCEDURE STATUS Statement”
Section 21.12, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 21.18, “The INFORMATION_SCHEMA ROUTINES Table”

PARTITIONS

Section 19.2.7, “How MySQL Partitioning Handles NULL”
Section 19.3.4, “Obtaining Information About Partitions”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Chapter 19, Partitioning
Section 13.7.5.37, “SHOW TABLE STATUS Statement”
Section 21.13, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 21.22, “The INFORMATION_SCHEMA TABLES Table”

PLUGINS

Section 13.7.3.3, “INSTALL PLUGIN Statement”
Section 5.5.2, “Obtaining Server Plugin Information”
Section 21.14, “The INFORMATION_SCHEMA PLUGINS Table”

PROCESSLIST

Section 8.14, “Examining Thread Information”
Section 13.7.6.4, “KILL Statement”
Section 14.18.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 13.7.5.30, “SHOW PROCESSLIST Statement”
Section 21.29.8, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 21.15, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 14.18.2.1, “Using InnoDB Transaction and Locking Information”

PROFILING

Section 13.7.5.31, “SHOW PROFILE Statement”
Section 21.16, “The INFORMATION_SCHEMA PROFILING Table”

R

[index top]

REFERENTIAL_CONSTRAINTS

Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 21.17, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

ROUTINES

Section 21.1, “Introduction”
Section A.4, “MySQL 5.5 FAQ: Stored Procedures and Functions”
Section 13.7.5.29, “SHOW PROCEDURE STATUS Statement”
Section 20.2.3, “Stored Routine Metadata”
Section 21.18, “The INFORMATION_SCHEMA ROUTINES Table”

S

[index top]

SCHEMA_PRIVILEGES

Section 21.20, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”

SCHEMATA

Section 6.2.3, “Grant Tables”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.7, “Server System Variables”
Section 13.7.5.15, “SHOW DATABASES Statement”
Section 21.19, “The INFORMATION_SCHEMA SCHEMATA Table”

SESSION_STATUS

Section 18.5, “Management of NDB Cluster”
Section 18.5.16, “NDB API Statistics Counters and Variables”
Section 18.6, “NDB Cluster Replication”
Section 13.7.5.36, “SHOW STATUS Statement”
Section 21.9, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

SESSION_VARIABLES

Section 13.7.5.40, “SHOW VARIABLES Statement”
Section 21.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

STATISTICS

Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 13.7.5.23, “SHOW INDEX Statement”
Section 21.21, “The INFORMATION_SCHEMA STATISTICS Table”

T

[index top]

TABLE_CONSTRAINTS

Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 21.17, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”
Section 21.24, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

TABLE_PRIVILEGES

Section 21.25, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

TABLES

Section 21.1, “Introduction”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 13.7.5.37, “SHOW TABLE STATUS Statement”
Section 13.7.5.38, “SHOW TABLES Statement”
Section 21.22, “The INFORMATION_SCHEMA TABLES Table”

TABLESPACES

Section 21.23, “The INFORMATION_SCHEMA TABLESPACES Table”

TP_THREAD_GROUP_STATE

Section 21.31, “INFORMATION_SCHEMA Thread Pool Tables”
Section 21.31.1, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 5.5.3.1, “Thread Pool Components”

TP_THREAD_GROUP_STATS

Section 21.31, “INFORMATION_SCHEMA Thread Pool Tables”
Section 21.31.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”
Section 21.31.3, “The INFORMATION_SCHEMA TP_THREAD_STATE Table”
Section 5.5.3.1, “Thread Pool Components”

TP_THREAD_STATE

Section 21.31, “INFORMATION_SCHEMA Thread Pool Tables”
Section 21.31.1, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 21.31.3, “The INFORMATION_SCHEMA TP_THREAD_STATE Table”
Section 5.5.3.1, “Thread Pool Components”
Section 5.5.3.2, “Thread Pool Installation”

TRIGGERS

Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 13.7.5.13, “SHOW CREATE TRIGGER Statement”
Section 13.7.5.39, “SHOW TRIGGERS Statement”
Section 21.26, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 20.3.2, “Trigger Metadata”

U

[index top]

USER_PRIVILEGES

Section 21.27, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

V

[index top]

VIEWS

Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 13.7.5.14, “SHOW CREATE VIEW Statement”
Section 21.28, “The INFORMATION_SCHEMA VIEWS Table”
Section 20.5.5, “View Metadata”