Skip navigation links
MySQL 5.5 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 19.1, “The INFORMATION_SCHEMA CHARACTER_SETS Table”

COLLATIONS

Section 9.1.9.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 21.9.1, “C API Data Structures”
Section 7.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.2, “The INFORMATION_SCHEMA COLLATIONS Table”

COLLATION_CHARACTER_SET_APPLICABILITY

Section 19.3, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”

COLUMNS

Section 7.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.4, “The INFORMATION_SCHEMA COLUMNS Table”
Section 19.12, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 19.18, “The INFORMATION_SCHEMA ROUTINES Table”

COLUMN_PRIVILEGES

Section 19.5, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

ENGINES

Section 16.5.8, “Quick Reference: MySQL Cluster SQL Statements”
Section 19.6, “The INFORMATION_SCHEMA ENGINES Table”
Section 1.4, “What Is New in MySQL 5.5”

EVENTS

Section 18.4.4, “Event Metadata”
Section 18.4.2, “Event Scheduler Configuration”
Section 15.4.1.8, “Replication of Invoked Features”
Section 19.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 1.4, “What Is New in MySQL 5.5”

FILES

Section 16.5.11.1, “MySQL Cluster Disk Data Objects”
Section 19.8, “The INFORMATION_SCHEMA FILES Table”
Section 1.4, “What Is New in MySQL 5.5”

GLOBAL_STATUS

Section 16.5, “Management of MySQL Cluster”
Section 16.6, “MySQL Cluster Replication”
Section 16.5.14, “NDB API Statistics Counters and Variables”
Section 19.9, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
Section 19.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

GLOBAL_VARIABLES

Section 19.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

INFORMATION_SCHEMA.COLLATIONS

Section 9.4.2, “Choosing a Collation ID”

INFORMATION_SCHEMA.COLUMNS

Section 20.1, “Performance Schema Quick Start”

INFORMATION_SCHEMA.ENGINES

Section 20.1, “Performance Schema Quick Start”
Section 16.5.8, “Quick Reference: MySQL Cluster SQL Statements”

INFORMATION_SCHEMA.EVENTS

Section 12.7.5.19, “SHOW EVENTS Syntax”
Section 18.4.4, “Event Metadata”
Section 15.4.1.8, “Replication of Invoked Features”
Section E.1, “Restrictions on Stored Programs”
Section 18.4.6, “The Event Scheduler and MySQL Privileges”

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 16.5.11.3, “MySQL Cluster Disk Data Storage Requirements”

INFORMATION_SCHEMA.GLOBAL_STATUS

Section 16.5.14, “NDB API Statistics Counters and Variables”

INFORMATION_SCHEMA.OPTIMIZER_TRACE

Section 1.4, “What Is New in MySQL 5.5”

INFORMATION_SCHEMA.PARTITIONS

Section 17.2.5, “KEY Partitioning”
Section 17.2.3.1, “RANGE COLUMNS partitioning”
Section 17.2.7, “How MySQL Partitioning Handles NULL”
Section 17.3.4, “Obtaining Information About Partitions”
Section 19.13, “The INFORMATION_SCHEMA PARTITIONS Table”

INFORMATION_SCHEMA.PLUGINS

Section 12.7.3.3, “INSTALL PLUGIN Syntax”
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 5.5.6.2.1, “Installing the PAM Authentication Plugin”
Section 5.5.6.3.1, “Installing the Windows Authentication Plugin”
Section 5.1.7.2, “Obtaining Server Plugin Information”
Section 22.2.1, “Plugin API Characteristics”
Section 22.2.2, “Plugin API Components”
Section 15.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 7.11.6.1, “Thread Pool Components and Installation”
Section 22.2.4.6, “Writing INFORMATION_SCHEMA Plugins”
Section 22.2.4.8, “Writing Audit Plugins”
Section 22.2.4.5, “Writing Daemon Plugins”
Section 22.2.4.4, “Writing Full-Text Parser Plugins”
Section 22.2.4.9.1, “Writing the Server-Side Authentication Plugin”

INFORMATION_SCHEMA.PROCESSLIST

Section 12.7.5.30, “SHOW PROCESSLIST Syntax”
Section 7.12.5, “Examining Thread Information”
Section 20.4, “Performance Schema Instrument Naming Conventions”
Section 19.15, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 20.7.5.2, “The threads Table”

INFORMATION_SCHEMA.ROUTINES

Chapter 19, INFORMATION_SCHEMA Tables
Section 19.18, “The INFORMATION_SCHEMA ROUTINES Table”

INFORMATION_SCHEMA.SESSION_STATUS

Section 16.5.14, “NDB API Statistics Counters and Variables”

INFORMATION_SCHEMA.TABLES

Chapter 19, INFORMATION_SCHEMA Tables
Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Chapter 17, Partitioning

