MySQL :: MySQL 5.7 Reference Manual :: INFORMATION_SCHEMA Index

Skip to Main Content

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

version 5.7

9.1
9.0
8.4 current
8.0

MySQL 5.7 Reference Manual / Indexes / INFORMATION_SCHEMA Index

INFORMATION_SCHEMA Index

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

C

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.3, “SHOW CHARACTER SET Statement”
Section 10.10, “Supported Character Sets and Collations”
Section 10.3.4, “Table Character Set and Collation”
Section 24.3.2, “The INFORMATION_SCHEMA CHARACTER_SETS Table”

COLLATION_CHARACTER_SET_APPLICABILITY

Section 24.3.4, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”

COLLATIONS

Section 10.15, “Character Set Configuration”
Section 10.2, “Character Sets and Collations in MySQL”
Section 10.14.2, “Choosing a Collation ID”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 13.7.5.4, “SHOW COLLATION Statement”
Section 24.3.3, “The INFORMATION_SCHEMA COLLATIONS Table”

COLUMN_PRIVILEGES

Section 24.3.6, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

COLUMNS

Section 13.1.18, “CREATE TABLE Statement”
Section 21.5.15, “ndb_index_stat — NDB Index Statistics Utility”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 5.1.7, “Server System Variables”
Section 13.7.5.5, “SHOW COLUMNS Statement”
Section 24.3.5, “The INFORMATION_SCHEMA COLUMNS Table”
Section 24.4.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 24.4.3, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 24.4.4, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”
Section 24.4.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 24.4.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 24.4.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 24.4.8, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 24.4.9, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
Section 24.4.10, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”
Section 24.4.11, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 24.4.12, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 24.4.13, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
Section 24.4.15, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 24.4.14, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 24.4.16, “The INFORMATION_SCHEMA INNODB_METRICS Table”
Section 24.4.17, “The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table”
Section 24.4.18, “The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table”
Section 24.4.19, “The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table”
Section 24.4.20, “The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table”
Section 24.4.21, “The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table”
Section 24.4.22, “The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table”
Section 24.4.23, “The INFORMATION_SCHEMA INNODB_SYS_TABLES Table”
Section 24.4.24, “The INFORMATION_SCHEMA INNODB_SYS_TABLESPACES Table”
Section 24.4.25, “The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View”
Section 24.4.26, “The INFORMATION_SCHEMA INNODB_SYS_VIRTUAL Table”
Section 24.4.27, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”
Section 24.4.28, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 2.10.4, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”

CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS

Section 6.4.2.1, “Connection-Control Plugin Installation”
Section 6.4.2.2, “Connection-Control System and Status Variables”
Section 6.4.2, “The Connection-Control Plugins”
Section 24.6.2, “The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table”

E

ENGINES

Section 25.1, “Performance Schema Quick Start”
Section 21.6.17, “Quick Reference: NDB Cluster SQL Statements”
Section 5.1.7, “Server System Variables”
Section 13.7.5.16, “SHOW ENGINES Statement”
Section 24.3.7, “The INFORMATION_SCHEMA ENGINES Table”
Section 14.1.3, “Verifying that InnoDB is the Default Storage Engine”

EVENTS

Section 23.4.4, “Event Metadata”
Section 23.4.2, “Event Scheduler Configuration”
Section 16.4.1.16, “Replication of Invoked Features”
Section 23.8, “Restrictions on Stored Programs”
Section 13.7.5.18, “SHOW EVENTS Statement”
Section 23.4.6, “The Event Scheduler and MySQL Privileges”
Section 24.3.8, “The INFORMATION_SCHEMA EVENTS Table”

F

FILES

Section 13.1.5, “ALTER LOGFILE GROUP Statement”
Section 13.1.9, “ALTER TABLESPACE Statement”
Section 13.1.15, “CREATE LOGFILE GROUP Statement”
Section 13.1.19, “CREATE TABLESPACE Statement”
Section 21.6.16, “INFORMATION_SCHEMA Tables for NDB Cluster”
Section 21.6.11.1, “NDB Cluster Disk Data Objects”
Section 21.6.11.3, “NDB Cluster Disk Data Storage Requirements”
Section 21.5.10, “ndb_desc — Describe NDB Tables”
Section 21.6.15, “ndbinfo: The NDB Cluster Information Database”
Section 6.2.2, “Privileges Provided by MySQL”
Section 14.16.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 24.3.9, “The INFORMATION_SCHEMA FILES Table”
Section 24.4.18, “The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table”
Section 24.4.24, “The INFORMATION_SCHEMA INNODB_SYS_TABLESPACES Table”
Section 24.3.26, “The INFORMATION_SCHEMA TABLESPACES Table”
Section 21.6.15.15, “The ndbinfo dict_obj_info Table”
Section 21.6.15.23, “The ndbinfo logbuffers Table”
Section 21.6.15.24, “The ndbinfo logspaces Table”
Section 14.6.3.5, “The Temporary Tablespace”

