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/partitioning-limitations.html
Partitioned tables using the InnoDB storage engine do not support foreign keys. More specifically, this means that the following two statements are true: No definition of an InnoDB table employing user-defined partitioning may contain foreign key ...
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/innodb-online-ddl-limitations.html
An online DDL operation on a table in a foreign key relationship does not wait for a transaction executing on the other table in the foreign key relationship to commit or rollback. The transaction holds an exclusive metadata lock on the table it is ...When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate entry), even if the duplicate entry is only temporary and would be reverted by a later entry in the online ...
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 Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-importing-data.html
When importing data from an SQL file, it is often not necessary to enforce transactions or foreign keys, and temporarily disabling these features can speed up the import process greatly. Within a mysql client session, you can perform the import ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. InnoDB interprets foreign ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
Partitioned InnoDB tables cannot have foreign key references, nor can they have columns referenced by foreign keys. InnoDB tables which have or which are referenced by foreign keys cannot be partitioned. Partitioning by KEY (including LINEAR KEY) is ... The following limitations apply to the use of storage engines with user-defined partitioning of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
With foreign keys, inserts, updates, and deletes are checked to ensure they do not result in inconsistencies across related tables. Key Advantages of InnoDB Its DML operations follow the ACID model, with transactions featuring commit, rollback, and ... InnoDB is a general-purpose storage engine that balances high reliability and high ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-and-mysql-replication.html
A transaction that fails (for example, because of a foreign key violation, or because it is rolled back) is not written to the binary log, so it is not sent to replicas. Cascading actions for InnoDB tables on the source are executed on the replica ... It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the ...
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 ...