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/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 thus enables you to answer questions at multiple levels of ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-instances.html
In this example, three instances are used for the group, which is the minimum number of instances to create a group. The first step is to deploy at least three instances of MySQL Server, this procedure demonstrates using multiple hosts for the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-getting-started.html
This section provides a detailed tutorial with the steps required to create a replication group with at least three members. MySQL Group Replication is provided as a plugin for the MySQL server; each server in a group requires configuration and ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-ip-address-permissions.html
These addresses and the localhost IP address for IPv4 are used to create an automatic Group Replication allowlist. The Group Replication plugin has a configuration option to determine from which hosts an incoming Group Communication System ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-recovering-from-a-point-in-time.html
The first part is generated when the group is created, and remains unchanged while there is at least one member in the group. To synchronize the server joining the group with the donor up to a specific point in time, the server joining the group ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-restarting-group.html
In that situation, to re-create the group, it must be started by bootstrapping as if it was being started for the first time. Group Replication is designed to ensure that the database service is continuously available, even if some of the servers ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
These addresses and the localhost IP address for IPv4 are used to create the Group Replication allowlist. This section lists the system variables that are specific to the Group Replication plugin. The name of each Group Replication system variable ...
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. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
ICP is not supported with secondary indexes created on virtual generated columns. Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the ...