Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache-reduce.html
The minimum setting for the XCom message cache size in MySQL 8.4 is 128 MB, which enables deployment on a host that has a restricted amount of available memory. Having a very low group_replication_message_cache_size setting is not recommended if ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-replication-group-members.html
The information is shared between all the server instances that are members of the replication group, so information on all the group members can be queried from any member. The performance_schema.replication_group_members table is used for ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-server-states.html
The state of a Group Replication group member shows its current role in the group. The Performance Schema table replication_group_members shows the state for each member in a group. If the group is fully functional and all members are communicating ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-consensus-leader.html
The WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE column of the Performance Schema table replication_group_communication_information shows whether the group supports the use of a single leader, even if group_replication_paxos_single_leader is currently set ... By default, the group communication engine for Group Replication (XCom, a Paxos variant) operates using every member of the replication group as a ...
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
The functions described in this section are used with GTID-based replication. It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. As such, the GTID sets must always be quoted when used ...
https://dev.mysql.com/doc/refman/8.4/en/handler.html
HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... ] HANDLER tbl_name READ index_name { FIRST | NEXT | PREV | LAST } [ WHERE where_condition ] [LIMIT ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/index-condition-pushdown-optimization.html
(For information about triggered conditions, see Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”.) Conditions cannot be pushed down to derived tables containing references to system variables. Index Condition Pushdown (ICP) ...
https://dev.mysql.com/doc/refman/8.4/en/index-preloading.html
Without preloading, the blocks are still placed into the key cache as needed by queries. If there are enough blocks in a key cache to hold blocks of an entire index, or at least the blocks corresponding to its nonleaf nodes, it makes sense to ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-per-index-table.html
The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you ...