G

GLOBAL_STATUS

Section 21.6, “Management of NDB Cluster”
Section 21.6.14, “NDB API Statistics Counters and Variables”
Section 21.7, “NDB Cluster Replication”
Section 5.1.7, “Server System Variables”
Section 13.7.5.35, “SHOW STATUS Statement”
Section 24.3.10, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

GLOBAL_VARIABLES

Section 5.1.7, “Server System Variables”
Section 13.7.5.39, “SHOW VARIABLES Statement”
Section 24.3.11, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

I

INFORMATION_SCHEMA

Section 21.6.16, “INFORMATION_SCHEMA Tables for NDB Cluster”
Section 14.16, “InnoDB INFORMATION_SCHEMA Tables”
MySQL Glossary
Section 5.2, “The MySQL Data Directory”
Section 26.2, “Using the sys Schema”

INFORMATION_SCHEMA.CHARACTER_SETS

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

INFORMATION_SCHEMA.COLUMNS

Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 25.1, “Performance Schema Quick Start”

INFORMATION_SCHEMA.INNODB_CMP

MySQL Glossary

INFORMATION_SCHEMA.INNODB_SYS_TABLES

Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”

INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES

Section 14.14, “InnoDB Data-at-Rest Encryption”
Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”

INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS

Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”

INFORMATION_SCHEMA.OPTIMIZER_TRACE

Section 8.15, “Tracing the Optimizer”
Section 8.15.1, “Typical Usage”

INFORMATION_SCHEMA.PARTITIONS

Section 22.2.7, “How MySQL Partitioning Handles NULL”

INFORMATION_SCHEMA.PLUGINS

Section 5.5.1, “Installing and Uninstalling Plugins”

INFORMATION_SCHEMA.PROCESSLIST

Section 6.2.2, “Privileges Provided by MySQL”

INFORMATION_SCHEMA.ROUTINES

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

INFORMATION_SCHEMA.STATISTICS

Section 21.5.15, “ndb_index_stat — NDB Index Statistics Utility”

INFORMATION_SCHEMA.TRIGGERS

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

INNODB_BUFFER_PAGE

Section 14.5.2, “Change Buffer”
Section 14.16.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 26.1, “Prerequisites for Using the sys Schema”
Section 24.4.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
Section 24.4.3, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
Section 26.4.3.7, “The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views”
Section 26.4.3.8, “The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views”

INNODB_BUFFER_PAGE_LRU

Section 14.16.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 14.8.3.6, “Saving and Restoring the Buffer Pool State”
Section 24.4.3, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”

INNODB_BUFFER_POOL_STATS

Section 14.5.1, “Buffer Pool”
Section 14.16.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
Section 24.4.4, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”

INNODB_CMP

Section 14.16.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 14.16.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 14.16.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 14.9.1.4, “Monitoring InnoDB Table Compression at Runtime”
Section 24.4.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
Section 14.9.1.3, “Tuning Compression for InnoDB Tables”
Section 14.16.1.3, “Using the Compression Information Schema Tables”

INNODB_CMP_PER_INDEX

Section 14.15, “InnoDB Startup Options and System Variables”
Section 14.9.1.4, “Monitoring InnoDB Table Compression at Runtime”
Section 24.4.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 14.9.1.3, “Tuning Compression for InnoDB Tables”
Section 14.16.1.3, “Using the Compression Information Schema Tables”

INNODB_CMP_PER_INDEX_RESET

Section 24.4.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”

INNODB_CMP_RESET

Section 14.16.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 14.16.1.1, “INNODB_CMP and INNODB_CMP_RESET”
Section 14.16.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 24.4.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”

INNODB_CMPMEM

Section 14.16.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 14.16.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 24.4.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
Section 14.16.1.3, “Using the Compression Information Schema Tables”

INNODB_CMPMEM_RESET

Section 14.16.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
Section 14.16.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
Section 24.4.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”

