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
If you have any of these system variables in the option file in later versions, ensure that they are set as shown. It is recommended that operating systems running MySQL have a properly configured unique host name, either using DNS or local settings. If a joining member does not have a permitted address for the appropriate protocol, its connection attempt is ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
The setting for binlog_checksum does not have to be the same for all members of a group. Multi-primary mode groups (members all configured with group_replication_single_primary_mode=OFF) do not support tables with multi-level foreign key ... Limit ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
In fact, the remaining two are not able to tell if the other 3 servers have crashed or whether a network partition has isolated these 2 alone and therefore the group cannot be reconfigured automatically. For a group in single-primary mode, the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure.html
Group Replication's failure detection mechanism is designed to identify group members that are no longer communicating with the group, and expel them as and when it seems likely that they have failed. When a suspicion times out, the suspected ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
The two have very different execution profiles and you should not expect them to take the same amount of time. mysql> SELECT COERCIBILITY('abc' COLLATE utf8mb4_swedish_ci); -> 0 mysql> SELECT COERCIBILITY(USER()); -> 3 mysql> SELECT ...It may be ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html
For NDB: The number of extents which have not yet been used by the file. Predefined system tablespaces, which include the system tablespace and temporary table tablespaces, may have one or more data files. As of MySQL 8.0.21, you must have the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
Most importantly, it stores the FTS_SYNCED_DOC_ID, which identifies documents that have been parsed and flushed to disk. In case of crash recovery, FTS_SYNCED_DOC_ID values are used to identify documents that have not been flushed to disk so that ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-hashicorp-plugin.html
(If you already have those files, proceed to HashiCorp Vault Setup.) The instructions as shown apply to Linux platforms and may require adjustment for other platforms. (For production use, an instance would have multiple unseal keys with up to that ... Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
Dropping a FOREIGN KEY constraint does not work in replication because the constraint may have another name on the replica. SELECT if you have duplicate key values in the inserted data. If and only if the preceding queries have no ORDER BY clause ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
The files have names that begin with the table name and have an extension to indicate the file type. MyISAM tables have the following characteristics: All data values are stored with the low byte first. Binary compatibility might not be applicable ... MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful ...