PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-recovering-from-a-point-in-time.html
To synchronize the server joining the group with the donor up to a specific point in time, the server joining the group and donor make use of the MySQL Global Transaction Identifiers (GTIDs) mechanism. However, GTIDS only provide a means to realize ...View and View Changes To explain the concept of view change markers, it is important to understand what a view and a view change ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
row *************************** EVENT_NAME: memory/sql/TABLE COUNT_ALLOC: 1381 COUNT_FREE: 924 SUM_NUMBER_OF_BYTES_ALLOC: 2059873 SUM_NUMBER_OF_BYTES_FREE: 1407432 LOW_COUNT_USED: 0 CURRENT_COUNT_USED: 457 HIGH_COUNT_USED: 461 ...Operation counts ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
Group Replication operates in the following different modes: single-primary mode multi-primary mode The default mode is single-primary. It is not possible to have members of the group deployed in different modes, for example one configured in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded InnoDB. InnoDB API functions are passed to the InnoDB memcached engine as callback ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-single-primary-mode.html
In this mode the group has a single-primary server that is set to read-write mode. All the other members in the group are set to read-only mode (with super-read-only=ON ). The primary is typically the first server to bootstrap the group, all other ...For example, changes to tables that have cascading foreign keys are allowed, whereas in multi-primary mode they are ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-data-manipulation-statements.html
As there are no primary servers (sources) for any particular data set, every server in the group is allowed to execute transactions at any time, even transactions that change state (RW transactions). But, at commit time, it coordinates with the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
Note The information in this section applies fully only before MySQL 5.7.5, and only for accounts that use the mysql_native_password or mysql_old_password authentication plugins. This includes removal of the mysql_old_password authentication plugin ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-observability.html
There is a lot of automation built into the Group Replication plugin. This is where the instrumentation of Group Replication and Performance Schema becomes important. The distributed nature of the replication protocol and the fact that server ...