INNODB_FT_BEING_DELETED

Section 14.6.2.4, “InnoDB Full-Text Indexes”
Section 14.16.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 24.4.8, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”

INNODB_FT_CONFIG

Section 14.6.2.4, “InnoDB Full-Text Indexes”
Section 14.16.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 24.4.9, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”

INNODB_FT_DEFAULT_STOPWORD

Section 12.9.4, “Full-Text Stopwords”
Section 14.6.2.4, “InnoDB Full-Text Indexes”
Section 14.16.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 24.4.10, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”

INNODB_FT_DELETED

Section 14.6.2.4, “InnoDB Full-Text Indexes”
Section 14.16.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 24.4.8, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 24.4.11, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”

INNODB_FT_INDEX_CACHE

Section 14.6.2.4, “InnoDB Full-Text Indexes”
Section 14.16.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 12.9.9, “MeCab Full-Text Parser Plugin”
Section 12.9.8, “ngram Full-Text Parser”
Section 24.4.12, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”

INNODB_FT_INDEX_TABLE

Section 12.9.4, “Full-Text Stopwords”
Section 14.6.2.4, “InnoDB Full-Text Indexes”
Section 14.16.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 24.4.8, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 24.4.11, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 24.4.13, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”

INNODB_LOCK_WAITS

Section 14.16.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 14.16.2.2, “InnoDB Lock and Lock-Wait Information”
Section 14.16.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 24.4.15, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 14.16.2.1, “Using InnoDB Transaction and Locking Information”
Section 1.3, “What Is New in MySQL 5.7”

INNODB_LOCKS

Section 14.16.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 14.16.2.2, “InnoDB Lock and Lock-Wait Information”
Section 14.16.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 24.4.15, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
Section 24.4.14, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 24.4.28, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 14.16.2.1, “Using InnoDB Transaction and Locking Information”
Section 1.3, “What Is New in MySQL 5.7”

INNODB_METRICS

Section 14.5.2, “Change Buffer”
Section 14.8.12, “Configuring the Merge Threshold for Index Pages”
Section 14.16.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
Section 14.15, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 24.4.16, “The INFORMATION_SCHEMA INNODB_METRICS Table”
Section 26.4.3.21, “The metrics View”

INNODB_SYS_COLUMNS

Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 24.4.17, “The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table”
Section 24.4.26, “The INFORMATION_SCHEMA INNODB_SYS_VIRTUAL Table”

INNODB_SYS_DATAFILES

Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 14.16.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 24.3.9, “The INFORMATION_SCHEMA FILES Table”
Section 24.4.18, “The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table”
Section 24.3.26, “The INFORMATION_SCHEMA TABLESPACES Table”

INNODB_SYS_FIELDS

Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 24.4.19, “The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table”

INNODB_SYS_FOREIGN

Section 1.6.3.2, “FOREIGN KEY Constraints”
Section 13.1.18.5, “FOREIGN KEY Constraints”
Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 24.4.20, “The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table”

INNODB_SYS_FOREIGN_COLS

Section 1.6.3.2, “FOREIGN KEY Constraints”
Section 13.1.18.5, “FOREIGN KEY Constraints”
Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 24.4.21, “The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table”

INNODB_SYS_INDEXES

Section 14.8.12, “Configuring the Merge Threshold for Index Pages”
Section 14.6.2.4, “InnoDB Full-Text Indexes”
Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 24.4.22, “The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table”

INNODB_SYS_TABLES

Section 22.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 14.6.2.4, “InnoDB Full-Text Indexes”
Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 14.11, “InnoDB Row Formats”
Section 24.4.23, “The INFORMATION_SCHEMA INNODB_SYS_TABLES Table”
Section 14.22.3, “Troubleshooting InnoDB Data Dictionary Operations”

INNODB_SYS_TABLESPACES

Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 14.9.2, “InnoDB Page Compression”
Section 14.16.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
Section 24.3.9, “The INFORMATION_SCHEMA FILES Table”
Section 24.4.24, “The INFORMATION_SCHEMA INNODB_SYS_TABLESPACES Table”
Section 24.3.26, “The INFORMATION_SCHEMA TABLESPACES Table”

INNODB_SYS_TABLESTATS

Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 24.4.25, “The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View”

INNODB_SYS_VIRTUAL

Section 24.4.26, “The INFORMATION_SCHEMA INNODB_SYS_VIRTUAL Table”

