Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache-reduce.html
Having a very low group_replication_message_cache_size setting is not recommended if the host is on an unstable network, because a smaller message cache makes it harder for group members to reconnect after a transient loss of connectivity. On a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-primary-mode.html
20.1.3.1.1 Primary Election Algorithm The automatic primary member election process involves each member looking at the new view of the group, ordering the potential new primary members, and choosing the member that qualifies as the most suitable.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-status-variables.html
Use this value together with the count_member_failure_suspicions column of the Performance Schema replication_group_communication_information table when diagnosing such issues. This section describes the status variables providing information about ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrading-member.html
Before proceeding, ensure that the member's status is OFFLINE by monitoring the replication_group_members table. This section explains the steps required for upgrading a member of a group. This procedure is part of the methods described at Section ...
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
Table 14.26 GTID Functions Name Description WAIT_FOR_EXECUTED_GTID_SET() Wait until the given GTIDs have executed on the replica. The functions described in this section are used with GTID-based replication. It is important to keep in mind that all ...
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/history.html
We started out with the intention of using the mSQL database system to connect to our tables using our own fast low-level (ISAM) routines. However, after some testing, we came to the conclusion that mSQL was not fast enough or flexible enough for ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-adaptive-hash.html
If a table fits almost entirely in main memory, a hash index speeds up queries by enabling direct lookup of any element, turning the index value into a sort of pointer. The adaptive hash index enables InnoDB to perform more like an in-memory ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
$> mysql test mysql> CREATE TABLE customer (a INT, b CHAR (20), INDEX (a)); Query OK, 0 rows affected (0.00 sec) mysql> -- Do a transaction with autocommit turned on. If autocommit mode is enabled, each SQL statement forms a single transaction on ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-check-availability.html
Issue a SHOW ENGINES statement to view the available MySQL storage engines.