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-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 ...
https://dev.mysql.com/doc/refman/5.7/en/stop-group-replication.html
As soon as you issue STOP GROUP_REPLICATION the member is set to super_read_only=ON, which ensures that no writes can be made to the member while Group Replication stops. Warning Use this statement with extreme caution because it removes the server ...Any other replication channels running on the member are also ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-primary-secondary-replication.html
Traditional MySQL Replication provides a simple Primary-Secondary approach to replication. There is a primary (source) and there are one or more secondaries (replicas). The primary executes transactions, commits them and then they are later (thus ...
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
HAVING is merged with WHERE if you do not use GROUP BY or aggregate functions (COUNT(), MIN(), and so on). If all columns in ORDER BY and GROUP BY clauses come from the same table, that table is preferred first when joining. If there is an ORDER BY ... This section discusses optimizations that can be made for processing WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
For information about using JSON data in MySQL, see Section 11.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET assignment_list [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] value: {expr | DEFAULT} assignment: col_name = ...
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/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/performance-schema-replication-group-members-table.html
This table shows network and status information for replication group members. The network addresses shown are the addresses used to connect clients to the group, and should not be confused with the member's internal group communication address ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-group-member-stats-table.html
This table shows statistical information for MySQL Group Replication members. The replication_group_member_stats table has these columns: CHANNEL_NAME Name of the Group Replication channel. This has a different value for each member in the group.