Search Results
https://dev.mysql.com/doc/refman/9.7/en/generated-column-index-optimizations.html
The column is also indexed and the optimizer can take that index into account during execution plan construction. For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 ...
https://dev.mysql.com/doc/refman/9.7/en/gis-polygon-property-functions.html
Such components are extracted and made into a single MultiPolygon, MultiLineString, or MultiPoint for centroid computation. Functions in this section return properties of Polygon or MultiPolygon values. Unless otherwise specified, functions in this ...
https://dev.mysql.com/doc/refman/9.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/9.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/9.7/en/group-replication-deploying-locally.html
This - procedure assumes that MySQL Server was downloaded and unpacked - into the directory named mysql-9.7. The most common way to deploy Group Replication is using multiple server instances, to provide high availability. It is also possible to ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-flow-control.html
MySQL Group Replication ensures that a transaction commits only after a majority of the members in a group have received it and agreed on the relative order amongst all transactions sent concurrently. This approach works well if the total number of ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-monitoring.html
User of MySQL Enterprise Edition can also use the advanced monitoring capabilities built into the MySQL components listed here: Replication Applier Metrics: Adds tables to the MySQL Performance Schema (replication_applier_metrics and ... You can use ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-observability.html
There is a lot of automation built into the Group Replication plugin. Nonetheless, you might sometimes need to understand what is happening behind the scenes. This is where the instrumentation of Group Replication and Performance Schema becomes ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-online-upgrade-combining-versions.html
Members take into account the entire major.minor.release version of the software when checking compatibility. Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled with. For example, if a ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-performance-message-fragmentation.html
By default, large messages are automatically split into fragments that are sent separately and reassembled by the recipients. When an abnormally large message is sent between Group Replication group members, it can result in some group members ...