Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
If a transaction executes against a table that has foreign keys with cascading constraints, then the transaction fails to commit when synchronizing itself with the group. This section lists the system variables that are specific to the Group ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
It is not true for names of columns, constraints, databases, partitions, statements prepared with PREPARE, tables, triggers, users, and user-defined variables. In MySQL, databases correspond to directories within the data directory. Each table ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-indexes-table.html
Examples: PRIMARY for a primary key index, GEN_CLUST_INDEX for the index representing a primary key when one is not specified, and ID_IND, FOR_IND, and REF_IND for foreign key constraints. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
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 database.
https://dev.mysql.com/doc/refman/8.4/en/innodb-disk-management.html
Within these constraints, InnoDB tries to optimize the database work and the organization of disk files to minimize the amount of disk I/O. As a DBA, you must manage disk I/O to keep the I/O subsystem from becoming saturated, and manage disk space ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/en/innodb-parameters.html
innodb_buffer_pool_debug Command-Line Format --innodb-buffer-pool-debug[={OFF|ON}] System Variable innodb_buffer_pool_debug Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value OFF Enabling this option permits multiple buffer ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.4/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 ...