Search Results
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
The statements added at the start of the code are: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, ...Next, confirm that the SSL CA File, ... FAQ Categories Basic Usage MySQL Workbench Functionality Data Management General Basic Usage ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
If you have FOREIGN KEY constraints in your tables, you can speed up table imports by turning off the foreign key checks for the duration of the import session: SET foreign_key_checks=0; ... SET foreign_key_checks=1; For big tables, this can save a ...If you have UNIQUE constraints on secondary keys, you can speed up table imports by temporarily turning off the uniqueness checks during the import session: SET unique_checks=0; ...
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. Index definitions can name invisible columns, including definitions for PRIMARY KEY and UNIQUE indexes. For statements that ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-ndbd.html
MaxFKBuildBatchSize: Maximum scan batch size to use for building foreign keys. Increasing this value may speed up builds of foreign keys but impacts ongoing traffic as well. MaxUIBuildBatchSize: Maximum scan batch size to use for building unique ...
https://dev.mysql.com/doc/connectors/en/connector-python-coding.html
You make sure that related data is kept in sync between different tables by setting up foreign key relationships. Another recommendation is to declare a numeric primary key for each table, which offers the fastest way to look up values and can act ...For example, in MySQL tables, you typically use numeric IDs rather than string-based dictionary keys, so that the key values are compact and have a predictable ... The following guidelines cover aspects of developing MySQL applications that might not be ...
https://dev.mysql.com/doc/connector-python/en/connector-python-coding.html
You make sure that related data is kept in sync between different tables by setting up foreign key relationships. Another recommendation is to declare a numeric primary key for each table, which offers the fastest way to look up values and can act ...For example, in MySQL tables, you typically use numeric IDs rather than string-based dictionary keys, so that the key values are compact and have a predictable ... The following guidelines cover aspects of developing MySQL applications that might not be ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
If you use a multiple-table UPDATE statement involving InnoDB tables for which there are foreign key constraints, the MySQL optimizer might process tables in an order that differs from that of their parent/child relationship. Each value can be given ... UPDATE is a DML statement that modifies rows in a ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
MaxFKBuildBatchSize: Maximum scan batch size to use for building foreign keys. Increasing this value may speed up builds of foreign keys but impacts ongoing traffic as well. MaxUIBuildBatchSize: Maximum scan batch size to use for building unique ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
DatabaseMetaData Foreign key information (getImportedKeys()/getExportedKeys() and getCrossReference()) is only available from InnoDB tables. The driver uses SHOW CREATE TABLE to retrieve this information, so if any other storage engines add support ...The SELECT must cover all columns that make up the primary ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
DatabaseMetaData Foreign key information (getImportedKeys()/getExportedKeys() and getCrossReference()) is only available from InnoDB tables. The driver uses SHOW CREATE TABLE to retrieve this information, so if any other storage engines add support ...The SELECT must cover all columns that make up the primary ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the ...