PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause or a LEFT JOIN.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. The commands are the same as used when setting up server s1 as the user ...17.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
Server instances that you want to use for Group Replication must satisfy the following requirements. If there are conflicts, in order to maintain consistency across the group, some transactions are rolled back. Moreover, InnoDB provides some ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication.html
This chapter explains MySQL Group Replication and how to install, configure and monitor groups. MySQL Group Replication is a MySQL Server plugin that enables you to create elastic, highly-available, fault-tolerant replication topologies. Groups can ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. ROLLUP has a more complex effect when there are multiple GROUP BY columns. In this case, each time there is a change in value in any but the last grouping column, the query produces an extra super-aggregate summary ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-use-cases.html
Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Depending on the number of servers which fail the group might have degraded performance or scalability, but it is ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
The first condition is fulfilled when the query is implicitly grouped (contains an aggregate function but no GROUP BY clause). Consider the following implicitly grouped query: SELECT MIN(c1), MIN(c2) FROM t1; Suppose that MIN(c1) can be retrieved by ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-plugin-architecture.html
MySQL Group Replication is a MySQL plugin and it builds on the existing MySQL replication infrastructure, taking advantage of features such as the binary log, row-based logging, and global transaction identifiers. The following figure presents a ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-members.html
The performance_schema.replication_group_members table is used for monitoring the status of the different server instances that are members of the group. The information in the table is updated whenever there is a view change, for example when the ...At that point, servers exchange some of their metadata to synchronize themselves and continue to cooperate ...
https://dev.mysql.com/doc/refman/5.7/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...