Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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 ... In MySQL 8.4, partitioning support is not actually provided by the MySQL Server, but rather by a table storage engine's own or native partitioning ...
https://dev.mysql.com/doc/refman/8.4/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/workbench/en/wb-validation-plugins.html
MySQL Workbench provides validation modules so that you can test your models before implementing them. The validation (MySQL) plugins are accessed from the Model menu within an open MySQL Model or EER Diagram tab. Beneath the menu item are a number ...
https://dev.mysql.com/doc/refman/8.4/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/workbench/en/wb-relationship-editor.html
Use the Model menu, Menu Options menu item to set a project-specific default name for foreign keys. Foreign Key Tab The Foreign Key tab contains several sections: Referencing Table, Cardinality and Referenced Table. Double-clicking a relationship ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/metadata-locking.html
Locks might be acquired in a different order for implicitly used tables (such as tables in foreign key relationships that also must be locked). Metadata locks are extended, as necessary, to tables related by a foreign key constraint to prevent ...