PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
Incompatible change: MySQL 5.6.22 and later recognized the REFERENCES privilege but did not entirely enforce it; a user with at least one of SELECT, INSERT, UPDATE, DELETE, or REFERENCES could create a foreign key constraint on a table. This means ...Configuration Changes System Table Changes Server Changes InnoDB Changes SQL Changes Configuration Changes Incompatible change: In MySQL 5.7.11, the default --early-plugin-load value is the name of the keyring_file plugin library file, causing that plugin to be loaded by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
(NDB 7.5.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. A common error among users is to assume ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/5.7/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 ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
Prior to 5.7.16, a foreign key constraint cannot reference a secondary index defined on a virtual generated column. In MySQL 5.7.13 and earlier, InnoDB does not permit defining a foreign key constraint with a cascading referential action on the base ...The data length of logged values is limited by the index key limit of 767 bytes for COMPACT and REDUNDANT row formats, and 3072 bytes for DYNAMIC and COMPRESSED row ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/refman/5.7/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/refman/5.7/en/innodb-benefits.html
If you split up related data into different tables, you can set up foreign keys that enforce referential integrity. When you design a database with appropriate primary key columns for each table, operations involving those columns are automatically ... InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-added-deprecated-removed-7-6.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/refman/5.7/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. The IGNORE keyword has no effect when used with ALTER TABLE ... There are no rows in nt that lie outside the boundaries of the partition ...