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-performance-xcom-cache.html
Note that the limit set using group_replication_message_cache_size applies only to the data stored in the cache, and the cache structures require an additional 50 MB of memory. Note that before MySQL 8.0.21, this time period defaulted to 5 seconds ... The group communication engine for Group Replication (XCom, a Paxos variant) includes a cache for messages (and their metadata) exchanged between the group members as a part of the consensus ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
Note that this setting is not the default on all platforms. Note When replica_preserve_commit_order is ON, setting binlog_transaction_dependency_tracking to WRITESET has the same effect as setting it to WRITESET_SESSION. Infrastructure Server ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure.html
Note that while a member is undergoing any of the default behaviors described above, although it does not accept writes, reads can still be made if the member is still communicating with clients, with an increasing likelihood of stale reads over ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-tuning-recovery.html
Note that this limit specifies the total number of attempts that the joining member makes to connect to a donor. Note that distributed recovery does not sleep after every donor connection attempt. Several aspects of Group Replication's distributed ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
Note MySQL 8.0.18 supported setting a hash_join flag in optimizer_switch, as well as the optimizer hints HASH_JOIN and NO_HASH_JOIN. row *************************** Level: Note Code: 1276 Message: Field or reference 't3.t2.c1' of SELECT #2 was ...
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `id` int(11) DEFAULT NULL, KEY `id_index` (`id`) COMMENT 'MERGE_THRESHOLD=40' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci Note A MERGE_THRESHOLD value ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-datafiles-table.html
Note The INFORMATION_SCHEMA FILES table reports metadata for InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, the global temporary tablespace, and undo tablespaces. row ... The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-table.html
Note The INFORMATION_SCHEMA FILES table reports metadata for InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, the global temporary tablespace, and undo tablespaces. row ... The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...