INFORMATION_SCHEMA.TABLE_CONSTRAINTS

Section 19.17, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

INFORMATION_SCHEMA.TRIGGERS

Section 12.7.5.39, “SHOW TRIGGERS Syntax”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

INFORMATION_SCHEMA.VIEWS

Section 18.5.3, “Updatable and Insertable Views”

INNODB_CMP

Section 19.29.1, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”

INNODB_CMPMEM

Section 19.29.2, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”

INNODB_LOCKS

Section 19.29.4, “The INFORMATION_SCHEMA INNODB_LOCKS Table”

INNODB_LOCK_WAITS

Section 19.29.5, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”

INNODB_TRX

Section 19.29.3, “The INFORMATION_SCHEMA INNODB_TRX Table”

KEY_COLUMN_USAGE

Section 7.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.11, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”

PARAMETERS

Section 19.12, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 19.18, “The INFORMATION_SCHEMA ROUTINES Table”

PARTITIONS

Section 17.2.7, “How MySQL Partitioning Handles NULL”
Section 17.3.4, “Obtaining Information About Partitions”
Section 7.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Chapter 17, Partitioning
Section 19.13, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 1.4, “What Is New in MySQL 5.5”

PLUGINS

Section 5.1.7.2, “Obtaining Server Plugin Information”
Section 19.6, “The INFORMATION_SCHEMA ENGINES Table”
Section 19.14, “The INFORMATION_SCHEMA PLUGINS Table”
Section 1.4, “What Is New in MySQL 5.5”

PROCESSLIST

Section 12.7.5.30, “SHOW PROCESSLIST Syntax”
Section 7.12.5, “Examining Thread Information”
Section 19.15, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 1.4, “What Is New in MySQL 5.5”

PROFILING

Section 12.7.5.32, “SHOW PROFILES Syntax”
Section 19.16, “The INFORMATION_SCHEMA PROFILING Table”

REFERENTIAL_CONSTRAINTS

Section 7.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.17, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

ROUTINES

Section 12.7.5.29, “SHOW PROCEDURE STATUS Syntax”
Section 18.2.3, “Stored Routine Metadata”
Section 19.12, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 19.18, “The INFORMATION_SCHEMA ROUTINES Table”

SCHEMATA

Section 5.4.2, “Privilege System Grant Tables”
Section 19.19, “The INFORMATION_SCHEMA SCHEMATA Table”

SCHEMA_PRIVILEGES

Section 19.20, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”

SESSION_STATUS

Section 16.5, “Management of MySQL Cluster”
Section 16.6, “MySQL Cluster Replication”
Section 16.5.14, “NDB API Statistics Counters and Variables”
Section 19.9, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
Section 19.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

SESSION_VARIABLES

Section 19.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

STATISTICS

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.21, “The INFORMATION_SCHEMA STATISTICS Table”

TABLES

Chapter 19, INFORMATION_SCHEMA Tables
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.22, “The INFORMATION_SCHEMA TABLES Table”

TABLESPACES

Section 19.23, “The INFORMATION_SCHEMA TABLESPACES Table”

TABLE_CONSTRAINTS

Section 7.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.24, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

TABLE_PRIVILEGES

Section 19.25, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

TP_THREAD_GROUP_STATE

Section 19.30.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 19.30, “Thread Pool INFORMATION_SCHEMA Tables”
Section 7.11.6.1, “Thread Pool Components and Installation”

TP_THREAD_GROUP_STATS

Section 19.30.1, “The INFORMATION_SCHEMA TP_THREAD_STATE Table”
Section 19.30, “Thread Pool INFORMATION_SCHEMA Tables”
Section 7.11.6.1, “Thread Pool Components and Installation”

TP_THREAD_STATE

Section 19.30, “Thread Pool INFORMATION_SCHEMA Tables”
Section 7.11.6.1, “Thread Pool Components and Installation”

TRIGGERS

Section 12.7.5.13, “SHOW CREATE TRIGGER Syntax”
Section 7.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.26, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 18.3.2, “Trigger Metadata”

USER_PRIVILEGES

Section 19.27, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

VIEWS

Section 12.7.5.14, “SHOW CREATE VIEW Syntax”
Section 7.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.28, “The INFORMATION_SCHEMA VIEWS Table”
Section 18.5.4, “View Metadata”

information_schema.innodb_ft_default_stopword

Section 11.9.4, “Full-Text Stopwords”

information_schema.innodb_metrics

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_ft_being_deleted

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_ft_config

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_ft_default_stopword

Section 11.9.4, “Full-Text Stopwords”

innodb_ft_deleted

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_ft_index_cache

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_ft_index_table

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_ft_inserted

Section 13.3.4, “InnoDB Startup Options and System Variables”
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices