Skip navigation links

MySQL 5.6 Reference Manual :: INFORMATION_SCHEMA Index

« Function Index

Join Types Index »

Section Navigation [Toggle]

`INFORMATION_SCHEMA` Index

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

C

`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 10.1.9.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 22.8.5, “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.13, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 20.19, “The INFORMATION_SCHEMA ROUTINES Table”

E

`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.11, “Replication of Invoked Features”
Section 20.7, “The INFORMATION_SCHEMA EVENTS Table”

F

`FILES`

Section 17.5.12.1, “MySQL Cluster Disk Data Objects”
Section 17.5.10, “The ndbinfo MySQL Cluster Information Database”

G

`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.9, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

`GLOBAL_VARIABLES`

Section 20.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

I

`INFORMATION_SCHEMA GLOBAL_STATUS`

Section 20.9, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

`INFORMATION_SCHEMA GLOBAL_VARIABLES`

Section 20.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

`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.11, “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.10, “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.INNODB_CMP`

Section 14.2.7.3, “Tuning Compression for InnoDB Tables”
Section 14.2.12.3.1.3, “Using the Compression Information Schema Tables”

`INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.7.3, “Tuning Compression for InnoDB Tables”

`INFORMATION_SCHEMA.INNODB_CMPMEM`

Section 14.2.12.3.1.3, “Using the Compression Information Schema Tables”

`information_schema.innodb_ft_default_stopword`

Section 12.9.4, “Full-Text Stopwords”

`INFORMATION_SCHEMA.INNODB_METRICS`

Section 14.2.13, “InnoDB Startup Options and System Variables”

`INFORMATION_SCHEMA.KEY_COLUMN_USAGE`

Section 1.8.3.2, “FOREIGN KEY Constraints”
Section 14.2.6.6, “InnoDB and FOREIGN KEY Constraints”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”
Section 13.1.17.2, “Using FOREIGN KEY Constraints”

`INFORMATION_SCHEMA.OPTIMIZER_TRACE`

Section 1.4, “What Is New in MySQL 5.6”

`INFORMATION_SCHEMA.PARTITIONS`

Section 18.2.5, “KEY Partitioning”
Section 18.2.3.1, “RANGE COLUMNS partitioning”
Section 18.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 18.2.7, “How MySQL Partitioning Handles NULL”
Section 18.3.5, “Obtaining Information About Partitions”
Section 5.1.3, “Server Command Options”
Section 20.14, “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.12.1, “Installing the Audit Log Plugin”
Section 6.3.8.5.1, “Installing the PAM Authentication Plugin”
Section 6.3.8.6.1, “Installing the Windows Authentication Plugin”
Section 5.1.8.2, “Obtaining Server Plugin Information”
Chapter 18, Partitioning
Section 6.1.2.6.1, “Password Validation Plugin Installation”
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.10, “Writing Password-Validation Plugins”
Section 23.2.4.9.1, “Writing the Server-Side Authentication Plugin”

`INFORMATION_SCHEMA.PROCESSLIST`

Section 13.7.5.30, “SHOW PROCESSLIST Syntax”
Section 8.12.5, “Examining Thread Information”
Section 21.4, “Performance Schema Instrument Naming Conventions”
Section 21.9.5, “Performance Schema Stage Event Tables”
Section 20.16, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 21.9.10.3, “The threads Table”

`INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS`

Section 1.8.2.4, “Foreign Key Differences”

`INFORMATION_SCHEMA.ROUTINES`

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

`INFORMATION_SCHEMA.SESSION_STATUS`

Section 17.5.15, “NDB API Statistics Counters and Variables”

`INFORMATION_SCHEMA.TABLE_CONSTRAINTS`

Section 1.8.2.4, “Foreign Key Differences”
Section 20.18, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`information_schema.table_constraints`

Section 14.2.12.2.33, “Online DDL”
Section 14.2.11.1, “Overview of Online DDL”

`INFORMATION_SCHEMA.TABLES`

Chapter 20, INFORMATION_SCHEMA Tables
Section 17.5.13.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 5.1.3, “Server Command Options”

`INFORMATION_SCHEMA.VIEWS`

Section 19.5.3, “Updatable and Insertable Views”

`innodb_buffer_page_lru`

Section 14.2.12.2.8, “Faster Restart by Preloading the InnoDB Buffer Pool”

`INNODB_CMP`

Section 14.2.12.3, “InnoDB INFORMATION_SCHEMA tables”
Section 14.2.12.3.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 14.2.12.3.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 14.2.7.4, “Monitoring Compression at Runtime”
Section 14.2.12.3.1.3, “Using the Compression Information Schema Tables”

`INNODB_CMP_PER_INDEX`

Section 14.2.7.4, “Monitoring Compression at Runtime”
Section 14.2.12.3.1.3, “Using the Compression Information Schema Tables”

`INNODB_CMP_RESET`

Section 14.2.12.3, “InnoDB INFORMATION_SCHEMA tables”
Section 14.2.12.3.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 14.2.12.3.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”

`INNODB_CMPMEM`

Section 14.2.12.3, “InnoDB INFORMATION_SCHEMA tables”
Section 14.2.12.3.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 14.2.12.3.1.3, “Using the Compression Information Schema Tables”

`INNODB_CMPMEM_RESET`

Section 14.2.12.3, “InnoDB INFORMATION_SCHEMA tables”
Section 14.2.12.3.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”

`INNODB_FT_BEING_DELETED`

