Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
You can create and drop indexes and perform other DDL operations with much less impact on performance and availability. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-best-practices.html
Run the server with the --sql_mode=NO_ENGINE_SUBSTITUTION option to prevent tables from being created with storage engines that you do not want to use. Specify a primary key for every table using the most frequently queried column or columns, or an ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression.html
Using the compression features of InnoDB, you can create tables where the data is stored in compressed form. This section provides information about the InnoDB table compression and InnoDB page compression features. The page compression feature is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point in time, and no changes made by later or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks-handling.html
Another way to serialize transactions is to create an auxiliary “semaphore” table that contains just a single row. This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock Detection”. It explains how ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-disk-io.html
InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, while permitting other database operations to proceed while the I/O is still in progress. On Linux and Windows platforms, InnoDB uses the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-enabling-monitors.html
When this option is used, InnoDB creates a file named innodb_status.pid in the data directory and writes output to it every 15 seconds, approximately. When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-limits.html
If you reduce the InnoDB page size to 8KB or 4KB by specifying the innodb_page_size option when creating the MySQL instance, the maximum length of the index key is lowered proportionally, based on the limit of 3072 bytes for a 16KB page size. This ...
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-performance-optimizer-statistics.html
You can use the STATS_PERSISTENT, STATS_AUTO_RECALC, and STATS_SAMPLE_PAGES clauses with CREATE TABLE and ALTER TABLE statements to configure optimizer statistics for individual tables. This section describes how to configure persistent and ...