MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
C | E | F | G | I | K | 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 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 13.7.6.3, “SHOW CHARACTER SET Syntax”
- Section 10.10, “Supported Character Sets and Collations”
- Section 10.3.4, “Table Character Set and Collation”
- Section 25.2, “The INFORMATION_SCHEMA CHARACTER_SETS Table”
CHECK_CONSTRAINTS
COLLATION_CHARACTER_SET_APPLICABILITY
COLLATIONS
- Section 28.7.5, “C API Data Structures”
- Section 10.14, “Character Set Configuration”
- Section 10.2, “Character Sets and Collations in MySQL”
- Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 13.7.6.4, “SHOW COLLATION Syntax”
- Section 10.8.5, “The binary Collation Compared to _bin Collations”
- Section 11.4.1, “The CHAR and VARCHAR Types”
- Section 25.4, “The INFORMATION_SCHEMA COLLATIONS Table”
- Section 10.10.1, “Unicode Character Sets”
COLUMN_PRIVILEGES
COLUMN_STATISTICS
COLUMNS
- Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 13.7.6.5, “SHOW COLUMNS Syntax”
- Section 25.6, “The INFORMATION_SCHEMA COLUMNS Table”
- Section 25.39.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
- Section 25.39.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
- Section 25.39.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”
- Section 25.39.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
- Section 25.39.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
- Section 25.39.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
- Section 25.39.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”
- Section 25.39.8, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”
- Section 25.39.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
- Section 25.39.10, “The INFORMATION_SCHEMA INNODB_FIELDS Table”
- Section 25.39.11, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”
- Section 25.39.12, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”
- Section 25.39.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
- Section 25.39.14, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
- Section 25.39.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”
- Section 25.39.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
- Section 25.39.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
- Section 25.39.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
- Section 25.39.19, “The INFORMATION_SCHEMA INNODB_INDEXES Table”
- Section 25.39.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”
- Section 25.39.23, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”
- Section 25.39.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”
- Section 25.39.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
- Section 25.39.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
- Section 25.39.27, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”
- Section 25.39.28, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”
- Section 25.39.29, “The INFORMATION_SCHEMA INNODB_TRX Table”
- Section 25.39.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”
- Section 25.27, “The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table”
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
ENGINES
EVENTS
FILES
- Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 22.5.11, “INFORMATION_SCHEMA Tables for NDB Cluster”
- Section 22.5.13.1, “NDB Cluster Disk Data Objects”
- Section 22.5.10, “ndbinfo: The NDB Cluster Information Database”
- Section 25.11, “The INFORMATION_SCHEMA FILES Table”
- Section 25.39.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
- Section 25.39.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
- Section 25.31, “The INFORMATION_SCHEMA TABLESPACES Table”
GLOBAL_STATUS
INFORMATION_SCHEMA
- Section 2.11.4, “Changes in MySQL 8.0”
- Section 14.1, “Data Dictionary Schema”
- Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 22.5.11, “INFORMATION_SCHEMA Tables for NDB Cluster”
- Section 15.14, “InnoDB INFORMATION_SCHEMA Tables”
- Chapter 14, MySQL Data Dictionary
- MySQL Glossary
- Section 6.2.9, “Reserved Accounts”
- Section B.3.1, “Server Error Message Reference”
- Section 5.2, “The MySQL Data Directory”
- Section 27.2, “Using the sys Schema”
- Section 1.4, “What Is New in MySQL 8.0”
INFORMATION_SCHEMA.CHARACTER_SETS
INFORMATION_SCHEMA.COLLATIONS
INFORMATION_SCHEMA.COLUMN_STATISTICS
INFORMATION_SCHEMA.COLUMNS
INFORMATION_SCHEMA.ENGINES
INFORMATION_SCHEMA.EVENTS
INFORMATION_SCHEMA.FILES
- Section 13.1.6, “ALTER LOGFILE GROUP Syntax”
- Section 13.1.10, “ALTER TABLESPACE Syntax”
- Section 2.11.4, “Changes in MySQL 8.0”
- Section 13.1.16, “CREATE LOGFILE GROUP Syntax”
- Section 13.1.21, “CREATE TABLESPACE Syntax”
- Section 15.6.3.8, “Moving Tablespace Files While the Server is Offline”
- Section 22.5.13.3, “NDB Cluster Disk Data Storage Requirements”
- Section 22.4.9, “ndb_desc — Describe NDB Tables”
- Section 15.14.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
- Section 15.6.3.5, “Temporary Tablespaces”
- Section 15.6.3.4, “Undo Tablespaces”
- Section 22.1.4, “What is New in NDB Cluster”
INFORMATION_SCHEMA.GLOBAL_STATUS
INFORMATION_SCHEMA.INNODB_BUFFER_PAGE
INFORMATION_SCHEMA.INNODB_CACHED_INDEXES
INFORMATION_SCHEMA.INNODB_CMP
INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX
INFORMATION_SCHEMA.INNODB_CMPMEM
INFORMATION_SCHEMA.INNODB_COLUMNS
INFORMATION_SCHEMA.INNODB_DATAFILES
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_INDEXES
INFORMATION_SCHEMA.INNODB_METRICS
INFORMATION_SCHEMA.INNODB_TABLES
INFORMATION_SCHEMA.INNODB_TABLESPACES
INFORMATION_SCHEMA.INNODB_TABLESPACES_BRIEF
INFORMATION_SCHEMA.INNODB_TABLESTATS
INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO
INFORMATION_SCHEMA.INNODB_TRX
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
INFORMATION_SCHEMA.OPTIMIZER_TRACE
INFORMATION_SCHEMA.PARTITIONS
INFORMATION_SCHEMA.PLUGINS
- Section 6.4.2.1, “Connection-Control Plugin Installation”
- Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”
- Section 5.6.1, “Installing and Uninstalling Plugins”
- Section 5.6.5.1, “Installing or Uninstalling ddl_rewriter”
- Section 6.4.5.2, “Installing or Uninstalling MySQL Enterprise Audit”
- Section 6.4.4.1, “Keyring Plugin Installation”
- Section 6.4.1.7, “LDAP Pluggable Authentication”
- Section A.2, “MySQL 8.0 FAQ: Storage Engines”
- Section 6.4.1.8, “No-Login Pluggable Authentication”
- Section 5.6.2, “Obtaining Server Plugin Information”
- Section 6.4.1.5, “PAM Pluggable Authentication”
- Section 29.2.2, “Plugin API Characteristics”
- Section 29.2.3, “Plugin API Components”
- Section 17.3.11.2, “Semisynchronous Replication Installation and Configuration”
- Section 29.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
- Section 6.4.1.9, “Socket Peer-Credential Pluggable Authentication”
- Section 6.4.1.10, “Test Pluggable Authentication”
- Section 5.6.3.2, “Thread Pool Installation”
- Section 1.4, “What Is New in MySQL 8.0”
- Section 6.4.1.6, “Windows Pluggable Authentication”
- Section 29.2.4.8, “Writing Audit Plugins”
- Section 29.2.4.5, “Writing Daemon Plugins”
- Section 29.2.4.4, “Writing Full-Text Parser Plugins”
- Section 29.2.4.6, “Writing INFORMATION_SCHEMA Plugins”
- Section 29.2.4.12, “Writing Keyring Plugins”
- Section 29.2.4.10, “Writing Password-Validation Plugins”
- Section 29.2.4.9.1, “Writing the Server-Side Authentication Plugin”
INFORMATION_SCHEMA.PROCESSLIST
INFORMATION_SCHEMA.RESOURCE_GROUPS
INFORMATION_SCHEMA.ROUTINES
INFORMATION_SCHEMA.SCHEMATA
INFORMATION_SCHEMA.SESSION_STATUS
INFORMATION_SCHEMA.STATISTICS
- Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
- Section 8.9.4, “Index Hints”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 8.3.12, “Invisible Indexes”
- Section 22.4.14, “ndb_index_stat — NDB Index Statistics Utility”
- Section 5.3, “The mysql System Schema”
INFORMATION_SCHEMA.TABLE_CONSTRAINTS
INFORMATION_SCHEMA.TABLES
- Section 22.5.15.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
- Section 13.1.9, “ALTER TABLE Syntax”
- Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
- Section 15.6.3.9, “InnoDB Data-at-Rest Encryption”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 14.2, “Removal of File-based Metadata Storage”
- Section 27.4.4.2, “The diagnostics() Procedure”
- Section 27.4.2.1, “The sys_config Table”
- Section 5.6.3.2, “Thread Pool Installation”
INFORMATION_SCHEMA.TRIGGERS
INFORMATION_SCHEMA.VIEWS
INNODB_BUFFER_PAGE
- Section 15.5.2, “Change Buffer”
- Section 15.14.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”
- Section 27.1, “Prerequisites for Using the sys Schema”
- Section 25.39.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”
- Section 25.39.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”
- Section 27.4.3.7, “The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views”
- Section 27.4.3.8, “The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views”
INNODB_BUFFER_PAGE_LRU
INNODB_BUFFER_POOL_STATS
INNODB_CACHED_INDEXES
INNODB_CMP
- Section 15.14.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”
- Section 15.14.1.1, “INNODB_CMP and INNODB_CMP_RESET”
- Section 15.14.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”
- Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime”
- Section 25.39.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
- Section 15.14.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_COLUMNS
INNODB_DATAFILES
- Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
- Section 15.14.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
- Section 25.11, “The INFORMATION_SCHEMA FILES Table”
- Section 25.39.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”
- Section 25.39.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
- Section 25.31, “The INFORMATION_SCHEMA TABLESPACES Table”
INNODB_FIELDS
INNODB_FOREIGN
INNODB_FOREIGN_COLS
INNODB_FT_BEING_DELETED
INNODB_FT_CONFIG
INNODB_FT_DEFAULT_STOPWORD
INNODB_FT_DELETED
- Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
- Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 25.39.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
- Section 25.39.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
INNODB_FT_INDEX_CACHE
INNODB_FT_INDEX_TABLE
- Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
- Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
- Section 15.13, “InnoDB Startup Options and System Variables”
- Section 25.39.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
- Section 25.39.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
- Section 25.39.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
INNODB_INDEXES
- Section 15.8.11, “Configuring the Merge Threshold for Index Pages”
- Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
- Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
- Section 25.39.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
- Section 25.39.19, “The INFORMATION_SCHEMA INNODB_INDEXES Table”
INNODB_LOCK_WAITS
- Section 15.14.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
- Section 15.14.2.2, “InnoDB Lock and Lock-Wait Information”
- Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
- Section 25.39.21, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”
- Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”
- Section 1.4, “What Is New in MySQL 8.0”
INNODB_LOCKS
- Section 15.14.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
- Section 15.14.2.2, “InnoDB Lock and Lock-Wait Information”
- Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
- Section 25.39.20, “The INFORMATION_SCHEMA INNODB_LOCKS Table”
- Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”
- Section 1.4, “What Is New in MySQL 8.0”
INNODB_METRICS
INNODB_SESSION_TEMP_TABLESPACES
INNODB_SYS_FOREIGN
INNODB_SYS_FOREIGN_COLS
INNODB_TABLES
- Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
- Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
- Section 25.39.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”
- Section 25.39.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”
- Section 1.4, “What Is New in MySQL 8.0”
INNODB_TABLESPACES
- Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
- Section 15.14.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”
- Section 13.7.6.36, “SHOW TABLE STATUS Syntax”
- Section 25.11, “The INFORMATION_SCHEMA FILES Table”
- Section 25.39.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”
- Section 25.39.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”
- Section 25.30, “The INFORMATION_SCHEMA TABLES Table”
- Section 25.31, “The INFORMATION_SCHEMA TABLESPACES Table”
- Section 1.4, “What Is New in MySQL 8.0”
INNODB_TABLESPACES_BRIEF
INNODB_TABLESTATS
INNODB_TEMP_TABLE_INFO
INNODB_TRX
- Section 15.14.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”
- Section 15.14.2.2, “InnoDB Lock and Lock-Wait Information”
- Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
- Section 26.12.12.1, “The data_locks Table”
- Section 25.39.29, “The INFORMATION_SCHEMA INNODB_TRX Table”
- Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”
KEY_COLUMN_USAGE
NDB_TRANSID_MYSQL_CONNECTION_MAP
ndb_transid_mysql_connection_map
OPTIMIZER_TRACE
PARAMETERS
PARTITIONS
- Section 23.3.3, “Exchanging Partitions and Subpartitions with Tables”
- Section 23.2.7, “How MySQL Partitioning Handles NULL”
- Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 23.3.5, “Obtaining Information About Partitions”
- Chapter 23, Partitioning
- Section 13.7.6.36, “SHOW TABLE STATUS Syntax”
- Section 25.17, “The INFORMATION_SCHEMA PARTITIONS Table”
- Section 25.30, “The INFORMATION_SCHEMA TABLES Table”
PLUGINS
PROCESSLIST
- Section 8.14, “Examining Thread Information”
- Section 13.7.7.4, “KILL Syntax”
- Section 8.8.4, “Obtaining Execution Plan Information for a Named Connection”
- Section 15.14.2.3, “Persistence and Consistency of InnoDB Transaction and Locking Information”
- Section 13.7.6.29, “SHOW PROCESSLIST Syntax”
- Section 25.39.29, “The INFORMATION_SCHEMA INNODB_TRX Table”
- Section 25.19, “The INFORMATION_SCHEMA PROCESSLIST Table”
- Section 27.4.3.22, “The processlist and x$processlist Views”
- Section 26.12.17.5, “The threads Table”
- Section 15.14.2.1, “Using InnoDB Transaction and Locking Information”
PROFILING
REFERENTIAL_CONSTRAINTS
RESOURCE_GROUPS
ROUTINES
SCHEMA_PRIVILEGES
SCHEMATA
SESSION_STATUS
ST_GEOMETRY_COLUMNS
ST_SPATIAL_REFERENCE_SYSTEMS
ST_UNITS_OF_MEASURE
STATISTICS
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TABLES
- Section 13.1.20, “CREATE TABLE Syntax”
- Section 14.7, “Data Dictionary Usage Differences”
- Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
- Section 25.1, “Introduction”
- Section 13.1.20.11, “Setting NDB_TABLE Options”
- Section 13.7.6.36, “SHOW TABLE STATUS Syntax”
- Section 13.7.6.37, “SHOW TABLES Syntax”
- Section 25.30, “The INFORMATION_SCHEMA TABLES Table”