Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-table.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. The INNODB_CMP and INNODB_CMP_RESET tables have these columns: PAGE_SIZE The compressed page size in bytes. COMPRESS_OPS The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmpmem-table.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer pool. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables have these columns: PAGE_SIZE The block size in bytes. PAGES_USED The ...