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-linux-native-aio.html
InnoDB uses the asynchronous I/O subsystem (native AIO) on Linux to perform read-ahead and write requests for data file pages. This behavior is controlled by the innodb_use_native_aio configuration option, which applies to Linux systems only and is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-ddl.html
If this option is set to a value greater than 1, use READ UNCOMMITTED queries to find rows that were just inserted. You can access the underlying InnoDB table (which is test.demo_test by default) through standard SQL interfaces. However, there are ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
Concurrent queries are permitted with ALGORITHM=COPY for tables partitioned by HASH or LIST, as MySQL copies the data while holding a shared lock. Online support details, syntax examples, and usage notes for DDL operations are provided under the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html
After restarting a busy server, there is typically a warmup period with steadily increasing throughput, as disk pages that were in the buffer pool are brought back into memory (as the same data is queried, updated, and so on). To reduce the warmup ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-tablespace-autoextend-size.html
By default, when a file-per-table or general tablespace requires additional space, the tablespace is extended incrementally according to the following rules: If the tablespace is less than an extent in size, it is extended one page at a time. If ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-temporary-tablespace.html
InnoDB uses session temporary tablespaces and a global temporary tablespace. Session Temporary Tablespaces Session temporary tablespaces store user-created temporary tables and internal temporary tables created by the optimizer when InnoDB is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored in the InnoDB data dictionary. If you move data files around, dictionary data can become inconsistent. If a data dictionary corruption or consistency issue prevents you from starting InnoDB, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/is-null-optimization.html
MySQL can also optimize the combination col_name = expr OR col_name IS NULL, a form that is common in resolved subqueries. MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = constant_value. For example, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/key-cache-restructuring.html
File system caching is not as efficient as using a key cache, so although queries execute, a slowdown can be anticipated. However, restructuring does not block queries that need to use indexes assigned to the cache. A key cache can be restructured ...