PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-instances.html
For more information, see Section 6.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”. log_bin=binlog log_slave_updates=ON binlog_format=ROW master_info_repository=TABLE relay_log_info_repository=TABLE ... This section explains the ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
The length of a CHAR column is fixed to the length that you declare when you create the table. See Section 10.4.7, “Limits on Table Column Count and Row Size”. The following table illustrates the differences between CHAR and VARCHAR by showing ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-components-installation.html
URN: file://component_masking_functions To set up MySQL Enterprise Data Masking and De-Identification, do the following: Create the masking_dictionaries table. CREATE TABLE IF NOT EXISTS mysql.masking_dictionaries( Dictionary VARCHAR(256) NOT NULL, ...MySQL Enterprise Data Masking and De-Identification database table and components are: masking_dictionaries table Purpose: A table in the mysql system schema that provides persistent storage of dictionaries and ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
Detecting Partitions The replication_group_members performance schema table presents the status of each server in the current view from the perspective of this server. The majority of the time the system does not run into partitioning, and therefore ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. InnoDB tables arrange your data on disk to optimize queries based on primary keys. Each InnoDB table ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
From MySQL 8.0, this repository is created by default as an InnoDB table named mysql.slave_relay_log_info. DML transactions and also atomic DDL update the replication positions in the replica's applier metadata repository in the ... In order for ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). In particular, installing only the CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS ... This section describes how to install the connection control plugins, CONNECTION_CONTROL and ...
https://dev.mysql.com/doc/refman/8.0/en/crashing.html
The preceding means that normally you should not get corrupted tables unless one of the following happens: The MySQL server or the server host was killed in the middle of an update. Some external program is manipulating data files or index files at ... Each MySQL version is tested on many platforms before it is ...
https://dev.mysql.com/doc/refman/8.0/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...