PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an eventual consistency system. This means that as soon as the incoming traffic slows down or stops, all group members ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
Keys and indexes on NDB Cluster tables are subject to the following limitations: Column width. Attempting to create an index on an NDB table column whose width is greater than 3072 bytes is rejected with ER_TOO_LONG_KEY: Specified key was too long; ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
group_replication_consistency also determines the fencing mechanism used by newly elected primaries in single primary groups. Use this mode with a group that is intended primarily for read-only operations to ensure that any read/write transactions ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
These keywords are important to allow multiple sessions to read and write InnoDB tables concurrently, providing substantial scalability benefits in write-heavy workloads. When you convert MyISAM tables that are large, frequently accessed, and hold ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
Requires --restore-data ADDED: NDB 8.0.29 --allow-pk-changes Command-Line Format --allow-pk-changes[=0|1] Introduced 8.0.21-ndb-8.0.21 Type Integer Default Value 0 Minimum Value 0 Maximum Value 1 When this option is set to 1, ndb_restore allows the ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
In an SQL statement that inserts, deletes, or updates many rows, foreign key constraints (like unique constraints) are checked row-by-row. When performing foreign key checks, InnoDB sets shared row-level locks on child or parent records that it must ...For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html
This section explains how to change the mode which a group is running in, either single or multi-primary. The functions used to change a group's mode can be run on any member. Changing to Single-Primary Mode Use the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. Table-level options for controlling read from any replica and partition balance can be ...