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/group-replication-single-primary-mode.html
For example, changes to tables that have cascading foreign keys are allowed, whereas in multi-primary mode they are not. In this mode the group has a single-primary server that is set to read-write mode. All the other members in the group are set ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
For example, internally generated foreign key constraint names consist of the table name plus _ibfk_ and a number. The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
IMPORT TABLESPACE feature does not enforce foreign key constraints on imported data. This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-monitor-types.html
There are two types of InnoDB monitor: The standard InnoDB Monitor displays the following types of information: Work done by the main background thread Semaphore waits Data about the most recent foreign key and deadlock errors Lock waits for ...
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/metadata-locking.html
Locks might be acquired in a different order for implicitly used tables (such as tables in foreign key relationships that also must be locked). MySQL uses metadata locking to manage concurrent access to database objects and to ensure data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 4. ndbinfo is a database containing ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-plugin-information.html
row *************************** PLUGIN_NAME: InnoDB PLUGIN_VERSION: 1.0 PLUGIN_STATUS: ACTIVE PLUGIN_TYPE: STORAGE ENGINE PLUGIN_TYPE_VERSION: 50158.0 PLUGIN_LIBRARY: ha_innodb_plugin.so PLUGIN_LIBRARY_VERSION: 1.0 PLUGIN_AUTHOR: Innobase Oy ...
https://dev.mysql.com/doc/refman/5.7/en/replication-compatibility.html
For example, foreign key names longer than 64 characters are no longer supported from MySQL 8.0. MySQL supports replication from one release series to the next higher release series. For example, you can replicate from a source running MySQL 5.6 to ...