Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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. For foreign key checks, a shared read-only lock (LOCK TABLES READ) is taken on related tables. Locking MyISAM tables ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/connectors/en/connector-net-ref-efcore.html
MySql.EntityFrameworkCore.Migrations.Operations Namespace Classes Class Description MySQLDropPrimaryKeyAndRecreateForeignKeysOperation A migration operation for dropping a primary key and recreating foreign keys. Namespaces in this section: ...
https://dev.mysql.com/doc/connector-net/en/connector-net-ref-efcore.html
MySql.EntityFrameworkCore.Migrations.Operations Namespace Classes Class Description MySQLDropPrimaryKeyAndRecreateForeignKeysOperation A migration operation for dropping a primary key and recreating foreign keys. Namespaces in this section: ...
https://dev.mysql.com/doc/ndbapi/en/mccj-issues.html
NDB tables support foreign keys, and foreign key constraints are enforced when using ClusterJ for inserts, updates, and deletes. TIMESTAMP: Currently, ClusterJ does not support the TIMESTAMP data type for a primary key field. This section discusses ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbconfiguration-category.html
Foreign Key Checks Enabled Whether foreign key constraint checking is enabled/disabled globally. Large Prefix Enabled Enable this option to allow index key prefixes longer than 767 bytes (up to 3072 bytes), for InnoDB tables that use the DYNAMIC and ... Lists the InnoDB Configuration configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 28.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-innodb-engines.html
For those unaccustomed to working with NDB, unexpected behaviors can arise due to its distributed nature with regard to transactions, foreign keys, table limits, and other characteristics. The NDB storage engine is implemented using a distributed, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
For example, since MyISAM ignores foreign key constraints, an INSERT or UPDATE statement accessing an InnoDB table on the source might cause a foreign key violation but the same statement performed on a MyISAM version of the same table on the ... If ...