Search Results
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 3. To maintain data integrity, InnoDB also ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
Foreign key referential actions (ON UPDATE, ON DELETE) are prohibited on columns used in CHECK constraints. Likewise, CHECK constraints are prohibited on columns used in foreign key referential actions. CREATE TABLE permits the core features of ...
https://dev.mysql.com/doc/workbench/en/wb-connection-properties.html
By default, the name is the name of the foreign key and the property is centered above the connection line. This is used, for example, when drawing MyISAM tables with a visual relationship, but with no foreign keys. Note that this is not the name of ...When a connection is selected, it is highlighted and its properties are displayed in the properties ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-innodb-usage.html
When comparing application feature requirements to the capabilities of InnoDB with NDB, some are clearly more compatible with one storage engine than the other. The following table lists supported application features according to the storage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
Thus, it does not cause ON DELETE triggers to fire, it cannot be performed for InnoDB tables with parent-child foreign key relationships, and it cannot be rolled back like a DML operation. TRUNCATE TABLE fails for an InnoDB table or NDB table if ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
(NDB 8.4.0) Maximum scan batch size used for building foreign keys. Increasing the value set for this parameter may speed up building of foreign key builds at the expense of greater impact to ongoing traffic. Consider this table definition: CREATE ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
restrict_fk_on_non_standard_key: Disallow creation of foreign keys on non-unique or partial keys. restrict_fk_on_non_standard_key: Disallow creation of foreign keys on non-unique or partial keys. Options and Variables Introduced in MySQL 8.4 ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
Dropping a FOREIGN KEY constraint does not work in replication because the constraint may have another name on the replica. DELETE if you are deleting rows from a table that has foreign keys with ON DELETE CASCADE properties. SELECT if you have ...