PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-new-primary.html
This function replaces the usual primary election process; see Section 20.5.1.1, “Changing the Primary”, for more information. The following function enables you to set a member of a single-primary replication group to take over as the primary.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
From MySQL 8.0.20, you can do this, provided that the cloning operation does not remove and replace the data on the recipient. Limit on Group Size Limits on Transaction Size The following known limitations exist for Group Replication. Note that the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-member-actions.html
In that case, the joining member replaces its own member actions configuration with the group’s. From MySQL 8.0.26, Group Replication has the capability to set actions for the members of a group to take in specified situations. The member actions ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-user-credentials.html
Group Replication uses a distributed recovery process to synchronize group members when joining them to the group. Distributed recovery involves transferring transactions from a donor's binary log to a joining member using a replication channel ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-view-changes.html
During a remote cloning operation, the existing data on the joining member is removed, and replaced with a copy of the donor's data. When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
The same is true for any use of $ (dollar sign) in a schema or table name; it is replaced with @0024 on the filesystem. There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. Most of these statements also cause an implicit commit after ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
The MySQL column list is similar to what SQL Server 2000 returns for sp_statistics, except that QUALIFIER and OWNER are replaced with CATALOG and SCHEMA, respectively. The information_schema_stats_expiry system variable defines the period of time ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-enabling-monitors.html
If you are using the mysql interactive client, the output is more readable if you replace the usual semicolon statement terminator with \G: mysql> SHOW ENGINE INNODB STATUS\G SHOW ENGINE INNODB STATUS output also includes InnoDB Lock Monitor data if ... When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. Other transactions can update or delete the same rows you just queried. InnoDB supports two types of ...