Hosting guebs

INFORMATION_SCHEMA Index

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

C

[index top]

CHARACTER_SETS

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

COLLATION_CHARACTER_SET_APPLICABILITY

Section 19.3, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”

COLLATIONS

Section 10.1.9.3, “SHOW Statements and INFORMATION_SCHEMA
Section 21.8.1, “C API Data Structures”
Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.2, “The INFORMATION_SCHEMA COLLATIONS Table”

COLUMN_PRIVILEGES

Section 19.5, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

COLUMNS

Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.4, “The INFORMATION_SCHEMA COLUMNS Table”
Section 19.13, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 19.19, “The INFORMATION_SCHEMA ROUTINES Table”

E

[index top]

ENGINES

Section 19.6, “The INFORMATION_SCHEMA ENGINES Table”

EVENTS

Section 18.4.4, “Event Metadata”
Section 18.4.2, “Event Scheduler Configuration”
Section 16.4.1.10, “Replication of Invoked Features”
Section 19.7, “The INFORMATION_SCHEMA EVENTS Table”

F

[index top]

FILES

Section 19.8, “The INFORMATION_SCHEMA FILES Table”

G

[index top]

GLOBAL_STATUS

Section 19.9, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

GLOBAL_VARIABLES

Section 19.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

I

[index top]

INFORMATION_SCHEMA GLOBAL_STATUS

Section 19.9, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

INFORMATION_SCHEMA GLOBAL_VARIABLES

Section 19.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 20.1, “Performance Schema Quick Start”

INFORMATION_SCHEMA.ENGINES

Section 20.1, “Performance Schema Quick Start”

INFORMATION_SCHEMA.EVENTS

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

INFORMATION_SCHEMA.INNODB_CMP

Section 5.4.6.3, “Tuning Compression for InnoDB Tables”

INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 5.4.6.3, “Tuning Compression for InnoDB Tables”

information_schema.innodb_ft_default_stopword

Section 12.9.4, “Full-Text Stopwords”

information_schema.innodb_metrics

Section 14.2.6, “InnoDB Startup Options and System Variables”

INFORMATION_SCHEMA.KEY_COLUMN_USAGE

Section 1.8.6.2, “FOREIGN KEY Constraints”
Section 5.4.5, “InnoDB and FOREIGN KEY Constraints”
Section 13.1.14.2, “Using FOREIGN KEY Constraints”

INFORMATION_SCHEMA.OPTIMIZER_TRACE

Section 1.4, “What Is New in MySQL 5.6”

INFORMATION_SCHEMA.PARTITIONS

Section 17.2.5, “KEY Partitioning”
Section 17.2.3.1, “RANGE COLUMNS partitioning”
Section 17.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 17.2.7, “How MySQL Partitioning Handles NULL
Section 17.3.5, “Obtaining Information About Partitions”
Section 5.1.3, “Server Command Options”
Section 19.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.11.1, “Installing the Audit Log Plugin”
Section 6.3.7.3.1, “Installing the PAM Authentication Plugin”
Section 6.3.7.4.1, “Installing the Windows Authentication Plugin”
Section 5.1.8.2, “Obtaining Server Plugin Information”
Section 6.1.2.6.1, “Password Validation Plugin Installation”
Section 22.2.1, “Plugin API Characteristics”
Section 22.2.2, “Plugin API Components”
Section 16.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 8.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.10, “Writing Password-Validation Plugins”
Section 22.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 20.4, “Performance Schema Instrument Naming Conventions”
Section 20.9.4, “Performance Schema Stage Event Tables”
Section 19.16, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 20.9.9.3, “The threads Table”

INFORMATION_SCHEMA.ROUTINES

Chapter 19, INFORMATION_SCHEMA Tables
Section 21.2.6, “Connector/Net Connection String Options Reference”
Section 19.19, “The INFORMATION_SCHEMA ROUTINES Table”

INFORMATION_SCHEMA.TABLE_CONSTRAINTS

Section 19.18, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

information_schema.table_constraints

Section 5.5.1, “Overview of Online DDL”

INFORMATION_SCHEMA.TABLES

Chapter 19, INFORMATION_SCHEMA Tables
Section 5.1.3, “Server Command Options”

INFORMATION_SCHEMA.TRIGGERS

Section 13.7.5.39, “SHOW TRIGGERS Syntax”

INFORMATION_SCHEMA.VIEWS

Section 18.5.3, “Updatable and Insertable Views”

INNODB_CMP

Section 5.4.6.4, “Monitoring Compression at Runtime”

INNODB_CMP_PER_INDEX

Section 5.4.6.4, “Monitoring Compression at Runtime”

INNODB_FT_BEING_DELETED

Section 14.2.3.12.3, “FULLTEXT Indexes”

innodb_ft_being_deleted

