Search Results
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
This occurs if the WHERE, ORDER BY, or GROUP BY clause refers to an expression that matches the definition of some indexed generated column. For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-multipoint.html
A MultiPoint is a geometry collection composed of Point elements. MultiPoint Examples On a world map, a MultiPoint could represent a chain of small islands. On a city map, a MultiPoint could represent the outlets for a ticket office. A MultiPoint ...
https://dev.mysql.com/doc/refman/8.4/en/gone-away.html
If mysqld receives a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. This section also covers the related Lost connection to server during query error. The most common ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
20.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for it. At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-connection-security.html
Because all of the members are stopped, a full reboot of the group (a bootstrap by a server with group_replication_bootstrap_group=ON) is required in order for the value change to take effect. MySQL 8.4 Group Replication can secure group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-flow-control.html
MySQL Group Replication ensures that a transaction commits only after a majority of the members in a group have received it and agreed on the relative order amongst all transactions sent concurrently. This approach works well if the total number of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-message-compression.html
However, it is advisable to set the same value on all group members in order to avoid unnecessary rollback of transactions, failure of message delivery, or failure of message recovery. For messages sent between online group members, Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
group_replication_force_members must be empty in order to issue a START GROUP_REPLICATION statement. The group needs to achieve consensus whenever a change that needs to be replicated happens. This is the case for regular transactions but is also ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-offline-upgrade.html
In a multi-primary group you can shutdown the members in any order. To perform an offline upgrade of a Group Replication group, you remove each member from the group, perform an upgrade of the member and then restart the group as usual. In a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-combining-versions.html
However, while you are in the process of upgrading an online group, in order to maximize availability, you might need to have members with different MySQL Server versions running at the same time. Group Replication is versioned according to the ...