Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/upgrade-prerequisites.html
There must be no tables that have foreign key constraint names longer than 64 characters. Before upgrading to the latest MySQL 8.4 release, ensure the upgrade readiness of your current MySQL 8.3 or MySQL 8.4 server instance by performing the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
Running ALTER TABLE statements that construct indexes, ADD or DROP columns, or add enforced check constraints. Before MySQL 8.4.0, Lakehouse does not enforce any specified constraints on primary key, unique key, foreign key, and CHECK constraints.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
mysql> CREATE EXTERNAL TABLE table_1( col_1 int, col_2 int, col_3 int) FILE_FORMAT = (FORMAT csv) FILES = (URI = 'oci://mybucket@mynamespace/data_files/data_file_1.csv') STRICT_LOAD = 0; VERIFY_KEY_CONSTRAINTS: Lakehouse validates primary key and ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or ...
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-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/8.4/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/8.4/en/invisible-columns.html
Foreign key constraints can be defined on invisible columns, and foreign key constraints can reference invisible columns. For new or modified rows, violation of a CHECK constraint on an invisible column produces an error. An invisible column is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
The unique constraint is implemented by a separate table with b as primary key and a as a column. Thus, for one million records, we need 58MB for index memory to handle the hash indexes for the primary key and the unique constraint. They are also ...