Section 14.2.2.13.3, “FULLTEXT Indexes”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.3.3, “Information Schema Tables about Full-Text Search”

`INNODB_FT_CONFIG`

Section 14.2.2.13.3, “FULLTEXT Indexes”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.3.3, “Information Schema Tables about Full-Text Search”

`INNODB_FT_DEFAULT_STOPWORD`

Section 14.2.2.13.3, “FULLTEXT Indexes”
Section 14.2.12.3.3, “Information Schema Tables about Full-Text Search”

`innodb_ft_default_stopword`

Section 12.9.4, “Full-Text Stopwords”

`INNODB_FT_DELETED`

Section 14.2.2.13.3, “FULLTEXT Indexes”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.3.3, “Information Schema Tables about Full-Text Search”
Section 20.30.25, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”

`INNODB_FT_INDEX_CACHE`

Section 14.2.2.13.3, “FULLTEXT Indexes”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.3.3, “Information Schema Tables about Full-Text Search”

`INNODB_FT_INDEX_TABLE`

Section 14.2.2.13.3, “FULLTEXT Indexes”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.3.3, “Information Schema Tables about Full-Text Search”

`INNODB_LOCK_WAITS`

Section 14.2.12.3, “InnoDB INFORMATION_SCHEMA tables”
Section 14.2.12.3.2, “Information Schema Tables about Transactions”
Section 14.2.12.3.4.3, “Possible Inconsistency with PROCESSLIST”
Section 14.2.12.3.4.1, “Understanding InnoDB Locking”

`INNODB_LOCKS`

Section 14.2.12.3, “InnoDB INFORMATION_SCHEMA tables”
Section 14.2.12.3.2, “Information Schema Tables about Transactions”
Section 14.2.12.3.4.3, “Possible Inconsistency with PROCESSLIST”
Section 14.2.12.3.4.1, “Understanding InnoDB Locking”

`INNODB_SYS_FOREIGN`

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

`INNODB_SYS_FOREIGN_COLS`

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

`INNODB_SYS_INDEXES`

Section 14.2.2.13.3, “FULLTEXT Indexes”

`INNODB_SYS_TABLES`

Section 14.2.2.13.3, “FULLTEXT Indexes”

`INNODB_TRX`

Section 14.2.12.3, “InnoDB INFORMATION_SCHEMA tables”
Section 14.2.12.3.2, “Information Schema Tables about Transactions”
Section 14.2.12.3.4.3, “Possible Inconsistency with PROCESSLIST”

K

`KEY_COLUMN_USAGE`

Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 20.11, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”

N

`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 17.3.4.2, “MySQL Server Options for MySQL Cluster”

O

`OPTIMIZER_TRACE`

Section 20.12, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”

P

`PARAMETERS`

Section 20.13, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 20.19, “The INFORMATION_SCHEMA ROUTINES Table”

`PARTITIONS`

Section 18.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 18.2.7, “How MySQL Partitioning Handles NULL”
Section 18.3.5, “Obtaining Information About Partitions”
Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Chapter 18, Partitioning
Section 20.14, “The INFORMATION_SCHEMA PARTITIONS Table”

`PLUGINS`

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

`PROCESSLIST`

Section 13.7.5.30, “SHOW PROCESSLIST Syntax”
Section 8.12.5, “Examining Thread Information”
Section 14.2.12.3.4.3, “Possible Inconsistency with PROCESSLIST”
Section 20.16, “The INFORMATION_SCHEMA PROCESSLIST Table”

`PROFILING`

Section 13.7.5.31, “SHOW PROFILE Syntax”
Section 20.17, “The INFORMATION_SCHEMA PROFILING Table”

R

`REFERENTIAL_CONSTRAINTS`

Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 20.18, “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.13, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 20.19, “The INFORMATION_SCHEMA ROUTINES Table”

S

`SCHEMA_PRIVILEGES`

Section 20.21, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”

`SCHEMATA`

Section 6.2.2, “Privilege System Grant Tables”
Section 20.20, “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.9, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

`SESSION_VARIABLES`

Section 20.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

`STATISTICS`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 20.22, “The INFORMATION_SCHEMA STATISTICS Table”

T

`TABLE_CONSTRAINTS`

Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 20.25, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

`TABLE_PRIVILEGES`

Section 20.26, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

`TABLES`

Chapter 20, INFORMATION_SCHEMA Tables
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 20.23, “The INFORMATION_SCHEMA TABLES Table”

`TABLESPACES`

Section 20.24, “The INFORMATION_SCHEMA TABLESPACES Table”

`TP_THREAD_GROUP_STATE`

Section 20.31.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 20.31, “Thread Pool INFORMATION_SCHEMA Tables”
Section 8.11.6.1, “Thread Pool Components and Installation”

`TP_THREAD_GROUP_STATS`

Section 20.31.1, “The INFORMATION_SCHEMA TP_THREAD_STATE Table”
Section 20.31, “Thread Pool INFORMATION_SCHEMA Tables”
Section 8.11.6.1, “Thread Pool Components and Installation”

`TP_THREAD_STATE`

Section 20.31, “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 13.7.5.39, “SHOW TRIGGERS Syntax”
Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 20.27, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.3.2, “Trigger Metadata”

U

`USER_PRIVILEGES`

Section 20.28, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

V

`VIEWS`

Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 20.29, “The INFORMATION_SCHEMA VIEWS Table”
Section 19.5.4, “View Metadata”

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents

© 2014, Oracle Corporation and/or its affiliates