PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/lock-tables.html
If you lock a table explicitly with LOCK TABLES, any tables related by a foreign key constraint are opened and locked implicitly. LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ... lock_type: { READ ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/en/metadata-locking.html
Metadata locks are extended, as necessary, to tables related by a foreign key constraint to prevent conflicting DML and DDL operations from executing concurrently on the related tables. MySQL uses metadata locking to manage concurrent access to ...
https://dev.mysql.com/doc/refman/8.0/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 15.7.3.2, “CHECK TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-objects.html
This is also true for dropping these objects, subject to the following constraints: A log file group cannot be dropped as long as any tablespaces use it. NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-importing-data.html
Otherwise, it is possible for later statements in same session may also be executed without enforcing transactions or foreign key constraints, and which could lead to data inconcsistency. It is common when setting up a new instance of NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-workloads.html
Due to its distributed architecture and multi-node implementation, NDB Cluster also has specific constraints that may keep some workloads from performing well. NDB Cluster has a range of unique attributes that make it ideal to serve applications ...