Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-check-availability.html
Issue a SHOW ENGINES statement to view the available MySQL storage engines.
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
InnoDB tables arrange your data on disk to optimize queries based on primary keys. InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-moving-data-files-offline.html
The innodb_directories variable, which defines directories to scan at startup for tablespace files, supports moving or restoring tablespace files to a new location while the server is offline. During startup, discovered tablespace files are used ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-midpoint_insertion.html
In mixed workloads where most of the activity is OLTP type with periodic batch reporting queries which result in large scans, setting the value of innodb_old_blocks_time during the batch runs can help keep the working set of the normal workload in ... Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-purge-configuration.html
InnoDB does not physically remove a row from the database immediately when you delete it with an SQL statement. A row and its index records are only physically removed when InnoDB discards the undo log record written for the deletion. This removal ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
Isolation is the I in the acronym ACID; the isolation level is the setting that fine-tunes the balance between performance and reliability, consistency, and reproducibility of results when multiple transactions are making changes and performing ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-model.html
InnoDB performs locking at the row level and runs queries as nonlocking consistent reads by default, in the style of Oracle. The InnoDB transaction model aims to combine the best properties of a multi-versioning database with traditional two-phase ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-scheduling.html
InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are waiting for locks. When multiple transactions are waiting for a lock on the same object, the CATS algorithm determines which transaction ...
https://dev.mysql.com/doc/refman/8.4/en/insert-select.html
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { SELECT ... | TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE ...