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/mysql-cluster-programs-ndb-restore.html
Beginning with NDB 7.5.24 and NDB 7.6.20, this option also drops any foreign keys specified in the backup. This may be desirable when backing up and restoring between different schema versions with primary key changes on one or more tables, and it ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/5.7/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. The locks are normally ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
Strict mode does not affect whether foreign key constraints are checked. NO_KEY_OPTIONS Do not print MySQL-specific index options in the output of SHOW CREATE TABLE. Strict mode produces an error for attempts to create a key that exceeds the maximum ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
In this case, gap locking is disabled for searches and index scans and is used only for foreign-key constraint checking and duplicate-key checking. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
Enabling innodb_locks_unsafe_for_binlog does not disable the use of gap locking for foreign-key constraint checking or duplicate-key checking. For example, you might change the port that memcached listens on, reduce the maximum number of ... System ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Index Handling To ignore foreign key constraints during the load operation, execute a SET foreign_key_checks = 0 statement before executing LOAD DATA. Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the ...The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
This is the case for transactions that have empty or partial write sets, transactions that update tables without primary or unique keys, and transactions that update parent tables in a foreign key relationship. If the table containing the row has a ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
All numeric key values are stored with the high byte first to permit better index compression. For the case of a key longer than 250 bytes, a larger key block size than the default of 1024 bytes is used. When rows are inserted in sorted order (as ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
MEMORY tables can have up to 64 indexes per table, 16 columns per index and a maximum key length of 3072 bytes. If a MEMORY table hash index has a high degree of key duplication (many index entries containing the same value), updates to the table ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-ddl-operations.html
Foreign key constraints can make a TRUNCATE statement work like a regular DELETE statement, in which case a sequence of commands like DROP TABLE and CREATE TABLE might be fastest. Many DDL operations on tables and indexes (CREATE, ALTER, and DROP ...