PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
If a FOREIGN KEY constraint is defined on a table, any insert, update, or delete that requires the constraint condition to be checked sets shared record-level locks on the records that it looks at to check the constraint. InnoDB also sets these ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
LATEST FOREIGN KEY ERROR This section provides information about the most recent foreign key constraint error. The contents include the statement that failed as well as information about the constraint that failed and the referenced and referencing ... The Lock Monitor is the same as the Standard Monitor except that it includes additional lock ...
https://dev.mysql.com/doc/refman/5.7/en/option-file-options.html
See the introduction to this section regarding constraints on the position in which this option may be specified. See the introduction to this section regarding constraints on the position in which this option may be specified. See the introduction ... Most MySQL programs that support option files handle the following ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
Constraints on Audit Log Filtering Functions Audit log filtering functions are subject to these constraints: To use any filtering function, the audit_log plugin must be enabled or an error occurs. Note As of MySQL 5.7.13, for audit log filtering to ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
A foreign key constraint on a stored generated column cannot use CASCADE, SET NULL, or SET DEFAULT as ON UPDATE referential actions, nor can it use SET NULL or SET DEFAULT as ON DELETE referential actions. A foreign key constraint on the base column ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
Does NDB Cluster support foreign keys? NDB Cluster provides support for foreign key constraints which is comparable to that found in the InnoDB storage engine; see Section 1.6.3.2, “FOREIGN KEY Constraints”, for more detailed information, as ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-limitations.html
Multi-primary mode groups (members all configured with group_replication_single_primary_mode=OFF) do not support tables with multi-level foreign key dependencies, specifically tables that have defined CASCADING foreign key constraints. This is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-limitations.html
The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. This is similar to the idea of a foreign key constraint check in InnoDB in which constraints must hold during a transaction. The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-syntax.html
Support for foreign key constraints in NDB 7.5 is comparable to that provided by InnoDB, subject to the following restrictions: Every column referenced as a foreign key requires an explicit unique key, if it is not the table's primary key. (Bug ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-option-tables.html
ndb-deferred-constraints: Specifies that constraint checks on unique indexes (where these are supported) should be deferred until commit time. ndb_deferred_constraints: Specifies that constraint checks should be deferred (where these are supported).