MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 91 to 99 of 99 total results

« Previous
8
9
10
Next »

21.7.10 NDB Cluster Replication: Bidirectional and Circular Replication

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-multi-source.html

It is possible to use NDB Cluster for bidirectional replication between two clusters, as well as for circular replication between any number of clusters. Each cluster has two SQL nodes, with SQL nodes A and B belonging to Cluster 1, SQL nodes C and ...

21.7.9.2 Point-In-Time Recovery Using NDB Cluster Replication

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-pitr.html

Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was made. Performing point-in-time recovery of NDB Cluster ...

21.7.4 NDB Cluster Replication Schema and Tables

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html

conflict_fn column The conflict resolution function to be applied; one of NDB$OLD(), NDB$MAX(), NDB$MAX_DELETE_WIN(), NDB$EPOCH(), NDB$EPOCH_TRANS(), NDB$EPOCH2(), NDB$EPOCH2_TRANS(); NULL indicates that conflict resolution is not used for this ...

8.3.9 Use of Index Extensions

https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html

The optimizer can use extended secondary indexes for ref, range, and index_merge index access, for Loose Index Scan access, for join and sorting optimization, and for MIN()/MAX() optimization. To check whether disabling use of index extensions ...

17.7.1 Group Replication System Variables

https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html

Changes to the following system variables take effect without stopping and restarting Group Replication: group_replication_exit_state_action group_replication_flow_control_applier_threshold group_replication_flow_control_certifier_threshold ... This ...

9.2.5 Function Name Parsing and Resolution

https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html

ADDDATE BIT_AND BIT_OR BIT_XOR CAST COUNT CURDATE CURTIME DATE_ADD DATE_SUB EXTRACT GROUP_CONCAT MAX MID MIN NOW POSITION SESSION_USER STD STDDEV STDDEV_POP STDDEV_SAMP SUBDATE SUBSTR SUBSTRING SUM SYSDATE SYSTEM_USER TRIM VARIANCE VAR_POP VAR_SAMP ... MySQL supports built-in (native) functions, loadable functions, and stored ...

1.2.2 The Main Features of MySQL

https://dev.mysql.com/doc/refman/5.7/en/features.html

Support for group functions (COUNT(), AVG(), STD(), SUM(), MAX(), MIN(), and GROUP_CONCAT()). The maximum index width for InnoDB tables is either 767 bytes or 3072 bytes. This section describes some of the important characteristics of the MySQL ...

8.8.2 EXPLAIN Output Format

https://dev.mysql.com/doc/refman/5.7/en/explain-output.html

The maximum value is 100, which means no filtering of rows occurred. No matching min/max row (JSON property: message) No row satisfies the condition for a query such as SELECT MIN(...) FROM ... If you restrict queries with the max_join_size system ... The EXPLAIN statement provides information about how MySQL executes ...

11.1.1 Numeric Data Type Syntax

https://dev.mysql.com/doc/refman/5.7/en/numeric-type-syntax.html

In MIN(col_name) or MAX(col_name), where col_name refers to a BIGINT column. For integer data types, M indicates the minimum display width. Display width is unrelated to the range of values a type can store, as described in Section 11.1.6, ...