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-single-consensus-leader.html
In this situation, the Performance Schema table replication_group_communication_information shows all of the members as both the preferred and actual leaders. By default, the group communication engine for Group Replication (XCom, a Paxos variant) ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-summary.html
For example, if t1 and t2 execute concurrently at different sites, both changing the same row, and t2 is ordered before t1, then t2 wins the conflict and t1 is rolled back. Group Replication is a technique that can be used to implement ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
Data flow operations apply to both modes of Group Replication: single-primary and multi-primary, however to make this explanation clearer it is restricted to single-primary mode. In terms of distributed consistency guarantees, either in normal or ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
This occurs when both of the following circumstances are true: Any session executes FLUSH TABLES or DDL statements on the handler's table. HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } ...
https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html
Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X.
https://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
(On a case-insensitive file system, both letters are treated as the same.) For some blocks, such as Cyrillic, the second byte determines lettercase. There is a correspondence between database and table identifiers and names in the file system. For ...
https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
WHERE index_part2=1 AND index_part3=2 /* Index is not used in both parts of the WHERE clause */ ... Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data ...
https://dev.mysql.com/doc/refman/8.0/en/index-extensions.html
InnoDB automatically extends each secondary index by appending the primary key columns to it. Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX ...
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
These index-level optimizer hints are supported with both single-table and multi-table DELETE statements. Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from ...