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/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
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. System variables that are true or false can be enabled at server startup by naming them, or disabled by ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
IMPORT TABLESPACE does not enforce foreign key constraints on imported data. This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
Gap locking is only used for foreign-key constraint checking and duplicate-key checking. Transaction isolation is one of the foundations of database processing. Isolation is the I in the acronym ACID; the isolation level is the setting that ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ... [ON DUPLICATE KEY UPDATE assignment_list] ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
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. The file can be read from the server host or the client host, depending on whether the LOCAL ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
This does not enable the table to grow beyond the max_heap_table_size value, which still acts as a constraint on maximum table size. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
A MERGE table cannot maintain uniqueness constraints over the entire table. The following are known problems with MERGE tables: MERGE child tables are locked through the parent table. If the parent is a temporary table, it is not locked, and thus ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 13.7.2.2, “CHECK TABLE ...