Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
If the table has a foreign key relationship, foreign_key_checks must be disabled before executing DISCARD TABLESPACE. Also, you should export all foreign key related tables at the same logical point in time, as ALTER TABLE ... IMPORT TABLESPACE does ...The .cfp file contains a transfer key and an encrypted tablespace ... This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Hash index pages: These are allocated as 8 KB subpages, and store the primary key hash index structure. Each row also has a primary key hash index entry (corresponding to the hidden primary key that is part of every NDB table). memory_per_fragment ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-mta.html
Conversely, transactions performing inserts, updates and deletes on foreign key child tables (referencing) are not especially serialized with regard to one another. Transaction Dependency and Writeset Handling Transaction dependencies are detected ...To use this functionality with NDB Cluster, it is necessary that the replica be configured to use multiple worker ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
For storage engines that support both atomic DDL and foreign key constraints, creation of foreign keys is not permitted in CREATE TABLE ... For example: mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (a), KEY(b)) -> ... You ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #36511673) InnoDB: A DELETE operation on a table with a self referential foreign key and full-text index could have triggered an assertion. (Bug #33691659) InnoDB: An update operation attempted to update a virtual column while building an ...
https://dev.mysql.com/doc/ndbapi/en/ndb-object.html
This section provides information about the Object class, which contains meta-information about database objects such as tables and indexes. Description This parameter specifies how data in the table or index is distributed among the cluster's data ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
On storage engines that support both atomic DDL and foreign key constraints, creation of foreign keys is not permitted in CREATE TABLE ... An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes ...
https://dev.mysql.com/doc/refman/8.4/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 ...Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the expression used to compute column ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-best-practices.html
For fast join performance, define foreign keys on the join columns, and declare those columns with the same data type in each table. Adding foreign keys ensures that referenced columns are indexed, which can improve performance. Foreign keys also ...