MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 91 to 100 of 107 total results

25.7.10 NDB Cluster Replication: Bidirectional and Circular Replication

https://dev.mysql.com/doc/refman/8.0/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 ...

25.7.9.2 Point-In-Time Recovery Using NDB Cluster Replication

https://dev.mysql.com/doc/refman/8.0/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 ...

25.7.4 NDB Cluster Replication Schema and Tables

https://dev.mysql.com/doc/refman/8.0/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 ...

13.1.1 Numeric Data Type Syntax

https://dev.mysql.com/doc/refman/8.0/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 13.1.6, ...

B.3.5 Optimizer-Related Issues

https://dev.mysql.com/doc/refman/8.0/en/optimizer-issues.html

For example, start mysqld with the --max-seeks-for-key=1000 option or use SET max_seeks_for_key=1000 to tell the optimizer to assume that no key scan causes more than 1,000 key seeks. MySQL uses a cost-based optimizer to determine the best way to ...

15.7.3.5 REPAIR TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/repair-table.html

With myisamchk --safe-recover, you can also use options that REPAIR TABLE does not support, such as --max-record-length.) REPAIR TABLE table catches and throws any errors that occur while copying table statistics from the old corrupted file to the ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...

8.7.1 Check if SELinux is Enabled

https://dev.mysql.com/doc/refman/8.0/en/selinux-checking.html

SELinux is enabled by default on some Linux distributions including Oracle Linux, RHEL, CentOS, and Fedora.

7.1.4 Server Option, System Variable, and Status Variable Reference

https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html

The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...

15.2.14 Set Operations with UNION, INTERSECT, and EXCEPT

https://dev.mysql.com/doc/refman/8.0/en/set-operations.html

Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...

15.2.15.10 Subquery Errors

https://dev.mysql.com/doc/refman/8.0/en/subquery-errors.html

Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows.

Displaying 91 to 100 of 107 total results