PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/group-replication-system-variables.html
Group Replication's Group Communication System (GCS) is not available to validate the values until that point. group_replication_advertise_recovery_endpoints specifies how a joining member can establish a connection to an existing member for state ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-fulltext-index.html
This process, even for small documents, can result in numerous small insertions into the auxiliary index tables, making concurrent access to these tables a point of contention. InnoDB Full-Text Index Deletion Handling Deleting a record that has a ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-locks-set.html
At this point, sessions 2 and 3 deadlock: Neither can acquire an exclusive lock for the row because of the shared lock held by the other. At this point, sessions 2 and 3 deadlock: Neither can acquire an exclusive lock for the row because of the ...