MySQL 5.6 Release Notes
C | E | F | G | I | K | M | N | O | P | R | S | T | U | V
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.3.2, “The INFORMATION_SCHEMA CHARACTER_SETS Table”
COLLATION_CHARACTER_SET_APPLICABILITY
COLLATIONS
COLUMN_PRIVILEGES
COLUMNS
- Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
- Section 13.7.5.6, “SHOW COLUMNS Statement”
- Section 21.3.5, “The INFORMATION_SCHEMA COLUMNS Table”
- Section 21.4.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
- Section 21.4.3, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
- Section 21.4.4, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”
- Section 21.4.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
- Section 21.4.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
- Section 21.4.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
- Section 21.4.8, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
- Section 21.4.9, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
- Section 21.4.10, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”
- Section 21.4.11, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
- Section 21.4.12, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
- Section 21.4.13, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
- Section 21.4.15, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
- Section 21.4.14, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
- Section 21.4.16, “The INFORMATION_SCHEMA INNODB_METRICS Table”
- Section 21.4.17, “The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table”
- Section 21.4.18, “The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table”
- Section 21.4.19, “The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table”
- Section 21.4.20, “The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table”
- Section 21.4.21, “The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table”
- Section 21.4.22, “The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table”
- Section 21.4.23, “The INFORMATION_SCHEMA INNODB_SYS_TABLES Table”
- Section 21.4.24, “The INFORMATION_SCHEMA INNODB_SYS_TABLESPACES Table”
- Section 21.4.25, “The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View”
- Section 21.4.26, “The INFORMATION_SCHEMA INNODB_TRX Table”
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
ENGINES
EVENTS
FILES
- Section 21.5, “INFORMATION_SCHEMA NDB Cluster Tables”
- Section 18.6.10.1, “NDB Cluster Disk Data Objects”
- Section 18.6.14, “ndbinfo: The NDB Cluster Information Database”
- Section 6.2.2, “Privileges Provided by MySQL”
- Section 21.5.1, “The INFORMATION_SCHEMA FILES Table”
- Section 21.3.24, “The INFORMATION_SCHEMA TABLESPACES Table”
GLOBAL_STATUS
GLOBAL_VARIABLES
INFORMATION_SCHEMA
INFORMATION_SCHEMA.CHARACTER_SETS
INFORMATION_SCHEMA.COLLATIONS
INFORMATION_SCHEMA.COLUMNS
INFORMATION_SCHEMA.ENGINES
INFORMATION_SCHEMA.EVENTS
INFORMATION_SCHEMA.FILES
INFORMATION_SCHEMA.GLOBAL_STATUS
INFORMATION_SCHEMA.INNODB_BUFFER_PAGE
INFORMATION_SCHEMA.INNODB_CMP
INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX
INFORMATION_SCHEMA.INNODB_CMPMEM
INFORMATION_SCHEMA.INNODB_FT_CONFIG
INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD
INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE
INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE
INFORMATION_SCHEMA.INNODB_LOCK_WAITS
INFORMATION_SCHEMA.INNODB_LOCKS
INFORMATION_SCHEMA.INNODB_METRICS
INFORMATION_SCHEMA.INNODB_SYS_INDEXES
INFORMATION_SCHEMA.INNODB_SYS_TABLES
INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES
INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
INFORMATION_SCHEMA.INNODB_TRX
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
INFORMATION_SCHEMA.MYSQL_FIREWALL_USERS
INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST
INFORMATION_SCHEMA.OPTIMIZER_TRACE
INFORMATION_SCHEMA.PARTITIONS
INFORMATION_SCHEMA.PLUGINS
- Section 6.4.2.1, “Connection-Control Plugin Installation”
- Section 5.5.1, “Installing and Uninstalling Plugins”
- Section 6.4.4.1, “Installing MySQL Enterprise Audit”
- Section 5.5.2, “Obtaining Server Plugin Information”
- Section 6.4.1.6, “PAM Pluggable Authentication”
- Chapter 19, Partitioning
- Section 6.4.3.1, “Password Validation Plugin Installation”
- Section 17.3.9.2, “Semisynchronous Replication Installation and Configuration”
- Section 6.4.1.8, “Socket Peer-Credential Pluggable Authentication”
- Section 6.4.1.9, “Test Pluggable Authentication”
- Section 5.5.3.2, “Thread Pool Installation”
- Section 6.4.1.7, “Windows Pluggable Authentication”
INFORMATION_SCHEMA.PROCESSLIST
INFORMATION_SCHEMA.ROUTINES
INFORMATION_SCHEMA.SESSION_STATUS
INFORMATION_SCHEMA.STATISTICS
INFORMATION_SCHEMA.TABLE_CONSTRAINTS
INFORMATION_SCHEMA.TABLES
INFORMATION_SCHEMA.TRIGGERS
INFORMATION_SCHEMA.VIEWS
INNODB_BUFFER_PAGE
INNODB_BUFFER_PAGE_LRU
INNODB_BUFFER_POOL_STATS
INNODB_CMP
- Section 14.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
- Section 14.15.1.1, “INNODB_CMP and INNODB_CMP_RESET”
- Section 14.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
- Section 14.9.4, “Monitoring InnoDB Table Compression at Runtime”
- Section 21.4.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
- Section 14.15.1.3, “Using the Compression Information Schema Tables”
INNODB_CMP_PER_INDEX
INNODB_CMP_PER_INDEX_RESET
INNODB_CMP_RESET
INNODB_CMPMEM
INNODB_CMPMEM_RESET
INNODB_FT_BEING_DELETED
INNODB_FT_CONFIG
INNODB_FT_DEFAULT_STOPWORD
INNODB_FT_DELETED
- Section 14.6.2.3, “InnoDB Full-Text Indexes”
- Section 14.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
- Section 14.14, “InnoDB Startup Options and System Variables”
- Section 21.4.8, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
- Section 21.4.11, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
INNODB_FT_INDEX_CACHE
INNODB_FT_INDEX_TABLE
- Section 14.6.2.3, “InnoDB Full-Text Indexes”
- Section 14.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
- Section 14.14, “InnoDB Startup Options and System Variables”
- Section 21.4.8, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
- Section 21.4.11, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
- Section 21.4.13, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
INNODB_LOCK_WAITS
INNODB_LOCKS
- Section 14.15.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
- Section 14.15.2.2, “InnoDB Lock and Lock-Wait Information”
- Section 14.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
- Section 21.4.15, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
- Section 21.4.14, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
- Section 21.4.26, “The INFORMATION_SCHEMA INNODB_TRX Table”
INNODB_METRICS
INNODB_SYS_COLUMNS
INNODB_SYS_DATAFILES
INNODB_SYS_FIELDS
INNODB_SYS_FOREIGN
INNODB_SYS_FOREIGN_COLS
INNODB_SYS_INDEXES
INNODB_SYS_TABLES
INNODB_SYS_TABLESPACES
INNODB_SYS_TABLESTATS
INNODB_TRX
- Section 14.15.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
- Section 14.15.2.2, “InnoDB Lock and Lock-Wait Information”
- Section 14.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
- Section 21.4.14, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
- Section 21.4.26, “The INFORMATION_SCHEMA INNODB_TRX Table”
- Section 14.15.2.1, “Using InnoDB Transaction and Locking Information”
KEY_COLUMN_USAGE
MYSQL_FIREWALL_USERS
MYSQL_FIREWALL_WHITELIST
NDB_TRANSID_MYSQL_CONNECTION_MAP
ndb_transid_mysql_connection_map
OPTIMIZER_TRACE
PARAMETERS
PARTITIONS
- Section 19.3.3, “Exchanging Partitions and Subpartitions with Tables”
- Section 19.2.7, “How MySQL Partitioning Handles NULL”
- Section 19.3.5, “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.3.14, “The INFORMATION_SCHEMA PARTITIONS Table”
- Section 21.3.23, “The INFORMATION_SCHEMA TABLES Table”
PLUGINS
PROCESSLIST
- Section 8.14.1, “Accessing the Process List”
- Section 13.7.6.4, “KILL Statement”
- Section 14.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
- Section 13.7.5.30, “SHOW PROCESSLIST Statement”
- Section 21.4.26, “The INFORMATION_SCHEMA INNODB_TRX Table”
- Section 21.3.16, “The INFORMATION_SCHEMA PROCESSLIST Table”
- Section 22.12.10.3, “The threads Table”
- Section 14.15.2.1, “Using InnoDB Transaction and Locking Information”