Section 14.2.6, “InnoDB Startup Options and System Variables”

INNODB_FT_CONFIG

Section 14.2.3.12.3, “FULLTEXT Indexes”

innodb_ft_config

Section 14.2.6, “InnoDB Startup Options and System Variables”

INNODB_FT_DEFAULT_STOPWORD

Section 14.2.3.12.3, “FULLTEXT Indexes”

innodb_ft_default_stopword

Section 12.9.4, “Full-Text Stopwords”

INNODB_FT_DELETED

Section 14.2.3.12.3, “FULLTEXT Indexes”
Section 19.30.24, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”

innodb_ft_deleted

Section 14.2.6, “InnoDB Startup Options and System Variables”

INNODB_FT_INDEX_CACHE

Section 14.2.3.12.3, “FULLTEXT Indexes”

innodb_ft_index_cache

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 19.30.22, “The INFORMATION_SCHEMA INNODB_FT_INSERTED Table”

INNODB_FT_INDEX_TABLE

Section 14.2.3.12.3, “FULLTEXT Indexes”

innodb_ft_index_table

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 19.30.22, “The INFORMATION_SCHEMA INNODB_FT_INSERTED Table”

INNODB_FT_INSERTED

Section 14.2.3.12.3, “FULLTEXT Indexes”

innodb_ft_inserted

Section 14.2.6, “InnoDB Startup Options and System Variables”

INNODB_SYS_FOREIGN

Section 1.8.6.2, “FOREIGN KEY Constraints”
Section 5.4.5, “InnoDB and FOREIGN KEY Constraints”
Section 13.1.14.2, “Using FOREIGN KEY Constraints”

INNODB_SYS_FOREIGN_COLS

Section 1.8.6.2, “FOREIGN KEY Constraints”
Section 5.4.5, “InnoDB and FOREIGN KEY Constraints”
Section 13.1.14.2, “Using FOREIGN KEY Constraints”

INNODB_SYS_INDEXES

Section 14.2.3.12.3, “FULLTEXT Indexes”

INNODB_SYS_TABLES

Section 14.2.3.12.3, “FULLTEXT Indexes”

K

[index top]

KEY_COLUMN_USAGE

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

O

[index top]

OPTIMIZER_TRACE

Section 19.12, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”

P

[index top]

PARAMETERS

Section 19.13, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 19.19, “The INFORMATION_SCHEMA ROUTINES Table”

PARTITIONS

Section 17.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 17.2.7, “How MySQL Partitioning Handles NULL
Section 17.3.5, “Obtaining Information About Partitions”
Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Chapter 17, Partitioning
Section 19.14, “The INFORMATION_SCHEMA PARTITIONS Table”

PLUGINS

Section 5.1.8.2, “Obtaining Server Plugin Information”
Section 19.15, “The INFORMATION_SCHEMA PLUGINS Table”

PROCESSLIST

Section 13.7.5.30, “SHOW PROCESSLIST Syntax”
Section 8.12.5, “Examining Thread Information”
Section 19.16, “The INFORMATION_SCHEMA PROCESSLIST Table”

PROFILING

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

R

[index top]

REFERENTIAL_CONSTRAINTS

Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.18, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”

ROUTINES

Section 13.7.5.29, “SHOW PROCEDURE STATUS Syntax”
Section 18.2.3, “Stored Routine Metadata”
Section 19.13, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 19.19, “The INFORMATION_SCHEMA ROUTINES Table”

S

[index top]

SCHEMA_PRIVILEGES

Section 19.21, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”

SCHEMATA

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

SESSION_STATUS

Section 19.9, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

SESSION_VARIABLES

Section 19.10, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

STATISTICS

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

T

[index top]

TABLE_CONSTRAINTS

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

TABLE_PRIVILEGES

Section 19.26, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

TABLES

Chapter 19, INFORMATION_SCHEMA Tables
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.23, “The INFORMATION_SCHEMA TABLES Table”

TABLESPACES

Section 19.24, “The INFORMATION_SCHEMA TABLESPACES Table”

TP_THREAD_GROUP_STATE

Section 19.31.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 19.31, “Thread Pool INFORMATION_SCHEMA Tables”
Section 8.11.6.1, “Thread Pool Components and Installation”

TP_THREAD_GROUP_STATS

Section 19.31.1, “The INFORMATION_SCHEMA TP_THREAD_STATE Table”
Section 19.31, “Thread Pool INFORMATION_SCHEMA Tables”
Section 8.11.6.1, “Thread Pool Components and Installation”

TP_THREAD_STATE

Section 19.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 8.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 19.27, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 18.3.2, “Trigger Metadata”

U

[index top]

USER_PRIVILEGES

Section 19.28, “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 19.29, “The INFORMATION_SCHEMA VIEWS Table”
Section 18.5.4, “View Metadata”