PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
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 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/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
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 [=] ...
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/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-deploying-locally.html
The most common way to deploy Group Replication is using multiple server instances, to provide high availability. It is also possible to deploy Group Replication locally, for example for testing purposes. Important Group Replication is usually ...
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/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/group-replication-monitoring.html
You can use the MySQL Performance Schema to monitor Group Replication. These Performance Schema tables display information specific to Group Replication: replication_group_member_stats: See Section 17.4.3, “The replication_group_member_stats ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-member-stats.html
Each member in a replication group certifies and applies transactions received by the group. The performance_schema.replication_group_member_stats table provides group-level information related to the certification process, and also statistics for ...Statistics regarding the certifier and applier procedures are useful to understand how the applier queue is growing, how many conflicts have been found, how many transactions were checked, which transactions are committed everywhere, and so ...