Search Results
https://dev.mysql.com/doc/refman/8.4/en/gis-class-polygon.html
The rings in the boundary of a Polygon may intersect at a Point, but only as a tangent. A Polygon has an interior that is a connected point set. A Polygon is a planar Surface representing a multisided geometry. It is defined by a single exterior ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: ...The consistency level can have different effects on read-only and read/write transactions processed by the group as demonstrated in this ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
Group Replication Settings At this point the option file ensures that the server is configured and is instructed to instantiate the replication infrastructure under a given configuration. Group members offer their standard SQL client connection to ... This section explains the configuration settings required for MySQL Server instances that you want to use for Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
For example: s3> rm -rf /var/lib/mysql/* If the system variables innodb_data_home_dir, innodb_log_group_home_dir, and innodb_undo_directory point to any directories other than the data directory, they should also be made empty; otherwise, the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-failure-detection.html
In a replication group, each member has a point-to-point communication channel to each other member, creating a fully connected graph. Group Replication’s failure detection mechanism is a distributed service which is able to identify that a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
When you set a timeout, it also prevents new transactions starting on the primary from that point on. group_replication_set_as_primary() Appoints a specific member of the group as the new primary, overriding any election process. When you set a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-expel.html
If a suspect member becomes active only after the suspicion times out and is able to resume communications, it receives a view where it is expelled and at that point realises it was expelled. You can use group_replication_autorejoin_tries to make ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-partition.html
You can use the group_replication_autorejoin_tries system variable to force the member to try to rejoin the group automatically at this point. Consider the following points when deciding whether or not to set an unreachable majority timeout: In a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
The Information Schema INNODB_METRICS table provides most of the data points found in InnoDB Standard Monitor output plus other data points. The change buffer is a special data structure that caches changes to secondary index pages when those pages ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point in time, and no changes made by later or ...The exception to this rule is that the query sees the changes made by earlier statements within the same ...