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/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.0/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.0/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.0/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.0/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.0/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.0/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/8.0/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/8.0/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)] ... | TABLE table_name | VALUES ...
https://dev.mysql.com/doc/refman/8.0/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. Some keywords which are otherwise ...