INNODB_TEMP_TABLE_INFO

Section 14.16.7, “InnoDB INFORMATION_SCHEMA Temporary Table Info Table”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 24.4.27, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”
Section 14.6.3.5, “The Temporary Tablespace”

INNODB_TRX

Section 14.16.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
Section 14.16.2.2, “InnoDB Lock and Lock-Wait Information”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 14.16.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 24.4.14, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
Section 24.4.28, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 14.16.2.1, “Using InnoDB Transaction and Locking Information”

K

KEY_COLUMN_USAGE

Section 1.6.3.2, “FOREIGN KEY Constraints”
Section 13.1.18.5, “FOREIGN KEY Constraints”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 24.3.12, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”

M

MYSQL_FIREWALL_USERS

Section 6.4.6.4, “MySQL Enterprise Firewall Reference”
Section 24.7.2, “The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table”

MYSQL_FIREWALL_WHITELIST

Section 6.4.6.4, “MySQL Enterprise Firewall Reference”
Section 24.7.3, “The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table”

N

NDB_TRANSID_MYSQL_CONNECTION_MAP

Section 21.6.15.34, “The ndbinfo server_operations Table”
Section 21.6.15.35, “The ndbinfo server_transactions Table”

ndb_transid_mysql_connection_map

Section 21.6.16, “INFORMATION_SCHEMA Tables for NDB Cluster”
Section 21.4.3.9.1, “MySQL Server Options for NDB Cluster”
Section 21.6.15, “ndbinfo: The NDB Cluster Information Database”
Section 24.3.13, “The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table”

O

OPTIMIZER_TRACE

Section 24.3.14, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”
Section 8.15.4, “Tuning Trace Purging”

P

PARAMETERS

Section A.4, “MySQL 5.7 FAQ: Stored Procedures and Functions”
Section 13.7.5.28, “SHOW PROCEDURE STATUS Statement”
Section 24.3.15, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 24.3.21, “The INFORMATION_SCHEMA ROUTINES Table”

PARTITIONS

Section 22.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 22.2.7, “How MySQL Partitioning Handles NULL”
Section 22.2.5, “KEY Partitioning”
Section 22.3.5, “Obtaining Information About Partitions”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Chapter 22, Partitioning
Section 22.2.3.1, “RANGE COLUMNS partitioning”
Section 5.1.6, “Server Command Options”
Section 13.7.5.36, “SHOW TABLE STATUS Statement”
Section 24.3.16, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 24.3.25, “The INFORMATION_SCHEMA TABLES Table”

PLUGINS

Section 6.4.2.1, “Connection-Control Plugin Installation”
Section 14.14, “InnoDB Data-at-Rest Encryption”
Section 13.7.3.3, “INSTALL PLUGIN Statement”
Section 5.5.1, “Installing and Uninstalling Plugins”
Section 6.4.5.2, “Installing or Uninstalling MySQL Enterprise Audit”
Section 6.4.4.10, “Keyring Metadata”
Section 6.4.4.1, “Keyring Plugin Installation”
Section 6.4.1.9, “LDAP Pluggable Authentication”
Section 6.4.1.10, “No-Login Pluggable Authentication”
Section 5.5.2, “Obtaining Server Plugin Information”
Section 6.4.1.7, “PAM Pluggable Authentication”
Chapter 22, Partitioning
Section 6.4.3.1, “Password Validation Plugin Installation”
Section 21.6.17, “Quick Reference: NDB Cluster SQL Statements”
Section 16.3.9.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.6, “Server Command Options”
Section 6.4.1.11, “Socket Peer-Credential Pluggable Authentication”
Section 6.4.1.12, “Test Pluggable Authentication”
Section 24.3.17, “The INFORMATION_SCHEMA PLUGINS Table”
Section 5.5.3.2, “Thread Pool Installation”
Section 6.4.1.8, “Windows Pluggable Authentication”

PROCESSLIST

Section 8.14.1, “Accessing the Process List”
Section 12.15, “Information Functions”
Section 13.7.6.4, “KILL Statement”
Section 8.8.4, “Obtaining Execution Plan Information for a Named Connection”
Section 25.6, “Performance Schema Instrument Naming Conventions”
Section 25.12.11, “Performance Schema Replication Tables”
Section 25.12.5, “Performance Schema Stage Event Tables”
Section 14.16.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
Section 13.7.5.29, “SHOW PROCESSLIST Statement”
Section 24.4.28, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 24.3.18, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 26.4.3.22, “The processlist and x$processlist Views”
Section 25.12.16.3, “The processlist Table”
Section 25.12.16.4, “The threads Table”
Section 14.16.2.1, “Using InnoDB Transaction and Locking Information”

PROFILING

Section 13.7.5.30, “SHOW PROFILE Statement”
Section 24.3.19, “The INFORMATION_SCHEMA PROFILING Table”
Section 1.3, “What Is New in MySQL 5.7”

R

REFERENTIAL_CONSTRAINTS

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

ROUTINES

Section 24.1, “Introduction”
Section A.4, “MySQL 5.7 FAQ: Stored Procedures and Functions”
Section 13.7.5.28, “SHOW PROCEDURE STATUS Statement”
Section 23.6, “Stored Object Access Control”
Section 23.2.3, “Stored Routine Metadata”
Section 24.3.21, “The INFORMATION_SCHEMA ROUTINES Table”

S

SCHEMA_PRIVILEGES

Section 24.3.23, “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.14, “SHOW DATABASES Statement”
Section 24.3.22, “The INFORMATION_SCHEMA SCHEMATA Table”

SESSION_STATUS

Section 21.6, “Management of NDB Cluster”
Section 21.6.14, “NDB API Statistics Counters and Variables”
Section 21.7, “NDB Cluster Replication”
Section 5.1.7, “Server System Variables”
Section 13.7.5.35, “SHOW STATUS Statement”
Section 24.3.10, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

SESSION_VARIABLES

Section 5.1.7, “Server System Variables”
Section 13.7.5.39, “SHOW VARIABLES Statement”
Section 24.3.11, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

STATISTICS

Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 14.8.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 8.9.4, “Index Hints”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 13.7.5.22, “SHOW INDEX Statement”
Section 24.3.24, “The INFORMATION_SCHEMA STATISTICS Table”

T

TABLE_CONSTRAINTS

Section 14.13.1, “Online DDL Operations”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 24.3.20, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”
Section 24.3.27, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

TABLE_PRIVILEGES

Section 24.3.28, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”

TABLES

Section 21.6.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 13.1.8, “ALTER TABLE Statement”
Section 14.8.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 13.1.18, “CREATE TABLE Statement”
Section 14.14, “InnoDB Data-at-Rest Encryption”
Section 14.9.2, “InnoDB Page Compression”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 24.1, “Introduction”
Section 21.4.3.9.2, “NDB Cluster System Variables”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 5.1.6, “Server Command Options”
Section 13.1.18.9, “Setting NDB Comment Options”
Section 13.7.5.36, “SHOW TABLE STATUS Statement”
Section 13.7.5.37, “SHOW TABLES Statement”
Section 26.4.4.2, “The diagnostics() Procedure”
Section 24.3.25, “The INFORMATION_SCHEMA TABLES Table”
Section 26.4.2.1, “The sys_config Table”

TP_THREAD_GROUP_STATE

Section 24.5, “INFORMATION_SCHEMA Thread Pool Tables”
Section 24.5.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 5.5.3.1, “Thread Pool Elements”

TP_THREAD_GROUP_STATS

Section 24.5, “INFORMATION_SCHEMA Thread Pool Tables”
Section 24.5.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”
Section 24.5.4, “The INFORMATION_SCHEMA TP_THREAD_STATE Table”
Section 5.5.3.1, “Thread Pool Elements”

TP_THREAD_STATE

Section 24.5, “INFORMATION_SCHEMA Thread Pool Tables”
Section 24.5.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 24.5.4, “The INFORMATION_SCHEMA TP_THREAD_STATE Table”
Section 5.5.3.1, “Thread Pool Elements”
Section 5.5.3.2, “Thread Pool Installation”

TRIGGERS

Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 13.7.5.11, “SHOW CREATE TRIGGER Statement”
Section 13.7.5.38, “SHOW TRIGGERS Statement”
Section 24.3.29, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 23.3.2, “Trigger Metadata”

U

USER_PRIVILEGES

Section 24.3.30, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”

V

VIEWS

Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 13.7.5.13, “SHOW CREATE VIEW Statement”
Section 24.3.31, “The INFORMATION_SCHEMA VIEWS Table”
Section 23.5.3, “Updatable and Insertable Views”
Section 23.5.5, “View Metadata”

PREV HOME UP NEXT

PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 255.8Kb
Man Pages (Zip) - 360.7Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb